web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Enable certain dates o...
Power Apps
Unanswered

Enable certain dates on weekend

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello Everyone!

 

I came across with a problem, that I have a reserve application, where weekends cannot be reserved. I solved that part, but now I have certain weekend days, that I must be able to reserve, as they are work days. 

 

Is there any way, to unlock those certain dates, where you have to work n weekend?

 

Thank you for your responses in advance!

Categories:
  • v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi@Anonymous,

     

    Do you want to select those weekends that require work?

    Maybe you could create a whitelist for them as shown below.

    I have made a test for your reference.

    vyujincuimsft_0-1639361964086.png

    1.Add a DatePicker Control.

    2.Add a Button Control and apply the following formula as:

     

    If(
     DatePicker1.SelectedDate in 'Special Dates'.Date && (Weekday(
     DatePicker1.SelectedDate,
     Monday
     ) = 6 || Weekday(
     DatePicker1.SelectedDate,
     Monday
     ) = 7),
     Notify(
     "This is a special day(Working day)",
     NotificationType.Information
     ),
     If(
     Weekday(
     DatePicker1.SelectedDate,
     Monday
     ) = 6,
     Notify(
     "This is Saturday",
     Warning
     ),
     If(
     Weekday(
     DatePicker1.SelectedDate,
     Monday
     ) = 7,
     Notify(
     "This is Sunday",
     Warning
     ),
     Notify(
     "This is Working day",
     Information
     )
     )
     )
    )

     

     Result Screenshots:

    ResultGif.gif

     

    Best Regards,

    Charlie Choi

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I have a custom calendar in use, where I change the displaymode, but i believe this could be something that I am looking for.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    It is not 100% what I want I want that in DisplayMode the selection of that certain that is enabled.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 432 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 347

#3
WarrenBelz Profile Picture

WarrenBelz 254 Most Valuable Professional

Last 30 days Overall leaderboard