Forum Discussion

shyamily_123's avatar
shyamily_123
Frequent Visitor
3 years ago

How to add SharePoint link as hyperlink to column

I have a requirement to add hyperlink in one of my column called projectname. Secenario is like this, My dataset is SharePointand it contains the list of projects created by client. When client fil...
Need Help
shyamily_123's avatar
shyamily_123
Frequent Visitor
3 years ago

v-jingzhang Yes,these projects are in the same sharepoint site . Now i have 180 projects in that share point. My dashboard has a table visual which contains all columns and rows present in the sharepoint list. Client want to open sharepouint list when he click on any project name from project column.We tried with hyperlink , it opens the sharepoint list but what we need is when he click on any project name in the table visual this hyperlink should redirect to that exact row in sharepoint list.

Will it possible with power bi ?

Please help!!!

 

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi shyamily_123 

 

If I understand it correctly, all projects are in the same sharepoing list. So if we want to redirect to a specific row in the sharepoint list, we need to be able to identify every row through the URL. 

 

Based on my test, every item in a Sharepoint list has a unique link for access. However I'm not sure if we can export these links along with all columns of items. So the next step is to find ways to get these links in bulk. However, I haven't found the solution yet. 

Best regards,

Jing

 

  • shyamily_123's avatar
    shyamily_123
    Frequent Visitor
    3 years ago

    Hi v-jingzhang ,

    Thanks. Now we are trying to auto populate url of each row from SharePoint list  using dyanmic formulas like DAX or calculated measure. When new raw is inserted then sharepoint will auto populate that row's url. Is there any solution for that other than using Power app?