Share
ReportGood tuesday,
I am currently struggling with filtering the avaliable roomnames in my roomsgallery to only display rooms that have the name "RS_KS4950"
You’re offline. This is a read only version of the page.
Good tuesday,
I am currently struggling with filtering the avaliable roomnames in my roomsgallery to only display rooms that have the name "RS_KS4950"
@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!
RoomName seems to be a control, try replacing it with Name
try this instead:
All responses (
Answers (
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
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!
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
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
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! 🙂
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
