Forum Discussion
Solved
Preserve SharePoint List absolute URL in report
Hey folks, I'm building a report that brings in various fields from a SharePoint list. One of those fields is the URL to the specific SharePoint list record. In the list the record is stored cor...
Hi gemcityzach
You can use this
= Table.TransformColumns(#"Changed Type", {{"Link_to_record", each if _="" then "https://sharepoint.companyname.com/teams/XXXXX" else "https://sharepoint.companyname.com" & _, type text}})Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi gemcityzach
You can use this
= Table.TransformColumns(#"Changed Type", {{"Link_to_record", each if _="" then "https://sharepoint.companyname.com/teams/XXXXX" else "https://sharepoint.companyname.com" & _, type text}})
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
This worked out nicely. Thank you!