I'm pulling data into a gallery from one SharePoint list called Desk Reservations
Sort(
If(
DesksListsGallery.Selected.Name = "Zone 1",
Filter(
'Desk Reservations',
CheckOutFrom >= StartDateTime && CheckOutTo <= EndDateTime && Location = "Zone 1" && Cancelled = Blank() || CheckOutFrom <= EndDateTime && CheckOutTo >= EndDateTime && Location = "Zone 1" && Cancelled = Blank()
),
DesksListsGallery.Selected.Name = "Zone 2",
Filter(
'Desk Reservations',
CheckOutFrom >= StartDateTime && CheckOutTo <= EndDateTime && Location = "Zone 2" && Cancelled = Blank() || CheckOutFrom <= EndDateTime && CheckOutTo >= EndDateTime && Location = "Zone 2" && Cancelled = Blank()
),
DesksListsGallery.Selected.Name = "Zone 3",
Filter(
'Desk Reservations',
CheckOutFrom >= StartDateTime && CheckOutTo <= EndDateTime && Location = "Zone 3" && Cancelled = Blank() || CheckOutFrom <= EndDateTime && CheckOutTo >= EndDateTime && Location = "Zone 3" && Cancelled = Blank()
),
DeskText,
Ascending
)
Am I able to add another filter from a 2nd SharePoint list called Desks where active=0 and pull the Title?
Desks SharePoint list looks like this
| Title | Active | Description |
Desk 1 | 0 | Zone 1 |
| Desk 2 | 1 | Zone 1 |
| Desk 3 | 1 | Zone 1 |
Desk 1 | 1 | Zone 2 |
| Desk 2 | 1 | Zone 2 |
| Desk 3 | 0 | Zone 2 |
Desk 1 | 1 | Zone 3 |
| Desk 2 | 1 | Zone 3 |
| Desk 3 | 1 | Zone 3 |
