Jun 14 2018 05:26 AM
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:
In Flow:
Jun 14 2018 11:32 AM - edited Jun 14 2018 11:34 AM
Set the value to "URL, Description" without quotes, has to have URL then comma then a space after comma then Description.
Jun 14 2018 10:53 PM
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?
Aug 29 2018 12:31 AM - edited Aug 31 2018 12:04 AM
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
Oct 29 2018 03:00 AM
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?
Nov 07 2018 02:19 AM
Nov 07 2018 07:01 PM
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
Feb 20 2019 01:36 AM
Feb 22 2019 12:49 AM
@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 :)
Mar 08 2019 03:27 PM
I was trying to get this to work and I keep running to the following error:
Mar 10 2019 08:17 PM
Its not the "category term="
Look for the tag:
<d:ListItemEntityTypeFullName></d:ListItemEntityTypeFullName>
If that doesn't work, take a screenshot of your flow
Mar 11 2019 06:01 AM
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.
Mar 12 2019 06:19 PM
You need to browse to _api/web/lists/getbytitle('Accounts') to find that tag.
Flow looks good. I don't see any issues there
Mar 13 2019 06:30 AM
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.
Mar 13 2019 01:42 PM
If you're still having issues implementing the REST API I wrote a blog post on how to update hyperlinks below:
Mar 13 2019 06:39 PM
Is your list a custom list?
Is the X-RequestDigest required in your Flow? That is something mine doesn't have
Mar 14 2019 01:24 PM
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.
Mar 15 2019 07:14 AM
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
Aug 13 2019 11:38 AM
Did you ever figure out the No weel formatted JSON stream error? I'm getting the same
Jun 30 2020 07:16 AM
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.