Hey everyone,
I’m running into the following issue:
When my Power Automate flow reads a file from a folder and I try to store the link to it in a SharePoint list, the URL is too long for a standard Hyperlink column.
So I did some research and used a Multiple lines of text column (Rich Text) instead.
The flow works perfectly and writes the link correctly into the list, but afterwards the links are not clickable, unlike when I enter the same link manually.
The weird part: If I manually open the item in edit mode after the flow has run and add something simple at the end of the field (for example a single space), SharePoint seems to “re-interpret” the content and the link becomes clickable again.
In the last screenshot of my attachments, you can clearly see that once I added a single space, the link became clickable.
I also considered automatically shortening the long URL via another flow (e.g., Bitly), but that’s not allowed for me due to data protection policies.
Does anyone have a quick fix or a tip on how to make these links automatically clickable, without using external URL shorteners?
Thanks a lot!