Date picker allow only certain days

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a date picker where the default date will be a Thursday and users are only allowed to select Thursdays.

I can create a textbox for the second part if I can't disable others, but I don't know how to set to only Thursdays.

Help will be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

CarlosFigueira Microsoft Employee on at

Like
a
(5)

Report
Copy link

Link copied!
Currently the DatePicker control doesn't support limiting the dates that the user can select by week day (you can limit the year range that can be selected). Please consider creating a new feature request in the PowerApps Ideas board for this.

An alternative for your scenario would be to display some sort of visual indication that the selected date is invalid. For example, you can have this formula for the BorderColor property of the date picker:
If(Weekday(DatePicker1.SelectedDate, StartOfWeek.Sunday) <> 5, Color.Red, RGBA(101, 128, 187, 1))
That will set the border of the picker to red if the date is incorrect. You can also have a label that tells the user what the problem is, for example, using this formula for its Text property:
If(Weekday(DatePicker1.SelectedDate, StartOfWeek.Sunday) <> 5, "Chosen date must be a Thursday")

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect. All sorted now

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
For some reason, the above-mentioned solution does not work for me. Albeit my purpose is slightly different then the OP's, my intentions are the same; I wish to let users know if they have chosen an invalid date, i.e. a non-Tuesday.

If(Weekday(SelectedDate, StartOfWeek.Monday) = 2, Color.Red, RGBA(101, 128, 187, 1))

But the BorderColor returns with an error, stating that the Weekday function has some "invalid arguments". Any thoughts as to why that might be?

Was this reply helpful? Yes No