Skip to content

GET – Send An HTTP Request to SharePoint using Power Automate to get single item or all items

This post is about creating a manual flow to get a single item or all items from SharePoint using GET method of HTTP request.

You will need the uri.

If your list has no space enter this in uri

_api/web/lists/getbytitle(‘ListName’)

If your list has space in it enter this in uri

_api/web/lists/getbytitle(‘List%20Name’)

To get single record enter below in the uri

uri = _api/web/lists/getbytitle(‘List%20Name’)/items(3)

Where items(3) is the item whose ID = 3

To get all records enter below in the uri

uri = _api/web/lists/getbytitle(‘List%20Name’)/items

content-type = application/json;odata=verbose

Please refer to image below to get single item

Please refer to image below to get all items

If you liked the post, please share it with others 🙂

Published inPower Automate