Answered

Date Picker: Not Allow to Pick Friday if its Thursday evening

(0) Share

Report

Posted on by KT03

I want to Build a Powerapp where it can Only be saved or Datepicker can only be picked if its not Thursday evening or Firday itself.

Is there any way this is possible.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Probably, but your request is not super clear. If just want save button, and datepicker control disabled Thursday Evening through Saturday morning, that is simple enough.

If you want save button disabled if thursday or friday is selected on datepicker control, also simple but diff formula.

So let us know more in detail all the steps you are hoping to achieve

Was this reply helpful? Yes No
KT03 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Good morning Rob,

How exactly do I need to do this? I have never been in the need to use Date Picker, so I have no experience with it. My PowerApp will have a save button and a pop up window at the end if that helps.
If possible, I need a form that doesn't allow Thursday night and all of Friday of the same week to be selected or saved if it is Thursday night or Friday. I was thinking of a calculated form where you can't select the next day if it is 12 hours ahead, but don't know if that would even work.

Thanks in advance

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
If I understand the request here are some ideas.

On the submit button to the form you can put this in display mode

Switch(Weekday(Today()), 5, DisplayMode.Disabled, 6, DisplayMode.Disabled, DisplayMode.Edit)

This disables forms submit button on Thursday & Friday

For DatePicker you can set the default to

If(Weekday(Today())=1, DateAdd(Today(),1,Days), Weekday(Today())=2, Today(), DateAdd(Today(), Sum(2-Weekday(Today())), Days))

Which makes default date on the datepicker Monday of the current week

Then in the onchange place this

If(Weekday(Self.SelectedDate)=6 || Weekday(Self.SelectedDate)=5, Reset(Self))

which resets the datepicker to monday if someone attempts to choose thursday or friday off of it

Was this reply helpful? Yes No
KT03 53 on at

Like
a
(0)

Report
Copy link

Link copied!

What do I need to change on the onchange formuar so that it only resets if it is the current week but not a week in the future?

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Add in a || Week(Self.SelectedDate) = Week(Today())

Was this reply helpful? Yes No