Update List Item In SharePoint Using Power Automate

In this blog we will learn about how to 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

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

Conclusion

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