Forum Discussion
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...
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
Jason - there is a correction in your screenshot. YOu need to correct it to avoid confusion by reader.
Body Text is as follow:-
{'__metadata': {'type':'SP.Data.TaskListItem'},
'InternalFieldName':{'Description': 'Click Here','Url': 'siteUrl/sites/site1/Lists/Task/DispForm.aspx?ID=1'}
}
if your list name is "abc" then type value should be "SP.Data.abcListItem".
Field name should be Internal field name and not display name.
Body Text is as follow:-
{'__metadata': {'type':'SP.Data.TaskListItem'},
'InternalFieldName':{'Description': 'Click Here','Url': 'siteUrl/sites/site1/Lists/Task/DispForm.aspx?ID=1'}
}
if your list name is "abc" then type value should be "SP.Data.abcListItem".
Field name should be Internal field name and not display name.