Post
Ask Question

Update List Item In SharePoint Using Power Automate

Introduction

In this blog, we will learn about how to update SharePoint list items using power automate.

Step 1

Update List Item In SharePoint Using Power Automate

Step 2

Expand the "Send an HTTP request to Sharepoint" connector box and provide:

  1. Site Address
  2. The method as "Post"
  3. in Uri column fill as /_api/web/lists/getbytitle('MYTEST')/items(1)

In Headers,

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

In body Specify,

 {'__metadata': { 'type': 'SP.Data.MYTESTListItem' },'Title':'Madhan',
'MyImage1': {'Url': 'https://5.imimg.com/data5/AA/KK/MY-6677193/red-rose-500x500.jpg', 'Description': 'This is the description'},
'Link': 
                {
                    '__metadata': { 'type': 'SP.FieldUrlValue' },
                    'Description': 'Google',
                    'Url': 'http://google.com'
                }

}

metadata type --> metadata type can extracted by,

/_api/web/lists/GetByTitle('MYTEST')?$select=ListItemEntityTypeFullName

here,

  • The title is a single line of text
  • MYImage1 is the Image field
  • Link is a link field
  • MYTEST is a list name
  • 1 is an ID of the item

Update List Item In SharePoint Using Power Automate

Conclusion

In this article, we learned how to update SharePoint list items using power automate. I hope this helps someone and happy coding:)