Sharepoint Online List - Direct link to item

[ZowieS]

Hi,

Do anyone know were I can get the direct link to an item in a Sharepoint Online list fin Power Bi?

I want to add those like to each items so the conumsers can click in the link and get direkted to that item in the list.

I've google around and I have been sitting for awhile in Power Bi Desktop and looked around but I haven't found anything.

Anyone have any idé?

Thanks!

[ZowieS]

@amitchandak & @rubinboer,

Thank you for your help!

I'm sorry but you are a bit head of me here 😅

I still havn't found the URL in the dataset of all the colums I get when I connect to a Shrepoint Online List.

[amitchandak]

@ZowieS , see if this can help

https://community.powerbi.com/t5/Desktop/Hyperlink-to-Sharepoint-Online-List-in-a-table-coloumn-no-h...

[ResRudeBoy]

Were you able to add a link to each item by ID? If so could please explain what you did as i would like to also do this. thanks

[rubinboer]

hi there try this.

create a measure

SP ItemHyperLink =  SELECTEDVALUE('TableWithUrl'[ColumWithUrl'])

ColumnWithUrl is the link that you want to direct to in sharepoint

Add a button

Switch the action to on

Configure Web URL : Field Vaue and Based on URL is the measure SP ItemHyperLink