Good Afternoon
I have a Power app that enables users to book vehicles by date I have a request to enable users to split the booking by either morning or afternoon, but also for the whole day.
In my gallery filter (of the available vehicles 'CT Fleet List') I've added an extra condition (underlined in bold below), Where "Time" is a Choice column in my SharePoint list of bookings 'CT Fleet Reservations' with the three choices "Morning, Afternoon, All Day" and DropdownTime is the dropdown, see screen grab
Filter(
'CT Fleet List',
!(
Title in Filter(
'CT Fleet Reservations',
('Check Out from' >=DateFrom && 'Check Out from' <= DateTo) ||
('Check Out to' >=DateFrom && 'Check Out to' <= DateTo) || (Time.Value = DropdownTime.Selected.Value)
).Title
)
)
Although the filter works fine for individual choices it doesn't filter the necessary combinations.
So I think the filters need to work as follows
If Morning chosen then don't display any choices where Afternoon or All Day were selected
If Afternoon chosen then don't display any choices where Morning or All Day were selected
If All Day chosen then don't display any choices where any of the options where selected
But I can't work out how to write the If function to get the filter to work (alongside the dates)
Any suggestions
Regards
David
