Forum Discussion
Powerapps filter Gallery
It’s a drop down aka choice column with those values and so it’s a delegated query now so if you use filter(data source,closed.value = “no”) in items you will get the result you need.
It’s a drop down aka choice column with those values and so it’s a delegated query now so if you use filter(data source,closed.value = “no”) in items you will get the result you need.
Thank you so much! I actually was pretty close to this solution, i just forgot the .Value after Closed ChrisWebbTech
I have follow-up question regarding your post: when you say delegated query, do you mean that the job gets passed on to sharepoint? I think I read about this, but I am not sure if this is what you mean here?
It has something to do with powerapps being only able to use a limited number of rows? 500 I think?
Thanks again for your help!
Christina
- Yes, in the past, if you filtered on a choice column it was not delegated which means you could only filter on the first 500 rows of the datasource. Now it's a delegable data type so you can filter on the entire record set (returning up to 500, or 2000 if configured of that filter).
