Unanswered

Keep alternative text in hyperlink column in Sharepoint Lists when running Flow

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone,

I create a Flow to automatically update Today's date in a column in my SharePoint List. However, after I run the flow, the alternative text I've written for each item in a hyperlink column is changed into the original link. I found the problem is that, in the UPDATE ITEM step in my Flow, I have to match the correct fields (Photo 1-yellow highlighted are hyperlinked in Lists) and after running the flow the returns turn out to be the original link (Photo 2).

How can I run the flow while keeping the alternative text instead of the original link? Thank you

All responses (2)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Keep alternative text in hyperlink column in Sharepoint Lists when running Flow

Thank you for your help. Appreciate it!
Expiscornovus 31,635 Most Valuable Professional on at

Like (0)

Report

Re: Keep alternative text in hyperlink column in Sharepoint Lists when running Flow

Hi @Anonymous,

Unfortunately that is a limitation of the update item action. You can only update it with a string value, which means you will lose the alternative text.

A workaround could be to use a Send an HTTP request to SharePoint action with the validateUpdateListItem method instead of the Update Item to update your list item.

Below is an example from @tom_riha which demonstrates such an update for a hyperlink type of field:

https://tomriha.com/update-single-sharepoint-hyperlink-column-in-power-automate-flow/