I have a weekly calendar as a planner for my colleagues where we can see for one week who is working at the office, who is working from home , who has a meeting and where etc .
At the top of the calendar are the week days: Sun Mon Tue Wed etc .
My questions are :
1. How to remove the Sunday and Saturday from WeekDay gallery ?
2.How to add on the side of the gallery items the dates for that particular week , an example for this week : Mon/29 Tue/30 Wed/31 Thu/1 Fri/2 ?
3.How to make the Gallery with 5 days for only one week and asign the plan of a worker for one week to a row in the calendar ?
In advance thanks for the help .
You can put below formula into a label as a warning and/or gray out the submit button to prevent the user from submitting until they have correct the issue.
If(Weekday(DatePicker1.SelectedDate, StartOfWeek.Sunday) = 1||Weekday(DatePicker1.SelectedDate, StartOfWeek.Saturday) = 7 , "You have selected weekend, change the selection")
Hi @v-monli-msft ,
Your reply is not an answer to any of my 3 questions .
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand