Power Platform Community Forum Thread Details

I've got a power app feeding off two SharePoint lists, it is used to book desks in the office. The filter on the gallery works by looking to see that the date and time does not already exist in the SharePoint list. This part is working fine.

I've added a combo box to use as a location field. E.g. Office 1, Office 2 and I'm trying to add this into the exiting filter code so that the gallery only shows the available desks within the selected office populated in the combo box.

The field with the office location is located in Desks list with bookings going into Desk Reservations list

I've got the following code and tried to add another Filter condition, & condition, search but I've just had no luck.

Any assistance on what conditions to use / how to place them in the below code would be much appreciated.

Filter(Desks,Not(Title in Filter(
'Desk Reservations',
CheckOutFrom >= startTime && CheckOutTo <= endTime || CheckOutFrom <= endTime && CheckOutTo >= endTime
).DeskText))

Categories:

Building Power Apps

Hi @Anonymous ,

Based on your description and formula, I think your Desks.Title has same value with 'Desk Reservations'.DeskText, also startTime and endTime is two date picker controls inside your app. If I misunderstand, please let me know.

If yes, I do a simple test on my side based on your formula, since your formula works well to return a filtered table by date, you can then add another filter() to directly filter this returned table.

So add a combobox control called “ComboBox1”, then set Items property of gallery as below:

Filter(Filter(

 Desks,

 Not(Title in Filter(

 'Desk Reservations',

 (CheckOutFrom >= startTime.SelectedDate&&CheckOutTo <= endTime.SelectedDate) || (CheckOutFrom >= endTime.SelectedDate&&CheckOutTo <= endTime.SelectedDate)).DeskText

)),

Title=ComboBox1.Selected.Value

)

Best Regards,

Allen