Introduction
In this article, I will show you how to update hyperlink fields with URL and description in Share Point using Microsoft Flow (Power Automate).
Sometimes we have the requirement to add a URL in the Share Point list column and we can’t directly update the URL with a description using the Update Item action in MS Flow. So in this article, I will show you how to Update the URL with a description of the Share Point List.
Share Point List
I have already created a list with two fields, Title (single line of text) and Address (Hyperlink).
Steps to create Flow
Step 1
Open Power Automate
Link.
Step 2
Select the “Create” option from the Left Navigation Panel and then select “Automated cloud flow”
Step 3
Once you select the above option a dialog box will open. Enter details and Click on the “Create” Button.
Flow Name - Enter the name of your flow
Choose your flow’s trigger based on your requirement. Choose trigger from the list.
Step 4
Once you click on create your flow page opens with your action.
Enter your Site Address and List Name
Step 5
Click on Add New Action and add “Send an HTTP request to SharePoint “
Step 6
Fill in all the data details
Site Address - your Site Address
Method - POST
Uri - _api/web/lists/GetByTitle(‘ListName’)/items([ID]). Update “ListName” to your list’s name.
Replace “[ID]” with the ID field from dynamic content.
Step 7
Click on “Text Mode” in send HTTP request action.
Step 8
Add the below code in the Header Text Box
- {
- "Content-Type": "application/json;odata=verbose",
- "X-HTTP-Method": "MERGE",
- "IF-MATCH": "*"
- }
Step 9
Add the below code in in the Body Text Box
- {'__metadata': {'type':'SP.Data.RecordsListItem'},
- 'Address':{'Description': 'Click Here','Url': 'http://www.msn.com'}
- }
Step 10
Replace 'SP.Data.RecordsListItem’ with your own list’s name.
For getting ListItemEntityTypeFullName for your list use the below rest API
“_api/web/lists/GetByTitle(‘<List name>’)?$select=ListItemEntityTypeFullName”.
Step 11
Replace 'Address' with the name of the hyperlink column’s name
Step 12
Replace Description text with the label/description/clickable text you want for the link
Step 13
Replace http://www.msn.com with the URL/address part of the hyperlink
Amy AldenPosted Aug 17, 2022, 2:52 PM
I am struggling with a similar action, my flow creates a new folder using a trigger of new list item created. So I am using the varfoldername in the send an http request to have the folder path link write back to the field in the list for that same new item. The folder creates without issue but the flow fails at the final http step with Error details: The expression "web/lists/GetByTitle(‘Change Request Log‘)/items(35)" is not valid. the Uri reads: _api/web/lists/GetByTitle(‘Change Request Log‘)/items(@{outputs('Create_new_folder')?['body/ID']}) where "@{outputs('Create_new_folder')?['body/ID']}" is simply the dynamic content for the new item ID. I can't pinpoint the issue.
smaran manjulaPosted Jul 5, 2022, 5:26 PM
The expression "web/lists/GetByTitle(‘testDest’)/items(6)" is not valid. please help to resolve
smaran manjulaPosted Jul 5, 2022, 5:25 PM
It throws error as below destimage "message": "The expression \"web/lists/GetByTitle(‘testDest’)/items(6)\" is not valid.\r\nclientRequestId: e3f2a989-af1d-48f1-bb0f-ce86b688d2bd\r\nserviceRequestId: f5184ea0-2018-d000-1bd9-d77acdf57957",
smaran manjulaPosted Jul 5, 2022, 5:25 PM
The expression "web/lists/GetByTitle(‘testDest’)/items(1)" is not valid
SebbyPosted Feb 22, 2022, 10:12 AM
Where do I insert “_api/web/lists/GetByTitle(‘<List name>’)?$select=ListItemEntityTypeFullName”. ?
Mea KidPosted Nov 19, 2021, 12:06 AM
A great tip, Thank you. I followed every step to test and it worked great but it loops continuously. How do you manage that?
Tomas AndrewsPosted Aug 27, 2021, 1:14 PM
This is perfect, i couldn't find anything on how to update an existing item. very clear and concise - thanks!
Vijay MPosted May 10, 2021, 7:38 AM
Hi Harshad nice article....how to do the same as above in a Document library...pls let me know