Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get date for this week

Hi , 

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 . 

Community Support Team
Community Support Team

Re: Get date for this week

Hi @Anonymous,


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") 

Reference here:




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

Re: Get date for this week

Hi @v-monli-msft , 

Your reply is not an answer to any of my 3 questions . 


Helpful resources


Power Apps Super User Class of 2020

Check it out!


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,067)