Skip to main content

PowerApps Delegation Warning

Update Aug 15 2019 - Microsoft has updated PowerApps to allow for some complex SharePoint data delegation, this will hopefully resolve most issues you were seeing when working with SharePoint data: https://powerapps.microsoft.com/en-us/blog/sharepoint-delegation-improvements/

If you've tried to use the Filter, LookUp or Search actions in PowerApps you have seen the yellow warning error that shows a 'delegation warning' and you might have even ignored it because your PowerApp was working fine in testing. However once you get into larger data sets your PowerApp will have some issues so in this blog I will attempt to explain what the delegation warning is and how you can fix your PowerApp.

Delegation

So what even is Delegation in PowerApps? When doing any sort of data manipulation for an app, PowerApps will try to push the processing of that data to the source system instead of doing all of the manipulation in the app. This is done to increase the efficiency of your app and reduce the number of records that need to be retrieved. It is much quicker for a PowerApp to load only the 20 items where the criteria is met instead of loading as many as items the request returns and then filtering them down. PowerApps can use delegation for tabular data sources only such as the CDS, SharePoint, and SQL Sever.

For more information on Delegation you can reference the Microsoft documentation here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

Request Limitations

When not utilizing delegation your PowerApp is, by default, limited to 500 items returned so if you get this error and you're working with large data sets items 1-500 will be returned and anything else will not appear in your app which likely means you're not displaying all of the intended data. Take a look at the example below, the 'ID Text Column' gallery is utilizing delegation to pull in data, while the 'Lookup ID ' gallery is not, so anything past the first 500 results will not return, in this case item 1280 QA Documentation. 

Note: Item IDs in the data set utilized above starts at ID 600
You can always change the limit for returned results in your PowerApp in App settings but you will likely experience some performance issues in returning data as more items will need to be fetched so the best solution will be to fix your data if possible.

Fixing your data

At this point you may be thinking, 'Ok I am using a delegable source so why I am still seeing this error!' and it's likely because you're attempting to filter on data/a column that that is created/manipulated using a non-delegable function. To solve for this you may have to attempt to use other functions or see if you can have this data manipulation done in the source data. If neither of these are possible your only option may be to increase the data limits. While most functions don't support delegation but Microsoft calls out the following notable functions in their documentation: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#non-delegable-functions
  • Table shaping
  • Fist, FirstN, Last, LastN
  • Choices
  • Concat
  • Collect, ClearCollect
  • CountIf, RemoveIf, UpdateIf
  • GroupBy, Ungroup

Unsupported SharePoint Columns

There are also a fair amount of  SharePoint columns that are not supported; so if you are filtering on one of the following column types you will get delegation warning.
  • Choice
  • Lookup
  • Dates
  • Person our Group
  • Managed Metadata
The easiest fix for this is to create a new text or number column and use Flow to sync the values between the fields, then use the new column in your filter criteria to ensure all the results are being returned. 

For a complete list of delegable functions for SharePoint data check out the Microsoft documentation here: https://docs.microsoft.com/en-us/connectors/sharepointonline/#powerapps-delegable-functions-and-operations-for-sharepoint

Hope this helps you understand the delegation warning and gives you the knowledge to help resolve any issues you may have. If you have any questions feel free to reach out on twitter: @mslavieri

Comments

  1. Get real time project based and job oriented Salesforce training India course materials for Salesforce Certification with securing a practice org, database terminology, admin and user interface navigation and custom fields creation, reports & analytics, security, customization, automation and web to lead forms.  

    ReplyDelete

Post a Comment

Popular posts from this blog

Getting started with Self Service Support in O365 with Learning Pathways

One thing that comes up in every O365 rollout is the need for employees to have some sort of self-service support in O365. In the past this would mean the learning and development teams would have to create artifact on artifact of material to help employees find the answers they are looking for. Now in Office 365 Microsoft has created a custom learning module to address this need. The learning pathways solution can be customized to the app mix that is used by your organization and brings in the relevant Microsoft resources into an app in your tenant. Provisioning Learning Pathways The learning pathways solution will provision a SharePoint application and will require a SharePoint App Catalog. If you do not have an App Catalog in O365 and one will need to be created. You can install the learning pathways solution in one of two ways, the first is to use the pnp provisioning service (recommended), which will automatically create and set-up the site collection. The second option is to ma…

O365 Weekly Digest - 01/28/2019

Every week I'll be posting a quick summary of O365 updates included in the admin weekly digest email that you can sign up for via the admin Message Center: https://admin.microsoft.com/AdminPortal/Home#/MessageCenter -these emails include items posted to the message center over the last week and come out every Monday.
Lots of updates and reminders to some already talked about features this week. The one I am most excited about is the new site branding and mega menu navigation (Roadmap IDs 33131, 33132, 33138, 43781). The rollout for this feature was pushed back a bit but is now rolling out. There has also been a delay in the rollout for SharePoint reminders based on date fields (Roadmap ID 34267), and the new icons for the waffle which are rolling out soon as well (Roadmap ID 45441).

The updates this week also sent reminders for the Planner Notifications in a Teams activity feed that was covered last week (Roadmap ID 45878), as well as the opt-in toggle for try the early version of…