Unanswered

How to filter building names using a toggle

(1) Share

Report

Posted on by hotdogman

Hello,

I'm fairly new to powerapps and I'm struggling on how to filter the room names to only display certain rooms in a building (RS_KS11100) using a toggle value.

Please help!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @hotdogman,

In case you want to filter your datasource (e.g. within a gallery) to only include certain rooms based on the room name, you could use the structure below. The code below expects a text column storing the room name:

Filter( //Adjust with your datasource name Datasource, //Only display rooms with name RS... if the toggle is enabled //Replace .Value with .Checked should you use the modern toggle control !Toggle.Value || 'Room Name' = "RS_KS11100" )

In case the column is not of type text, would it be possible to provide additional information on your datasource & column type?

If this solves your question, would you be so kind as to accept it as a solution. ✔️

If you liked my solution, please give it a thumbs up. 👍

Connect with me: LinkedIn | Blog

Was this reply helpful? Yes No
hotdogman on at

Like (1)

Report
Copy link

Link copied!

The datasource is coming from avaliableroomnames but I'm not sure about the column. I'll attach a couple of screenshots to see if it'll help out?

Please let me know if you need more information! I'm really new to this so I'm completely lost lol

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
@hotdogman,

Thank you for the screenshots! 😊

I took a quick look at the room booking template. The name will be stored in the 'Name' column. Would it be possible to use the following code:

Filter( //Adjust with your datasource name AvailableRoomEmailName, //Only display rooms starting with RS_KS11100 if the toggle is disabled Toggle1.Value || "RS_KS11100" in Name )

I also adjusted the logic to only display rooms starting with the respective value when the toggle is turned off.

If this solves your question, would you be so kind as to accept it as a solution. ✔️

If you liked my solution, please give it a thumbs up. 👍

Connect with me: LinkedIn | Blog

Was this reply helpful? Yes No
hotdogman on at

Like (1)

Report
Copy link

Link copied!

Hello. First I want to apologize for the late response but I'm still struggling with getting my gallery filtered

Was this reply helpful? Yes No