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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Starting day of the we...
Power Apps
Unanswered

Starting day of the week (Sunday to Monday)

(0) ShareShare
ReportReport
Posted on by

Hello everyone!

 

I am making a custom gallery calendar, and I have a label with the following formula: Calendar.WeekdaysShort()

 

By default, the starting day of the week is Sunday, but I would like it to be Monday

 

Picture context: "vas" means "sun", "hét" means "mon" etc...

I would like it to be to start from Monday.

2022-04-04_13h29_21.png

Categories:
I have the same question (0)
  • Nogueira1306 Profile Picture
    7,390 Super User 2024 Season 1 on at

    https://www.youtube.com/watch?v=SlfnhQgMXrY

     

    https://www.youtube.com/watch?v=8qqEfzdVM0Y

     

    https://www.youtube.com/watch?v=8qqEfzdVM0Y

     

    If you need additional help please tag me in your reply and please like my reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️!

    Best regards,

    Gonçalo Nogueira

    Check my LinkedIn!

    Buy me a coffee!

    Check my User Group (pt-PT)!

    Last Post on Community

    My website!

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on at

    Hi @Anonymous,

    Do you want to change the first day as Monday using the Calendar.WeekdaysShort()?

     

    If you want to achieve this using the Calendar.WeekdaysShort(), I am afraid there is no OOTB in Power Apps. You could directly replace it with [ "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun" ].

     

    Then I will suggest you use the Calendar template within Power Apps, and you should modify something as below:

    There is a small change required to the calculation of the first day in view variable
    
    Set(_dateSelected, Today()); 
    Set(_firstDayOfMonth, DateAdd(Today(), 1 - Day(Today()), Days)); 
    Set(_firstDayInView, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 ), Days)); 
    Set(_lastDayOfMonth, DateAdd(DateAdd(_firstDayOfMonth, 1, Months), -1, Days))
  • usaman45 Profile Picture
    314 on at

    Great, but it looks missing the last Sunday on the last row. Anyway to fix it?

    usaman45_0-1656017907694.png

     

  • iburkart Profile Picture
    24 on at

    @usaman45 You need to slightly change the visible attribute of the Title inside the MonthDayGallery

    !(DateAdd(_firstDayInView,ThisItem.Value,Days) - Weekday(DateAdd(_firstDayInView,ThisItem.Value,Days),StartOfWeek.Monday) + 1 > _lastDayOfMonth)

    You need to add StartOfWeek.Monday inside the Weekday function. That way the number starts at 1 on a Monday and not on a Sunday.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard