Answered

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:

General Questions

All responses (4)

Answers (1)

Masakichi123 58 on at

Like (0)

Report

Re: Filter problems

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
Verified answer

AndrewR1 1,572 Super User 2025 Season 1 on at

Like (0)

Report
Re: Filter problems

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
Masakichi123 58 on at

Like (0)

Report

Re: Filter problems

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
AndrewR1 1,572 Super User 2025 Season 1 on at

Like (0)

Report
Re: Filter problems

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