function to date picker

(0) Share

Report

Posted on by 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.

Näyttökuva 2022-11-1 kello 11.41.52.png

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No