Forum Discussion

Brass Contributor

Jun 14, 2018

Updating a Hyperlink field (both url and description) using Flow?

I tried using the update item action to set a Hyperlink type column in my custom list. The Flow field for this column only accepts the url so there seems to be no way to add the description part. Any...

Copper Contributor

If you're still having issues implementing the REST API I wrote a blog post on how to update hyperlinks below:

https://www.dmcinfo.com/latest-thinking/blog/id/9832/creating-sharepoint-list-items-in-microsoft-flow-using-a-rest-api

mo_mkf

Copper Contributor

Mar 15, 2019

Hey danmitchell36,

Thanks for the link, I gave yours a try, but got this error:

Not well formatted JSON stream.
clientRequestId: 865768ab-bec3-44ed-a436-fb15aa25cd69
serviceRequestId: a805c99e-a06d-8000-aa83-4de13cfb3351

Thanks

StephanieCutiyog
Copper Contributor
Aug 13, 2019
mo_mkf
Did you ever figure out the No weel formatted JSON stream error? I'm getting the same
Jean-Paul van den Bogert
Copper Contributor
Oct 30, 2020
mo_mkf Probably because his code contains the wrong quotes:
“ AND ”
If you replace them with the default quotes
" AND "
Then the JSON error is resolved

{ "Title": "Test", "Link":{ "_metadata": {"type": "SP.FieldUrlValue"}, "Description": "Link", "Url": "https://www.google.com" } }