Update Hyperlink field without loosing description

[AlbertoBenini]

Hi, 

in my flow i have to update an item that contains a hyperlink field. 

That field does not change after the item creation, but being mandatory, i have to put it in the update item actions. 

Doing this, when the item is updated that field is updated too and it loose the description.

Example: my hyperlink start like this

URL: www.pippo.com

Desc: PIPPO

after the update this is what i get

URL: www.pippo.com

Desc: www.pippo.com

Is there an easy way do fix this?

Without creating other columns eccetera

Many thanks

[edgonzales]

@AlbertoBenini 

Hi there.  Interesting issue, is there a way to get the Display (description) before the update?  If so, try updating with this expression:

=CONCATENATE("<a href='",<URL>,"' target='_blank'>",<Display>,"</a>")

Where <URL> is your dynamic value with the link, and <Display> is the dynamic value of the description text.

Keep us posted.

-Ed-

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[RezaDorrani · Accepted solution]

Hi @AlbertoBenini 

You would have to use the http rest api sharepoint option in Flow

https://techcommunity.microsoft.com/t5/PowerApps-Flow/Updating-a-Hyperlink-field-both-url-and-descri...

check the comment from Jason H in this post

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[AlbertoBenini · Accepted solution]

Hi Ed, 

thanks for your help. 

unfortunatly that formula doesn't works. I can get URL and Description, but then the concat function (not concatenate) return a string, while the hyperlink field is not a string. So i get an 'Expression is invalid' error. 

Am I missing something?

[AlbertoBenini]

Hi Reza, 

thanks for the suggestion. 

I know that with the rest api I can update that field (I use it to get the hyperlink fields), but I'd like to do it without it because that would trigger again my flow and I prefer to avoid it. Retriggering is not a big problem, it's managed, but i would like to minimize the running istances.

If there is no other option I will use the rest api. 

[v-bacao-msft]

Hi @AlbertoBenini ,

https://powerusers.microsoft.com/t5/Building-Flows/update-link-AND-text-in-Hyperlink-field-of-ShareP...

https://www.dmcinfo.com/latest-thinking/blog/id/9832/creating-sharepoint-list-items-in-microsoft-flo...

Please refer to the method mentioned in the links above to update the hyperlink field, you need to use the Rest API.

Best Regards,