Hello everyone,
in my flow I update a sharepoint (hyperlink type) column with an url via link to item function.
This works, but displays of course the full url in the column
How can update the column with an url, but let the link display name say some other custom text, e. g. Link ?
Thank you!
Thanks @creativeopinion : unfortunately the Json file link was not available on youtube anymore, so I typed everything off 😉 But your solution worked like a charm, many thanks.
@ManishSolanki : also thank you for posting your suggestion - I tried this one first, unfortunately I was getting a getbytitle metadata error here, I guess this additional part which @creativeopinion does, is required.
Hi @Nuriel
You could achieve this by using "Send an http request to SharePoint" action. Pls refer the sample flow mentioned below.
In this example, I have used a SharePoint list 'Action Tracker' with 'hyperlinkCol' as a hyperlink column type.
Site Address: <<SharePoint site collection URL>>
Method: POST
Uri: _api/web/lists/getbytitle('<list display name>')/items(<item id>)
Headers:
Body:
{
"__metadata": {
"type": "SP.Data.Action_x0020_TrackerListItem"
},
"hyperlinkCol": {
"Description": "Link",
"Url": "https://www.microsoft.com"
}
}
In the above JSON code, 'Action_x0020_Tracker' is the display name of the list. The white space between name is represented by '_x0020_', if there is no space then it is not needed. In description, pass the link title and Url contains the actual link.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
@Nuriel You need to use the Send HTTP Request to SharePoint action. Please refer to this section of one of my YT Tutorials.
Hope this helps!
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,081
Most Valuable Professional