Update Hyperlink fields with URL and Description using Microsoft Flow (Power Automate)

This post was most recently updated on October 26th, 2020

1. Add the Send an HTTP request to SharePoint action
2. Add your site for Site Address
3. Set Method to POST
4. Set the Uri to _api/web/lists/GetByTitle(‘ListName’)/items([ID]). Update “ListName” to your list’s name. Replace “[ID]” with the ID field from dynamic content
5. Click on “Text Mode” and Add below code to Header
   
   { "Content-Type": "application/json;odata=verbose", "X-HTTP-Method": "MERGE", "IF-MATCH": "*" }

   1 2 3 4 5

   { "Content-Type": "application/json;odata=verbose", "X-HTTP-Method": "MERGE", "IF-MATCH": "*" }

6. Add below code in Body
   
   {'__metadata': {'type':'SP.Data.List_x0020_NameListItem'},'YourColumnName': {'Description': 'Description Text', 'Url': 'http://www.msn.com'} }

   1 2 3 4

   {'__metadata': {'type':'SP.Data.List_x0020_NameListItem'},'YourColumnName': {'Description': 'Description Text', 'Url': 'http://www.msn.com'} }

7. Replace List_x0020_Name with your own list’s name.
   Note: ‘_x0020_’should replace any spaces in your list name.
8. Replace “YourColumnName” with the name of the hyperlink column’s name
9. Replace Description text with the label/description/clickable text you want for the link
10. Replace http://www.msn.com with the URL/address part of the hyperlink

Happy Coding!