Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

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
Power Apps

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

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

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (28,200)