Maximize SharePoint List Power App with Unlimited Delegation
SharePoint Online
Sep 23, 2023 7:00 PM

Maximize SharePoint List Power App with Unlimited Delegation

by HubSite 365 about Tyler Kolota

Software Development & Process Improvement

Pro UserSharePoint OnlinePower AppsLearning Selection

Overcome SharePoint list delegation limits with our Power App template, enabling efficient data loading up to 100MB without premium connectors.

The author, Tyler Kolota, discusses a novel approach for dealing with large SharePoint list data. He highlights a template app and flow setup which enables filtering, searching, sorting and loading of SharePoint list data without falling prey to delegation limitations.

  • Usually, it is challenging to make a Power App retrieve more than 2000 items from a large SharePoint list, especially when using more refined filters and searches on non-standard fields like Created By column, multiline text column or several columns simultaneously.
  • This new template addresses that issue and does more. It uses a Power Automate flow and the ParseJSON() expression in Power Apps, thus eliminating SharePoint list delegation limitations and associated problems.
  • It allows loading a significantly larger number of SharePoint records into a Power App, up to 100MB worth.
  • A highlight of the app is its capability to bypass the SharePoint interface 5000 list view threshold. It displays many more than 5000 records on a screen without the need for premium connectors.

Understanding SharePoint and Power App Integration

Tyler Kolota's approach to dealing with SharePoint list data brings a paradigm shift to the traditional limitations experienced. This current set-up circumvents the usual restraint of getting a maximum of 2000 items from a SharePoint list by using a Power Automate flow and parsing JSON expression in Power Apps. The innovation allows users to load a larger number of SharePoint records into a Power App, which can span up to 100MB worth. It significantly mitigates the SharePoint interface 5000 list view threshold, presenting an app interface capable of displaying more than 5000 records on one screen, sans premium connectors. This development is a noteworthy improvement in the seamless integration of SharePoint and Power Apps.

Learn about No Delegation Limit - SharePoint List Power App

In this video, techniques are shared on how to handle large SharePoint list data without delegation limitations in Power Apps. This is accomplished with the use of a template app & Power Automate flow set-up, which allows more advanced filtering, searching, and loading of data, even on non-standard fields. The approach used in the video challenges the usual 2000 items limit in Power Apps, enabling the loading of significantly larger volumes of SharePoint records, up to 100MB worth.
Furthermore, the video introduces an efficient workaround to overcome SharePoint's 5000 list view threshold, avoiding the usage of premium connectors. This means that one can easily view more than 5000 records on a screen.

  • Learning Point: The video is a great resource to learn about handling large SharePoint data without delegation limits in Power Apps. It presents advanced filtering, searching, and sorting techniques, along with efficient ways to overcome SharePoint's 5000 list view threshold and loading larger volumes of SharePoint records.
  • How to learn more about this topic: To learn more about this topic, viewers can experiment with the techniques shared in the video or reach out to the SharePoint List Power App Community for further insights.
  • Recommended Training Courses: For those looking to get in-depth experience and expertise, Microsoft's Power Apps and Power Automate training courses would be interesting. These courses will likely provide additional techniques, methodologies, and best practices in handling large SharePoint list data.


More links on about No Delegation Limit - SharePoint List Power App

SharePoint Delegation Cheat Sheet For Power Apps
Feb 5, 2023 — This SharePoint delegation cheat sheet is the quickest way to check which Power Apps functions support delegation.
Understand delegation in a canvas app - Power Apps
Feb 6, 2023 — To avoid this, Power Apps imposes a limit on the amount of data that can be processed locally: 500 records by default. We chose this number so ...
How to overcome PowerApps Delegation limit?
May 5, 2021 — The default delegation limit in PowerApps is 500 records. Delegation does not apply to data sets with less than 500 records, they will work ...
Power Apps: Search A SharePoint List (No Delegation ...
Jan 29, 2023 — I have found a way to search a SharePoint list in Power Apps and return any records with a matching substring (no delegation warning).
Power Apps Delegation – SharePoint
Jan 16, 2021 — Delegation can be summarised as “who does what work” when data is requested by Power Apps from SharePoint. Because SharePoint is a “shared” ...
SharePoint list delegation : r/PowerApps
May 23, 2021 — Delegation warnings mean the Power App will load 500 rows of data and then perform the function. The warning is there to tell you, the function ...
How to overcome 500 items limit in PowerApps - CEO-Refleksje
In PowerApps every data source (SharePoint, Dataverse, OneDrive) is under limitation of 500 items. It means you cannot get more that 500 items from a data ...
Delegation and data row limits: Please let us turn off or ...
Here's my solution which occurs on committing a row with the app, and it should work for you in CDS as well. (Calculated columns in CDS are not delegable just ...
Mastering Delegation in Power Apps: A Comprehensive ...
Aug 2, 2023 — Delegation in Power Apps is the process of retrieving data from a data source on an as-needed basis. Instead of pulling in all records at once, ...


Microsoft specialist, Microsoft professional, Microsoft certified expert, Microsoft solution expert, Microsoft certified professional