cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate I
Advocate I

Update Hyperlink field without loosing description

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Dual Super User II
Dual Super User II

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

View solution in original post

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?

View solution in original post

5 REPLIES 5
Super User II
Super User II

@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.

Dual Super User II
Dual Super User II

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

View solution in original post

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?

View solution in original post

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. 

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (9,884)