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

Brass Contributor

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. Anyone got this working?

 

In SharePoint:

URLFieldShP.jpg

 

In Flow:

URLFieldFlow.jpg

22 Replies

Set the value to "URL, Description" without quotes, has to have URL then comma then a space after comma then Description.

Thanks, but that is what I tried and that did not work. As you see from my attached image with "http://www.cnn.com, CNN" (without quotes), I get an error saying to add a proper URI. Or did I misunderstand you?

 

I too found updating the hyperlink description much harder than it should be.  The best solution that worked for me is detailed below.

 

I had a client ask for the ability to export individual items to Excel.  SPO export function by default exports all items so long story short I ended up using Flow.  I used the below action to update the URL to the CSV file and changed the display name to "CSV"

 

TestURL2 is the column name

 

2018-08-29_091344.png

Hi,

I have tried your solution, but I have an code error 412. 

message""La valeur «  » ETag de la demande ne correspond pas à la valeur « \"4\" » ETag de l'objet.

 The message are in french  ,but that said : Etag Request doesn't match to value 4 of the Etag Object.

Please can you help me?

 

unfortunately taxonomy values are not yet supported in Flow for tagging. it does not work.

1. Could it be that your column name is actually different to the display name?

 

You can check this by browsing to the URL

https://<sharepoint server or tenant>/<site collection>/<subsite>/_api/web/lists/getbytitle('<listname>')/Items

 

Then view the source which will display what your columns are actually named.

 

2.  Check that the "type" is correct.  This can also be found in the source above

3. Check that the destination column you are trying to update, is the type "Hyperlink or Picture"

 

See how you go with that.  If you still can't find the issue, send screenshots of your flow, attach the source file and screenshot the column type in list settings

Hi Jason, For me, it was bit complicated that my site name and list name contain some spaces. But, it just works fine. Thanks. Masahiro

@Deleted wrote:
Hi Jason, For me, it was bit complicated that my site name and list name contain some spaces. But, it just works fine. Thanks. Masahiro

I'm glad that worked for you Masahiro.  Yes spaces are nasty and I try to avoid them if I can :)

I was trying to get this to work and I keep running to the following error:

 

"The property '__metadata' does not exist on type 'SP.Data.AccountsListItem'. Make sure to only use property names that are defined by the type.\r\nclientRequestId: 2408701b-9fdd-49fc-8136-0d0a2244ce5d\r\nserviceRequestId: d614c79e-f0dd-8000-aa83-416edc2ce86f"
 
After a bit of searching around the best 'solution' I found was here: Solution?
However, I have gone to the URL and copied out the "category term=" exactly.
 
So, I'm not sure what else could be the culprit.
 
Any thoughts?
 
Thanks!

Its not the "category term="

Look for the tag:

 

<d:ListItemEntityTypeFullName></d:ListItemEntityTypeFullName>

 If that doesn't work, take a screenshot of your flow

Huh, I see several <d: entries, but none that say ListItemEntityTypeFullName, perhaps I'm looking in the wrong place. Attached is a screenshot of the flow. Thanks so much for your help.

 

flow.JPG

You need to browse to _api/web/lists/getbytitle('Accounts') to find that tag.

 

Flow looks good.  I don't see any issues there

Well, good news/bad news. I browse to that URL and found the entry for ListItemEntityTypeFullName, but bad news it is the same one I was trying to use from before. So, if that is the correct FullName then I'm not sure what the deal is.

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

 

 

 

Is your list a custom list?

 

Is the X-RequestDigest required in your Flow?  That is something mine doesn't have

Custom list: I believe so. In the site contents by type it just says list, but when I go to add a list my only options are Custom List or Custom List Database View, so I would have selected Custom List. 

 

I'll try it without the X-RequestDigest, I believe I saw that on some other form and gave it a try.

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

@mo_mkf 

Did you ever figure out the No weel formatted JSON stream error?  I'm getting the same

@Henning Strand

 

A co-worker and I found a work-around. We are not updating both parts of the Hyperlink field, but this works nicely as an alternative.

 

Instead of a hyperlink field, we use a Multiple Lines of Text field with the text type set to "Enhanced Rich Text". In the flow, we insert something like this into the field:

 

<a target="_blank" href="[CURRENT ITEM:URL]">[CURRENT ITEM:URL PREVIEW]</a>

 

[CURRENT ITEM:URL] and [CURRENT ITEM:ID] are the dynamic content. The result is a link that appears in the list, under whatever column you chose.

 

This method has the downside of being less user friendly (unless you hide the field in the New Item/Edit Item forms), but I find it simple and reliable.

 

A note to any Microsoft moderators reading this: I realize that this could potentially be abused to inject code into a list. If something must be done about it, I humbly request that either A) certain DOM elements are white-listed or black-listed as necessary, so that some part of this functionality will survive, or B) the functionality to resolve OP's question is implemented.