function to date picker

[helpneeded1]

Is it possible to add condition to date pickers? So i have two datepickers, starting time and ending time. I'm supposed to have a feature that shows already booked times that cannot be selected. So user can only select the date on days other than booked ones. I got help las week but it gives me those dates that are not available to the dropdown. I maybe want that there is dates that are available on the dropdown. Thanks.

[v-bofeng-msft · Accepted solution]

Hi @helpneeded1 ，

Do you want to get the records whose dates are available but the formula only return not available dates?

If so,  you can use "! function "negates the entire condition, for example:

Filter(DataSource;!(Original conditions))

Best Regards,

Bof