Power Apps date validation? Use this combo box hack instead
What if you want to let the user pick only the next 5 business days as value in a Power Apps form? Power Apps date picker doesn’t support this kind of limitation/validation, but we can definitely do it in a combo box. In this video you will see how to show only the next few business days in the comb box.
To enroll in my Udemy courses see below link for discount vouchers https://sslwsh008.securedata.net/dotn...
This is the magical formula in the video that you can paste it in your Combo box:
Filter(
DropColumns(
AddColumns(
AddColumns(
Sequence(7),
"Date",
Today() + ThisRecord.Value
),
"DateString", Text(ThisRecord.Date,"yyyy-mm-dd"),
"DayOfWeek", Text(ThisRecord.Date,"dddd")
),
"Value"
),
Not(
ThisRecord.DayOfWeek in ["Saturday","Sunday"]
)
)
0:00 Introduction
1:45 Solution strategy
4:43 Adding the date picker combo box to Power Apps
10:15 Things to remember
10:51 Conclusion
Contact me
LinkedIn / alirezaaliabadi
Twitter / aaliabadi1
Instagram / alireza.aliabadi_ig
Facebook / alireza.aliabadi.fb