Hello all!
I have a form that has 2 buttons at the bottom of the screen. The red one is called "button11". The blue one is called "saveButton":
^^ (I have both of these buttons for testing purposes, but will eventually build both of their functionalities into one button)
When "Button11" is clicked, I put the following code in the OnSelect property to create a collection called 'Info' that is populated with the following code:
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
)
)
^^ There are no errors and the 'Info' collection seems to be populated perfectly.
So once "button11" is clicked, the 'Info' collection is populated. However, after "button11" has been clicked, I'd like to click the "saveButton" because it pulls elements from the 'Info' collection to create a new collection called 'AvailableRoomEmailName2' ... but 'AvailableRoomEmailName2' seems to be empty after I click "saveButton" (even though there are no errors in my code). Here's the code from my OnSelect property of "saveButton":
ClearCollect(
AvailableRoomEmailName2,
Select(Button11),
AddColumns(
RenameColumns(
AvailableRoomEmails,
"Result",
"Email"
),
"Name",
LookUp(
AllRooms,
Email = Address
).Name
)
);
Navigate(
RoomSelectScreen,
ScreenTransition.Cover
)
Would anybody know why 'AvailableRoomEmailName2' isn't being populated when my "saveButton" is clicked after "button11" is clicked?
Thank you!
