Latest Enterprise DNA Initiatives


URL for each item of list on SharePoint

DAX Calculations
#1

Hi there,

I am reading a list from SharePoint online. Now I want to get the URL of each record or item of the list and present it in the dashboard so that when the user clicks on the URL the record appears on the browser. I tried to find the URL of an individual item of the list on share point in query editor mode but could not find it. I found the URL of the attachment but it’s not very helpful. Could anyone help me how can I find the URL of the item on the list from Sharepoint?

Sorry for the inconvinence. I can attach the sample file. However, as the source is SharePoint, other members would not able to open in the query editor mode.

#2

Hi @leo_89

You can use Keyword Query Language (KQL) and search by ID, Example ListItemID:3

image
image1281×409 31.5 KB

Use the url to create the link on DAX or PQ

On PQ you have the ID of each item

image
image575×1051 21.8 KB

2 Likes
#3

Hi @leo_89, did the response provided by @jbressan help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

#4

Hi @leo_89, we’ve noticed that no response has been received from you since August 10.

We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

#5

Hi @leo_89, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.