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
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 )