Unanswered

Filter problems

(0) Share

Report

Posted on by Masakichi123

Hello everyone,

I have a listbox in which I only want to display the email addresses of people who have also booked a specific room. The formula I use for this is:

Filter(Reservierungen;Reservierung=DataCardValue3.SelectedDate;Raum=DataCardValue4.Text)

That works too; However, there are values with "No room selected". In this case, no value should be displayed in the list box. I can't manage to change the filter so that it only shows values when a room is selected and nothing when "No room is selected". How do I get that???

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

AndrewR1 1,572 Moderator on at

Like (0)

Report
Hi @Masakichi123 which data card is the room selection?
The code would look something like this for the items property:(replace RoomSelected.Value with your data card)

If(!IsBlank(RoomSelected.Value),Filter(Reservierungen;Reservierung=DataCardValue3.SelectedDate;Raum=DataCardValue4.Text))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report

Hi @AndrewR1

thanks for your message.
The problem is that the "empty" values have the value "No room selected" because it is displayed in a different place.

Greetings,
Masakichi

Was this reply helpful? Yes No
Verified answer

AndrewR1 1,572 Moderator on at

Like (0)

Report
Hi @Masakichi123 ok it would be something like this:
If(RoomSelected.Value <>"No room selected",Filter(Reservierungen;Reservierung=DataCardValue3.SelectedDate;Raum=DataCardValue4.Text))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report

Hi @AndrewR1 ,

I've adjusted the formula:

If(Gallery1.Selected.Raum <> "Kein Raum ausgewählt";Filter(Reservierungen;Reservierung=DataCardValue3.SelectedDate;Raum=DataCardValue4.Text))

It worked!

Thanks a lot for your help! 🙂

Greetings Masakichi

Was this reply helpful? Yes No