Efficient Data Queries & Pagination for SharePoint & Dataverse with Power Automate
1.8 هزار بار بازدید -
7 ماه پیش
-
In this video, I look
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
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
7 ماه پیش
در تاریخ 1402/11/24 منتشر شده
است.
1,874
بـار بازدید شده