Block days of the week on the calendar

(0) Share

Report

Posted on by Guicord101

151

Hi guys!
In my app there users must select a certain date:

I would like two things:
I wish it wasn't possible to select days on Thursday and Friday, is that possible?
I would like it to only be possible to select a date 40 days after the current date, is that possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

MF-12051538-0 402 on at

Like (0)

Report
Copy link

Link copied!

Hi @Guicord101 ,

There is no way of removing dates from the calendar control. One option would be to create a warning message to select a different date if the date selected is a Thursday, Friday, or less than 40 days in the future.

You can set the Visible property of your label (and/or icons) to this:

With(
{
selectedWeekday: Weekday(DatePicker1.SelectedDate),
selectedDate: DatePicker1.SelectedDate
},
selectedWeekday = 5 || selectedWeekday = 6 || selectedDate >= DateAdd(Today(), 40, Days)
)

If you found this post helpful, please consider Accepting it as the solution.

Was this reply helpful? Yes No
Guicord101 151 on at

Like (0)

Report
Copy link

Link copied!

How do I create this notification message? I did not understand

Was this reply helpful? Yes No
MF-12051538-0 402 on at

Like (0)

Report
Copy link

Link copied!
That notification message is just really an icon and a label in the app.

Here are the steps:

Insert an icon (from the 'Insert' tab)

Select the "Warning" icon, which is about 2/3 down the list

Place the warning icon near your Date Picker

Insert a Label next to the warning icon

For the text of this label, add the message you would like to display

For both the label and the icon you just added, change the "Visible" function (from the dropdown in the top left) to this code (replace "DatePicker1" with the name of your Date Picker control):

With(
{
selectedWeekday: Weekday(DatePicker1.SelectedDate),
selectedDate: DatePicker1.SelectedDate
},
selectedWeekday = 5 || selectedWeekday = 6 || selectedDate >= DateAdd(Today(), 40, Days)
)

This icon and warning message will then only appear if somebody has selected an incorrect date.

Was this reply helpful? Yes No
Guicord101 151 on at

Like (1)

Report
Copy link

Link copied!

It worked!!
I would like to know if it is possible for me not to allow the person to submit the form if the selected date is on Thursday or Friday.
If possible, I would like the message to appear notifying her when not submitting the form

Was this reply helpful? Yes No
MF-12051538-0 402 on at

Like (0)

Report
Copy link

Link copied!

Absolutely. You can alter the same code and use that in the "Display Mode" function of your Submit button. Try this for Display Mode:

With(
{
selectedWeekday: Weekday(DatePicker1.SelectedDate),
selectedDate: DatePicker1.SelectedDate
},
If(
selectedWeekday = 5 || selectedWeekday = 6 || selectedDate >= DateAdd(Today(), 40, Days),
DisplayMode.Disabled,
DisplayMode.Edit
)
)

If you found this post helpful, please consider Accepting it as the solution.

Was this reply helpful? Yes No
Guicord101 151 on at

Like (0)

Report
Copy link

Link copied!

This code worked when I select dates on Thursday and Friday. However, when I select dates 10 days later, the code does not work. I would like the warning to appear when the selected date is before 40 days after the current date
In both cases this happens.

Was this reply helpful? Yes No
MF-12051538-0 402 on at

Like (0)

Report
Copy link

Link copied!

Hi @Guicord101 ,

That will just require a quick change from 'greater than or equal' to 'less than'. Adjusted code is below.

For label warning:

With(
{
selectedWeekday: Weekday(DatePicker1.SelectedDate),
selectedDate: DatePicker1.SelectedDate
},
selectedWeekday = 5 || selectedWeekday = 6 || selectedDate < DateAdd(Today(), 40, Days)
)

For Submit button Display Mode:

With(
{
selectedWeekday: Weekday(DatePicker1.SelectedDate),
selectedDate: DatePicker1.SelectedDate
},
If(
selectedWeekday = 5 || selectedWeekday = 6 || selectedDate < DateAdd(Today(), 40, Days),
DisplayMode.Disabled,
DisplayMode.Edit
)
)

If you found this post helpful, please consider Accepting it as the solution.

Was this reply helpful? Yes No
Guicord101 151 on at

Like (0)

Report
Copy link

Link copied!

It worked!!
However, as my "DefaultDate" is set to "Today()" the warning always appears. Do you know how to set "DefaultDate" to be a date in the future (example: 01/01/2999) or 40 days in the future?
Thank you very much for your help. You are helping me to develop an application for over 7000 people.

Was this reply helpful? Yes No
Verified answer

MF-12051538-0 402 on at

Like (1)

Report
Copy link

Link copied!

You can use this as the Default Date:

DateAdd(Today(), 40, Days)

If you found this post helpful, please consider Accepting it as the solution.

Was this reply helpful? Yes No
Guicord101 151 on at

Like (1)

Report
Copy link

Link copied!

THANKSS!!! YOU'RE AMAZING!

Was this reply helpful? Yes No