I have a LARGE entity, 25,000 records, which means I easily hit the delegation limit in formulas. I am attempting to filter the entity not only by the field "name" but also by its lookup field "state." Being a lookup field, I get the two blue lines (delegation warning) if I try to use it in a filter.
Soooo, I have created a collection using the OnVisible property:
This almost works. The problem is that it fails to collect data from columns that contain lookup values... (this seems to be a broken function in PowerApps).
Is there a way either:
1) to create a collection from my 25,000 records (which contains text in the lookup columns) from the CDS entity it is created from (i.e. that I can then reference in a filter formula)? or,
2) to filter a 25,000 record long entity by a) it's (text) name, as well as b) a lookup field?
Solved! Go to Solution.
Thanks so much for your reply. Sadly AddColumns and DropColumns are both subject to the non-delegation limit.
I am hoping to collect all 25,000 records (if possible)... or find some other workaround, but the goal is filtering all 25,000 records both by the name field (text) as well as the state field (lookup column).
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!