SharePoint delegation show all free desks on specific date

[Mitchelvdh]

Hi there,

I'm currently building an app where people can reservate their desk.

In a gallery I want to show the free 'bookable' desks received from a SharePoint list named 'Reservations'

When I Filter on the reservation list (Reservaties), I want to find all reservations on the specific date.

The Text(reservatieDatum, "dd-m-yyyy") has to be equal to the Selected date (Line underneath) in the datepicker in the app.

Because we're asking to look through the whole reservation list for all dates, it gives me a delegation error (understandable).

I know there won't be more than 100 reservations on a day, but maybe in the future, so I want to optimize it as well as possible.

Is there any way I can write this formula so there wont by any delegation errors?

[RandyHayes · Accepted solution]

@Mitchelvdh 

You might want to consider instead of trying to format the underlying Date column into a text format, to simply use the selected date in your date picker.  Your reservatieDatum is already a date column, and the selectedDate in your datum_kiezen datepicker is also a date.  You can compare them without converting them to text.

I hope this is helpful for you.

[Mitchelvdh]

@RandyHayes Thank you for your reply 🙂

Could you try to explain why it works now? I understand you're not formatting the dates anymore, but what has it to do with delegation? In my imagination you're still trying to filter through all the reservations of that current date, so when it comes above 1/500/2000 (delegation limit) there will still be a delegation error, or am I wrong?

Looking forward to your answer, and thanks in advance!