Hello all,
In short, I have a "Book A Room" app. I have a multitude of rooms that each contain their own unique attributes. For example: one room may contain a "Single Screen" and "Double Projector", while another room may only contain a "Single Projector".
I have an application that uses a choice column in SharePoint (that holds all possible attributes for a specific room) in the form of buttons (for each attribute). Here is a screenshot of the screen, "FilterScreen":
In the 'Save' button's OnSelect of the FilterScreen, there are 2 important collections being made: 'Info' and 'FilteredMatchRooms'. Here is the code for the OnSelect of the 'Save' button:
Collect(
Info,
Filter(
AddColumns(
colConferenceroom,
"AttributesNew",
Concat(
Attributes,
Value,
", "
)
),
Text(
First(
Split(
varSelectedAttributes.Value,
", "
)
).Result
) in AttributesNew Or Text(
Last(
FirstN(
Split(
varSelectedAttributes.Value,
", "
),
2
)
).Result
) in AttributesNew Or Text(
Last(
FirstN(
Split(
varSelectedAttributes.Value,
", "
),
3
)
).Result
) in AttributesNew Or Text(
Last(
FirstN(
Split(
varSelectedAttributes.Value,
", "
),
4
)
).Result
) in AttributesNew Or Text(
Last(
FirstN(
Split(
varSelectedAttributes.Value,
", "
),
5
)
).Result
) in AttributesNew Or Text(
Last(
FirstN(
Split(
varSelectedAttributes.Value,
", "
),
6
)
).Result
) in AttributesNew
)
);
ForAll(
AllRooms,
If(
!IsBlank(
LookUp(
Info,
Info[@Title] = AllRooms[@Address]
)
),
Collect(
FilteredMatchRooms,
{
Name: AllRooms[@Address],
DisplayName: LookUp(
Info,
Title = AllRooms[@Address]
).DisplayName,
AttributeNew: LookUp(
Info,
Title = AllRooms[@Address]
).AttributesNew
}
)
)
);
Navigate(
RoomSelectScreen,
ScreenTransition.Cover
)
* 'Info' = the collection that pulls up the attributes selected from the choice of buttons in the "Filter Screen" :
* 'FilteredMatchRooms' = Want this to pulls in all of the rooms have contain at least one of the attributes selected in the FilterScreen
^^ FilteredMatchRooms should be the collection set in the Items property of my Gallery (RoomsGallery_1) to show the filtered selection of rooms, but currently the Gallery is empty since it isn't properly pulling a room that has at least one of the attributes selected in the FilterScreen.
I suspect the error has to be somewhere in the 'Save' button's OnSelect of the FilterScreen. There are no errors with my code, but I think potentially organization of the code or something small. Would anybody be able to help advise?
Thank you so much! 🙂
