cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Dual Super User II
Dual Super User II

Re: Update Hyperlink field without loosing description

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

Highlighted
Advocate I
Advocate I

Re: Update Hyperlink field without loosing description

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
Highlighted
Super User II
Super User II

Re: Update Hyperlink field without loosing description

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

Highlighted
Dual Super User II
Dual Super User II

Re: Update Hyperlink field without loosing description

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

Highlighted
Advocate I
Advocate I

Re: Update Hyperlink field without loosing description

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

Highlighted
Advocate I
Advocate I

Re: Update Hyperlink field without loosing description

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. 

Highlighted
Community Support
Community Support

Re: Update Hyperlink field without loosing description

 

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (6,636)