Hello everyone! I have a Power Automate Flow that I use to get the properties of newly posted files from a SharePoint Library, then create hyperlinks for each of them by combining some of those file properties (e.g.: link to item, file name, and summary), and then share those hyperlinks via email to a distribution list.
For the creation of the hyperlink, I use a Select Data Operation action:
- The ‘From’ field contains the “value” from a preceding Get files (properties only) action.
- The ‘Map’ field was switched to text mode, and it contains a hyperlink expression. Below is what the Select Data Operation action card looks like, as well as the expression from the ‘Map’ field:
"<a href=\"@{item()?['{Link}']}\">@{item()?['{Name}']}</a><br>@{item()?['Summary']}"
The flow has been working well. In fact, it’s been running for years now. However, every time I open the flow, certain characters disappear from the ‘Map’ expression, and I get a json error. So, I need to re-enter those characters before I can save any other update to the flow. The image below shows what the Select card looks like every time I open the flow. The overlapping image highlights the characters that always disappear, and which I need to re-enter every time.
Can someone help me understand why this happens? Is there a way to make those characters stick and not disappear? Or is there a better way to create the hyperlink from the file properties?
Thank you!
YL
