How to limit date picker selection options in power apps - Part 2/2
HTML-код
- Опубликовано: 29 июн 2024
- 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 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 Наука
Let me know what else you want to see in the future videos
The use of "with" function and " coalesce" function
Just curious. How do we approach excluding holidays?
@@perryham easy. Store all upcoming holiday dates in a list or table and exclude those dates from combo box items.
How to get a calendar ID to display my outlook calendar meeting on the power apps as gallery list items? I am in great need of it and i don't find any promising reference from internet
Very useful and thanks for your efforts!
Hello Alireza, Thank you for such beutiful information, I need to show only weekends(Saturday and Sunday) and need to add multipal entries for saturday and sunday and this cound must be seen in the form of number how can I do this, could you please help
i.e weekedns only and count of weekend