Efficient Data Queries & Pagination for SharePoint & Dataverse with Power Automate
In this video, I look at why the default "Get Items" action for SharePoint and "List Rows" action for Dataverse might not be the most efficient choice due to the excessive metadata they return. Learn through how to bypass this by directly querying these data sources using HTTP requests, significantly improving performance by reducing unnecessary data overhead.
00:00 Introduction: Why you shouldn't use the Get Items or List Rows action.
01:16 Comparing Performance of Get Items action for SharePoint to a HTTP Request.
05:55 Comparing Performance of List Rows action for Dataverse with HTTP.
08:26 Using pagination with the HTTP Method.
11:33 Comparison of Performance when using pagination.
Working with lists and list items:
https://learn.microsoft.com/en-us/sha...
Working with Parse JSON:
• Unlock the Full Potential of Parse JS...
Further reading JSON Light Support in SharePoint REST API
https://www.microsoft.com/en-us/micro...
If you found this video useful, please consider making a donation to the channel:
https://www.buymeacoffee.com/paulie
Watch video Efficient Data Queries & Pagination for SharePoint & Dataverse with Power Automate online without registration, duration hours minute second in high quality. This video was added by user Paul Murana 13 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,723 once and liked it 115 people.