Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Delegation Improvements for SharePoint

Hi everyone

I have a query about delegable queries in SharePoint.  I've been reading this recent article saying that SharePoint delegation has been improved in PA so queries against complex objects can now be delegated.  It also states the following:

The SharePoint ID field for a table is a number field in PowerApps.  However, SharePoint only supports the equal ('=') operation for delegation on an ID field.

My app is connected to two SharePoint lists - Clients and Meetings.  There is a lookup field in the meetings list so multiple meetings can be linked to a client.  In the app I have a main form which shows a client details and then a data table that displays all meetings related to that client.  The formula for the Items setting in the data table is Filter(Meetings,Client.Id=ThisItem.ID) but this is displaying the delegation warning.  I don't understand why this is happening as the article clearly states that using = on an ID field should be delegated?

Power Apps Staff CarlosFigueira
Power Apps Staff

Re: Delegation Improvements for SharePoint

The improvements in the delegation for SharePoint were for columns of type Choice and Person; filtering on LookUp columns still cannot be delegated at this time.

Hope this helps

Level: Powered On

Re: Delegation Improvements for SharePoint

Ouch! So that's the reason I can't get out of delegation warning while filtering by a Lookup column! Is that still on the roadmap after this release though, @CarlosFigueira? I expected it would happen simultaneously, per SPC 19 slide:




Really waiting for this so I can achieve filtering parity with what the OOB SharePoint list web view offers!

Helpful resources


New Badges

Check it out!


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,731)