New to PowerApps, struggling with my understanding of how delegation should work with SharePoint lists. For test purposes, I set my delegation limit to 1 to quickly see when delegation was not working. I am populating dropdown lists from very limited SharePoint lists (4 values in one, and about 25 values in the other). For the first dropdown, I simply want to pull all values from the SP list by providing the data source name for that list. For the second dropdown, I filter the results based on the selection in the first one. Both of these queries are abiding by the non-delegable data row limit, which is not what I expect from the documentation I've read.
Additional info: for the first dropdown, even if I filter the list using criteria that should include all values, I only retrieve up to the non-delegable limit. The second dropdown is filtered based on the ID value of the selection in the first dropdown, and I understand that when filtering on an ID field, only the = predicate may be used to allow the query to be delegable. However, as noted, this query is also abiding by the non-delegable limit. More confusingly, I get no warnings or highlight markings to indicate that PowerApps is unable to delegate. Can anyone provide clarification on the behavior I'm seeing vs. what I thought should happen from reading PowerApps documentation? Thanks.
Solved! Go to Solution.
Binding to a dropdown is by definition non-delegable, no matter what function you use. If you want to test then then bind the dropdown to a collection and use the formula to populate the collection. You should get better testing results that way.
Binding to a dropdown is by definition non-delegable, no matter what function you use. If you want to test then then bind the dropdown to a collection and use the formula to populate the collection. You should get better testing results that way.
@Pstork1 wrote:Binding to a dropdown is by definition non-delegable, no matter what function you use. If you want to test then then bind the dropdown to a collection and use the formula to populate the collection. You should get better testing results that way.
Pstork1, thank you for that clarification. I had not understood that binding to dropdowns makes a query non-delegable. That is very helpful to know, and I will investigate binding to collections instead.
User | Count |
---|---|
132 | |
127 | |
74 | |
72 | |
70 |
User | Count |
---|---|
206 | |
201 | |
64 | |
63 | |
52 |