cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlbertoBenini
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
RezaDorrani
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

@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
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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,330)