Answered

Disable Selection of Weekends in Canvas App Date Picker

(0) Share

Report

Posted on by ruihaolrh

473

I have a requirement to disable selection of weekend dates in Canvas App datepicker control.

In addition, I would need to store all dates belonging to weekends in a collection, so I can skip those dates during Patch() statement.

May I know if the above are possible?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

vaubeee 533 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @gymcode! Have a look at @AmDev s solution: DatePicker restrict weekend days (Saturday & Sunday)
Hope this helps 👍

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.
ruihaolrh 473 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @VauBee , thanks for the suggestion. I read the answer, but have some clarifications for @AmDev , which I will post it here as well, if you could answer too. Thank you.

Referencing to @AmDev's solution , for the following code to be input to Date Picker, I am unable to locate all the fields.

Onselect: Set(varDate, Self.SelectedDate)
DefaultDate: If(Weekday(varDate) =1 || Weekday(varDate) =7, Blank(), varDate)
InputTextPlaceholder: If(IsBlank(Self.SelectedDate), Text("DD/MM/YYYY"))

Below are my findings on the fields that matches, or potentially represents, for both Classic and Modern Datepicker controls.

1) OnSelect -> Classic (OnSelect) / Modern (SelectedDate?)
2) DefaultDate -> Classic (InitialPickerDate? Value? Today?) / Modern (SelectedDate?)
3) InputTextPlaceholder -> Modern (Placeholder?)

Classic DP Control fields
OnChange
OnSelect
AcceptsFocus
AccessibleLabel
AllowTextInput
ContentLanguage
FillColor
FirstWeekOfYear
Font
FontSize
FontWeight
IconFill
IconSize
InitialPickerDate
MaxDate
MinDate
PaddingBottom
PaddingEnd
PaddingStart
PaddingTop
ShowGoToToday
ShowWeekNumbers
TextColor
Today
Tooltip
Value
DisplayMode
Height
Visible
Width
X
Y

Modern DP Control fields
OnChange
AccessibleLabel
BasePaletteColor
ContentLanguage
EndYear
Font
FontColor
FontItalic
FontSize
FontStrikethrough
FontUnderline
FontWeight
Format
IsEditable
PlaceHolder
SelectedDate
StartOfWeek
StartYear
ValidationState
DisplayMode
Height
Visible
Width
X
Y
ruihaolrh 473 on at

Like
a
(0)

Report
Copy link

Link copied!
I saw a solution that counts all weekdays between 2 dates, in the following link:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Excluding-weekends-in-date-differences-in-PowerApps/m-p/1966066#M492979

I am trying to modify it so that it stores all weekend, or weekday dates, so I can avoid Patch() function for those dates.

With( { // generate a one-column table of all dates between start date & end date varDateRange: ForAll( Sequence(dte_EndDate.SelectedDate - dte_StartDate.SelectedDate + 1), dte_StartDate.SelectedDate + Value - 1 ) }, If( And( IsBlank(dte_StartDate.SelectedDate), IsBlank(dte_EndDate.SelectedDate) ), // show nothing if any date pickers are blank 0, // show only dates Monday to Friday and exclude holidays CountIf( varDateRange, And( Weekday(Value) in [2, 3, 4, 5, 6], Not(Value in 'Holiday Calendar'.HolidayDate) ) ) ) )