If you have a Power BI table where the data source is a SharePoint Online list and you’re wondering how to insert SharePoint list item link to each row then this article is for you. Here are the step by step guide on how to get it done:
- Go to Home >> Transform Data >> Transform Data
- Select the Id column and “Change the Type” to text. This will come handy when we will construct the link URL at step 6.
- Go to Add Column >> Custom Column
- Give it a name (e.g. LinkToURL).
- In the Custom column formula, paste the URL of the SharePoint list item:
=”https://domain.sharepoint.com/teams/SiteName/Lists/ListName/DispForm.aspx?ID=”&
Change the domain, site and list url based on your scenario. This URL will redirect you to the display form but if you want to redirect to the edit page then just change it to EditForm.aspx.- From the Available columns, double click the ID column and it will be appended to the above URL to make it look like the following:
=”https://domain.sharepoint.com/teams/SiteName/Lists/ListName/DispForm.aspx?ID=”& [Id]
If we would not have converted the ID column to text then we will get type mismatch error while creating this custom column.
- From the Available columns, double click the ID column and it will be appended to the above URL to make it look like the following:
- Click On OK and the new column with the URLs will be added in the table.
- If you want to use Title or any column to redirect users to list item page then select the table, chose the Title column or any column based on your need, click on Conditional Formatting >> Web URL.
- In the “Format Style”, keep “Field Value, “Apply to” to have “Values Only” and “What field should we base this on” should have the new custom field (LinkToURL) selected. Keep “Summarization” as First, click on OK.
- The Title field now has hyperlinks to SharePoint List item.
Hope it helps. For any question, please post it in comments section.
