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?
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!
User | Count |
---|---|
185 | |
123 | |
91 | |
47 | |
42 |
User | Count |
---|---|
271 | |
159 | |
132 | |
85 | |
78 |