#StackBounty: #sharepoint-online Workaround for NOT and IN

Bounty: 50

I am creating a desk reservation app and use the code below to see if the chosen desk is available, but get a delegation warning for using Not and In. I know that the reservation list will have more than 2,000 records (changed from the default 500). Initially I thought a For loop might work only to find there is not such thing in PowerApps. Is there a workaround?

Filter(
    Desks,
    Not (DeskID in Filter(
        DeskReservations,
        ReservationStartTime <= DeskReservedFrom && ReservationEndTime >= DeskReservedTo || 
        ReservationEndTime > DeskReservedTo && ReservationEndTime < DeskReservedTo || 
        ReservationStartTime > DeskReservedFrom && ReservationStartTime < DeskReservedTo || 
        ReservationEndTime > DeskReservedFrom && ReservationEndTime < DeskReservedTo
    ).ReservedDeskID),
    Building = ReservationBuilding, Active = 1
)


Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.