Forum Discussion

Henning Strand's avatar
Henning Strand
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...
Microsoft Flow
sharepoint
danmitchell36's avatar
danmitchell36
Copper Contributor
Mar 13, 2019

Henning Strand ,

 

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's avatar
    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

    • Jean-Paul van den Bogert's avatar
      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"
  }
}

       

    • StephanieCutiyog's avatar
      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

Resources