Unanswered

Filtering AvaliableRoomNameEmails in Book A Room Template using a Toggle

(1) Share

Report

Posted on by hotdogman

Good tuesday,

I am currently struggling with filtering the avaliable roomnames in my roomsgallery to only display rooms that have the name "RS_KS4950"

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

madlad 2,637 Moderator on at

Like (1)

Report
Hi!

I hope I understand correctly, you only want to use this filter when the toggle is selected? If so, try something like:

Filter( AvailableRoomEmailName, If( Toggle1.Value, "RS_KS4950" in Name, True ) )

"If(Toggle1.Value, "RS_KS4950" in Name,True)" Is used here, so that If Toggle1 is checked, it will filter as you've specified. Otherwise it will return all results.

Please note you may have a delegation issue here, which could become a problem if more than 2000 records will be in play.

Hope this helps! 🙂

Was this reply helpful? Yes No
hotdogman on at

Like (1)

Report

I think one thing I'm overlooking right now is that "RS_KS4950" is the building name, "RS_KS4950_1" the "1" represents the floor level, and "RS_KS4950_1_HotDagMan" represents the the room name.

I want to display all those avaliable room names that have the "RS_KS4950" when I turn on the toggle

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
hey @hotdogman

can u try this:

Filter(AvailableRoomEmailName, RoomName = "RS_KS4950")

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (1)

Report

@hotdogman

The code I provided should accomplish this- However, If you have an alternate filter condition to use when the filter is untoggled, you can replace the 'true' in my original code with this. If you want to filter using "RS_KS4950_1" instead, you can just replace the string in my original code with that.

Hope this helps!

Was this reply helpful? Yes No
hotdogman on at

Like (1)

Report

I get this error message when I try to type it in

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
try this instead:

Filter(AvailableRoomEmailName, Text(RoomName) = "RS_KS4950")

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (1)

Report

@hotdogman

RoomName seems to be a control, try replacing it with Name

Was this reply helpful? Yes No
hotdogman on at

Like (1)

Report

The code doesn't show any errors but it's not filtering the gallery

Sad days : , (

Was this reply helpful? Yes No
hotdogman on at

Like (1)

Report

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (1)

Report

@hotdogman Where is the code you've shown here? It looks like you have the toggle selected?

It needs to be in the galleries Items property.

You can also see more on the filter function here

Let me know!

Was this reply helpful? Yes No