I am making an app using PowerApps to reserved a seat, it is linked to a SharePoint List called "Reservation" which has 2 columns, "Seats" and "Status"
I'd like to be able to update the "Status" of multiple "Seats". In my App I have a ComboBox which items are the "Seats" and a Dropdown Box with the items "Free", "Occupied" and "Reserved"
the Columns "Seats" has a value of A1 to A10. I am getting an error when I use the Patch to update the "Status" column of the selected items in the ComboBox.
Here's my code for the Submit Button
I'd like to be able to update the "Status" of multiple "Seats". In my App I have a ComboBox which items are the "Seats" and a Dropdown Box with the items "Free", "Occupied" and "Reserved"
the Columns "Seats" has a value of A1 to A10. I am getting an error when I use the Patch to update the "Status" column of the selected items in the ComboBox.
Here's my code for the Submit Button
ForAll(
ComboBox2.SelectedItems,
Patch(
'Reservation',
LookUp('Reservation', Seats = ThisRecord.Seats),
{Status:Dropdown4.Selected.Value}
)
);
Notify("Seats updated successfully!", NotificationType.Success)
I also tried the following code, no error however only the last item is being updated
I also tried the following code, no error however only the last item is being updated
ForAll(
ComboBox2.SelectedItems,
Patch(
'Reservation',
LookUp('Reservation', Title = ComboBox2.Selected.Value),
{Status:Dropdown4.Selected.Value}
)
);
Notify("Seats updated successfully!", NotificationType.Success)
427
