Forum Discussion
Powerapps filter Gallery
Hi,
I am creating a power app to view and make entries in a sharepoint list.
Now I created a new Screen with a gallery and the source is my sharepoint list. In the list, there is a field that is called "closed" and it has a drop down menu with yes/no. Now I want this particular gallery to only show the lines of the sharepoint list were the field "closed" is set to 'No'.
Is there any way to do that?
I experimented a bit by changing the following line, but nothing seems to work.
For any help I would be greatful!
Thanks
Christina
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.
You can use the "Filter" command in the "Items" property to filter the list.
Here is my unfiltered app:
Here is my filtered app and code:
SortByColumns(Filter([@PowerAppsDemo], Closed = false), "Title", If(SortDescending1, Descending, Ascending))
Unfortunately, using "true" does not work as expected. Here is a version of the code for "true" but be warned you will get "Delegation" warnings.
SortByColumns(Filter([@PowerAppsDemo], Closed <> false), "Title", If(SortDescending1, Descending, Ascending))
I hope this helps.
Norm
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.
ChrisWebbTech thanks for pointing that out. I missed it in the original post.
christina_hoeglinger, Chris' code example should give you what you need.
Norm
