Good Day Everyone,
I am trying to get this to work. I feel like I am close but may be over complicating this. What I have is a Room Reservation app. As shown here, I want users to select the equipment needed from the LeftGallery of checkboxes on the left and have the gallery on the RightGallery show only the RoomTypes that have the selected equipment in it . In this photo shown here the Items property of the RightGallery is Distinct(MTFConfRooms,RoomType.Value).Value . In the SharePoint list there are 30 rooms(records) that are all one of the 5 types. Each distinct RoomType has a the same type of equipment, i.e. (All Classrooms have a Flip Chart, Projector Screen, Phone/Jack, Instructor Laptop, and Whiteboard) and (All Breakout Rooms have a Flip Chart, Phone/Jack, and Whiteboard).
Again I would like the users to choose the equipment they need and have the RoomTypes gallery only show the room types that contain the combination of selected equipment. I have tried using Index using the formula below that I copied from @WarrenBelz . This formula doesn't throw any errors and I made some changes to it based on reading various articles, but it also does not show the room types that have the selected equipment. It doesn't return anything at all when I select the checkboxes. Note: the ComboBox at the bottom of my screen is cbEuipmentCheck_3 and it populates the name of the equipment as they are selected from the Equipment checkboxes. Can I get some help please?
Filter(
MTFConfRooms,
Index((
cbEuipmentCheck_3.SelectedItems.Value),
1
).Value in RoomEquipment Or IsBlank(Index((
cbEuipmentCheck_3.SelectedItems.Value),
1)),
Index((
cbEuipmentCheck_3.SelectedItems.Value),
2
).Value in RoomEquipment Or IsBlank(Index((
cbEuipmentCheck_3.SelectedItems.Value),
2)),
Index((
cbEuipmentCheck_3.SelectedItems.Value),
3
).Value in RoomEquipment Or IsBlank(Index((
cbEuipmentCheck_3.SelectedItems.Value),
3)),
Index((
cbEuipmentCheck_3.SelectedItems.Value),
4
).Value in RoomEquipment Or IsBlank(Index((
cbEuipmentCheck_3.SelectedItems.Value),
4)),
Index((
cbEuipmentCheck_3.SelectedItems.Value),
5
).Value in RoomEquipment Or IsBlank(Index((
cbEuipmentCheck_3.SelectedItems.Value),
5)),
Index((
cbEuipmentCheck_3.SelectedItems.Value),
6
).Value in RoomEquipment Or IsBlank(Index((
cbEuipmentCheck_3.SelectedItems.Value),
6)),
Index((
cbEuipmentCheck_3.SelectedItems.Value),
7
).Value in RoomEquipment Or IsBlank(Index((
cbEuipmentCheck_3.SelectedItems.Value),
7)),
Index((
cbEuipmentCheck_3.SelectedItems.Value),
8
).Value in RoomEquipment Or IsBlank(Index((
cbEuipmentCheck_3.SelectedItems.Value),
8))
).RoomType
