Hello everyone,
I have a filtering problem, I have three lists "Controls" "Users" and "Cities" within "User" there is a LookUp to "Cities", the list of "Controls" has a LookUp to Users, this list (Controls) has about 2700 records and I need to filter them by City User, but the City is within Users. Any suggestion?
OnStart:
Set(varUserZona; LookUp(Users; Title= varUser.FullName).Citie.Value)
I use the following function:
Gallery.Items:
Filter (AddColumns (
'Controls';
"Cities"; LookUp (Users; Title = User.Value; Citie.Value));
Cities = varUserZona (Variable global, that i obtain on StartUp)
)
But I have not managed to get all the values, only 500, since AddColumns is not delegable
From now, thank you for you help
Hi @jcutrin ,
Remember in PowerApps we can get only a max of 2000 records and I see you are getting only 500 means your app has the default item limit. Change that to 2000 (max item limit by following the below steps).
File -> Setting -> Advanced setting -> change the limit and then click save.
Proud to be a Super User!
Regards,Hello KrishnaV,
Thanks for your Reply, but this would not limit me to only 2000, what would happen to the remaining 700? On the other hand, I previously increased this capacity, but the gallery took a long time to load, which led to complaints from the Users, I am looking for a delegable way to carry out the commented search.
I just added another gallery with which I add the users that have the City that I require and filter my list of controls in this way:
Gallery2.Items: Filter (User; Locacion.Value = varUserZona)
Gallery1.Items:
Filter ('Controls; Users.Id in Gallery2.AllItems.ID)
This works fine but is not delegable.
Thx!
Hi @jcutrin ,
I have done a blog on Delegation that has some options that may assist you.
User | Count |
---|---|
204 | |
93 | |
84 | |
47 | |
42 |
User | Count |
---|---|
251 | |
104 | |
104 | |
62 | |
57 |