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

My requirement is when i click on a  project name it should redirect to that exact row in SharePoint.

Above solution is useful when i want to open that sharepoint list. Here that's not the case, i want to open that sharepoint site and the row that i clicked on power bi table visual.

 

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi shyamily_123 

 

Are these projects in the same sharepoint site? Do they have a similar URL format? If they do, you can add a column to get the dynamic URLs by concatenating the basic URL section and project name column. For exmaple, 

URL column = "https://xxxxxxbasicURLxxx/" & 'TableName'[Project Name]

 

Best regards,

Jing