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
Solved! Go to Solution.
You would have to use the http rest api sharepoint option in Flow
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
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?
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.
You would have to use the http rest api sharepoint option in Flow
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
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?
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 ,
Please refer to the method mentioned in the links above to update the hyperlink field, you need to use the Rest API.
Best Regards,
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
8 | |
5 | |
4 | |
3 | |
3 |