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 :

PowerApps Calendar

TheRobRush Profile Picture Posted by TheRobRush 11,128 Moderator

The calendar now has 4 controls as its body to facilitate the ability for it to go from a full week calendar to weekdays only while still maintaining its same border look for both, these can be deleted returning it to 1 control without any issues

 

Recording-20230421_151711 (2).gif

 

New Version Features:

 

Default Dateset includes all Holidays & Weekends 5 years prior and post the current date

 

Holidays are formulaic for any holidays that do not fall on same date yearly

 

Buttons at Bottom can add or remove weekends from holiday set

 

On the left, top gallery lets you see the next business day after X days from today, or x months, or x years. (This is you say give me the next available day 10 days from now, if that day is a weekend or holiday it gives you the next non-special date) Can do same thing to tell you x number of business days from now, wouldn't be difficult just not how its currently written.

 

Bottom left gallery shows you how many of each day of the week is left in the year from today on

 

(both the above galleries will switch to from the date selected as opposed to today IF you select a date on the calendar)

 

Gallery on right of screen allows you to select x days randomly on the calendar. and remove each individually if needed.

 

top tight label shows you if the current year is a leap year

 

toggle at top swaps calendar from 7 day display to 5

 

clicking a date on calendar will select it and it turns blue, holiday table dates highlighted pink, randomly chosen days green

 

added a second screen with a custom made version of the date picker that can be locked to only allow the user to select certain days of the week

 

feel free to add other requests in comments as time goes on I will try and add requested features

Categories:

Comments

  • TheRobRush Profile Picture TheRobRush 11,128 Moderator
    Posted at
    PowerApps Calendar

    Yes Karthik by default you can only hand select one date, but can use the random selector i added on right for you to select several random dates all at once, to chaneg ability to manually select more than one youd need to adjust the onselect where it chanegs whatDay, and do some sort of a switch(countrows(filter(newcollection,date=thisitem.etc)),0 collect(newrows,this items date), removeif(newcollection, date=thisitems date)), something like that so you could add and remove dates into a new collection of dates manually

  • Karthik_M Profile Picture Karthik_M
    Posted at
    PowerApps Calendar

    Thank you @TheRobRush 

     

    I'm unable to select multiple dates - am I missing something? 

  • TheRobRush Profile Picture TheRobRush 11,128 Moderator
    Posted at
    PowerApps Calendar

    @Anonymous  I have uploaded an update to this template, on its second screen titled

    miniCal

    you will find a clone of the datePicker tool that will allow you to only have selected days of the week available to select.

     

    it is set by default to only sunday selectable. To edit this click the control inside of the Gallery titled

    MiniCal

     

    the control name is

    EveryDay_1

     

    go to its display mode and edit

    Switch(
     Weekday(DateAdd(fluxcapacitorVar,Sum(Weekday(fluxcapacitorVar)-ThisItem.Value)*-1,TimeUnit.Days)),
     1,DisplayMode.Edit,
     DisplayMode.Disabled)

     

    where 1, displaymode.edit is the portion you need to edit, 1 is sunday, 2 monday and so on.

  • hsfournier Profile Picture hsfournier 106
    Posted at
    PowerApps Calendar

    @TheRobRush you made my weekend! Thank you so much! 

  • TheRobRush Profile Picture TheRobRush 11,128 Moderator
    Posted at
    PowerApps Calendar

    @hsfournier your request has been added to the template

    @Karthik_M your request has been added to the template

  • Karthik_M Profile Picture Karthik_M
    Posted at
    PowerApps Calendar

    yes, that would be great - looking forward to that solution

  • TheRobRush Profile Picture TheRobRush 11,128 Moderator
    Posted at
    PowerApps Calendar

    yes @Karthik_M that would not be too difficult.

    I will make an update when I get the time, may be a bit as I have a fairly heavy workload

  • Karthik_M Profile Picture Karthik_M
    Posted at
    PowerApps Calendar

    Possible to include an option where we can select multiple dates in a month randomly?

  • TheRobRush Profile Picture TheRobRush 11,128 Moderator
    Posted at
    PowerApps Calendar

    Yah you'd just need to set visibility of the controls to be false on saturdays and sundays. Then remove them from the header gallery

  • hsfournier Profile Picture hsfournier 106
    Posted at
    PowerApps Calendar

    Is it possible to set this calendar to just show Monday to Friday, and exclude Saturday and Sunday altogether?