Power Platform Community Forum Thread Details

I need to freeze the date picker calendar for 2nd working day/business day of upcoming month.

For Example : if the 2nd date of next month falls on Saturday then user can be able to select the date for next business day i.e. 4th day( Monday) . Otherwise if the 2nd date falls on Sunday then user can able to select the date for next business day i.e. 3rd day( Monday) . if the 2nd day falls on Mon/Tue/Wed/Thu/Fri then user can be select up to 2nd date only i.e. remains same only.

Can anyone help me with this problem.

Categories:

Building Power Apps

Hello venugopal1,

you can achieve this by using a formula in the DefaultDate property of the DatePicker. This formula will calculate the date and adjust it if it falls on a weekend. Here’s the formula you can use:

With(
    {NextMonth: DateAdd(Date(Year(Today()), Month(Today()) + 1, 1), 1, TimeUnit.Days)},
If(Weekday(NextMonth, StartOfWeek.Monday) > 5,
DateAdd(NextMonth, 8 - Weekday(NextMonth, StartOfWeek.Monday),
TimeUnit.Days),
NextMonth)
)

Place this formula in the DefaultDate property of your DatePicker. It calculates the 2nd day of the next month and adjusts it to the next Monday if it falls on a weekend.

Regarding restricting the date range in the DatePicker, PowerApps does not natively support restricting the date selection to a single specific day (as far as i know).

However, you can set the DatePicker to DisplayMode.View to prevent users from changing the selected date. This way, the DatePicker shows the calculated date but does not allow user interaction to change it.

I hope this helps you!