Answered

Filter on gallery from choices

(0) Share

Report

Posted on by BFS

Hello Guys

I'm new to power apps, I did already some different flows in Power Automate. I'm kinda thinking that these are very powerfull tools. Although it is a steep learning curve I noticed. It kinda reminds me of Flash when I was still in school.

So this is what I use as data source:

I have a sharepoint list with different columns. And a choice that needs to be added to the filter.

I created a canvast app and did some changes to it already, I added some dropdowns, datepicker, etc... I made some filters on the gallery.

The current code is as following:

Filter('Busritten Lijst'; Dag=DateSelector.SelectedDate && nr=RitSelector.Selected.Value)

// && Status.Value='Ok' ) Value in Filter('Busritten Lijst', Status = "Ok").Title

But the last filter condition that I want to add is that it needs to filter a Choice option. You can see what I already tried behind the comment tags. But whatever I try, it doesn't seem to be working.

Thank you for the help. If you have further questions/remarks don't hesitate to forward it.

Kind regards

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @BFS,

Do you want to filter records with OK of status?

To filter status of Ok in your list, you should write as below:

Filter('Busritten Lijst', Status.Value = "Ok")

Was this reply helpful? Yes No
BFS 14 on at

Like (0)

Report
Copy link

Link copied!

Hi Qi

This seems to be working. But what I actually would need is the ones without the Value = "Ok". I tried Value != 'Ok' but it doesn't seem to be working.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
HI @BFS,

To exclude OK from the status column and filter records based on it, please try as below:

Filter('Busritten Lijst', !(Status.Value = "Ok"))

Was this reply helpful? Yes No
BFS 14 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft

This seemed to have done the trick.
Thank you!

Was this reply helpful? Yes No