Hello!
I am working on a kit reservation application. We have 2 SP lists - one is a list of the kits & one is a list of the reservations. When users enter the app, they choose a check in and check out date. I want my gallery to filter and show only kits that are available during their selected days- this is the function I am using, and it is not filtering correctly. Sometimes it shows the kits that are available, or it might pull a random unrelated kit out of the list. Any help would be appreciated!
Filter(
'EV Marketing Kits & Descriptions',
Not(
Title in Filter(
'EV Marketing Reservation',
CheckOutFrom >= startDate && CheckOutTo <= endDate || CheckOutFrom <= endDate && CheckOutTo >= endDate
).EVMarketingKit1
)
)
EV Kits and Descriptions - SP list of kits
EV Marketing Reservation- list of reservations
Checkout From / CheckOutTo - columns in reservation SP list
start date- variable being set on start date picker
end date- variable being set on end date picker
Title- title column in EV Kits and Descriptions SP list
EVMarketingKit1- Kit name column in Reservation SP list