Power Platform Community Forum Thread Details

Hi all,

I'd love some help on this one, my first proper Power App for desk booking

I've attached a screen shot, but I am trying to make it so when you have selected the second date in the date picker 'Date to' it checks the 5 desks to see which are available and shows them in the drop down for Desk Number.

At the moment my design is that I have 5 columns in the Sharepoint list, Desk Number, Booked for, Date from, and Date to, then a status column.

All my columns are text and the logic is done in the Power App. At the moment when you fill in the below and click 'confirm booking' it patches all the fields, and does an UpdateIf for changing the status column to booked.

Ideally I want to use three status options either Booked, Available, or Not available

I've never done much with dates before, and I've been looking at the formulas and thinking the ForAll function would be the way to do it? I just don't really know the best way to put that together, and also look to see which desk are available on the selected dates.

Screenshot