I’m building a booking/reservation system and I’ve been struggling with filtering two drop down controls using a date picker control.
Each drop down is connected to a separate SharePoint list and the ‘DatePicker’ control is ‘patching’ to a 3rd list that contains all of the bookings/reservations of the items in the other two lists.
I need to filter those drop down list items based on whether or not an item has already been created, to only show items that are 'available' on the [SelectedDate] value of the ‘DatePicker’ control.
Here’s what I’ve got so far but isn’t working due to the error below…
Filter(Desks,Not(‘Title’ in Filter(Desk_Booking,Reservation_Date = DatePicker.SelectedDate).Desk))
…”Power Apps can’t convert this Text to a Record”.
That error is specific to the ‘Title’ value in the first Filter function.
'Title' refers to the title column in the ‘Desks’ list and .Desk refers to the use of that title column value (Lookup column type) in the main ‘Desk_Booking’ list. 'Reservation_Date' is the date column in the main Desk_Booking list that's patched by the submit button on completion.
I’ll need to repeat this logic for the 2nd of the two drop downs (identical in all but name) so that both selections are constrained by the available resources, for the selected date.
Can you see my mistake?
N03L.
