Hi @Jojo17,
Imagine seats as Rooms.
SharePoint list 1: Rooms is a master list which contains all the rooms.
SharePoint list 2: My Room Reservations, a transaction list which contains fields like [Person, Rooms (lookup field from Rooms list), Date (today)].
Business Scenario:
Every day users will reserve a room for the current day. If a room is reserved for a user for the current day, that room should not be available in the Rooms dropdown (should not be available for other users for booking on that particular day). This scenario repeats every day.
If you are expecting a solution for this problem, then please use the below procedure, else let me know more details with your SharePoint lists schema and some sample data.
| Booked Rooms for today | Available Rooms for today |
 |  |
Use the below code in the Screen (Page) - OnVisible property.
//Collect all available rooms
ClearCollect(collAllReservations, Choices(MyRoomReservations.Rooms));
//Clear the reserved rooms
Clear(collAvailableRooms);
//Loop through the datasource(collection) named 'collAllReservations',
//name each row as 'Room' and check if that room is reserved for today
ForAll(
collAllReservations As Room,
If(IsEmpty(Filter(MyRoomReservations, Date = Today(), Rooms.Value = Room.Value)),
Collect(collAvailableRooms, Room)
)
);
Assign the "collAvailableRooms" collection to Items property of Rooms combobox.
Thanks,
@SunilPashikanti
