PowerApps Calendar Control - Build your own using Galleries

[@Me-of9vf]

All this work for just a calendar... PowerApps how can you do this?!! Masive respect for you Shane. 👌👌

[@ShanesCows]

Thanks. Happy to help. Good news once you get the hang of it, the process isn’t too bad.

[@naseerabed4244]

Explained the demo amazingly!!! Thank you! By the way, we can use these two formula to navigate to next month and previous month: Set(varVideoMonth, Date(Year(varVideoMonth),Month(varVideoMonth) + 1, 1)); Set(varVideoMonth Date(Year(varVideoMonth),Month(varVideoMonth) -1, 1));

[@vincephillips5358]

Great work Shane!! Very useful concept😁😁😁👍👍 For any UK users the initial formula format needs to change to fit dd/mm/yyyy Set(varMonth, DateValue ("1"&"/"&Month(Today()) & "/"&Year(Today())))

[@ShanesCows]

Vince I show dd/mm/yyyy later in the video. My thought was use the date "American style" and only change it at presentation time?

[@MaliYojez]

Being in the UK, I found the calculation went wrong when embedding the Power App on a site page (the site's region was correct). The addition of en-GB here fixed the issue Set(varVideoMonth, DateValue("1" & "/" & Month(Today()) & "/" & Year(Today()), "en-GB")); Oddly, even without that small change, it worked perfectly as a standalone or added to Teams.

[@tilman1]

Hi Shane, phantastic as always, amazing solution! The unflexibility of the onbaord calendar control has always bothered me, and this will be a great progress in it. Just one thing 'I noticed: This year we had a February starting with Monday. So to be 100,00% perfect, the sequence formula for the gallery items could be extended to: Sequence( If(DateDiff(varVideoFirstDayView, DateAdd(varVideoMonth, 1, Months), Days)>36,42, If(DateDiff(varVideoFirstDayView, DateAdd(varVideoMonth, 1, Months), Days)>29,35,28 ))) Cheers, Tilman

[@tilman1]

(If February has only 28 days and week configured as beginning with Monday)

[@ShanesCows]

Thanks Tilman. 🐶

[@JennyJenn831]

Shane, no lie, I cheered out loud no less than 3 times as I worked along with you on this one. Can't thank you enough!

[@ShanesCows]

I ❤️ it Jennifer! Keep up the good work.

[@kimgaskins5537]

Thanks Shane. I just replaced a calendar control that wasn't working with the one you just did!!!! Thanks for sharing!

[@ShanesCows]

Awesome 😎

[@zpvnrt]

YEA -- I was just looking at SharePoint and all of the overlay methods to build a color coded vacation calendar in classic; however, we have the modern views enabled... sigh and here you are again with the answer to my task at hand - like reading my mind!!! >> THANK YOU

[@ShanesCows]

Glad it was helpful! I have been practicing my work as a psychic . 😹

[@louiscutmore]

Fan-flippin-tastic! Thanks for the Monday and non-US date version. Very helpful for your non-American friends 😊 Bring on Part Deux

[@ShanesCows]

Next Monday :)

[@kismetGH]

Thanks a lot! Teaching every steps in details, very easy to follow!

[@ShanesCows]

Happy to help! Have a great week.

[@bjclark3107]

A great resource. I found I had a smoother experience building a collection of dates based on your dateadd function and using that for the calendar items. All the same a great video, thank you.

[@4-r-k]

Microsoft cannot provide builtin native Calendar Control in PowerApps? This is a total speechless moment! Anyway, your approach is awesome!!

[@ShanesCows]

Thanks

[@emanueleciccia9388]

Hi Shane, your video was so fantastic. Please, how can I create the variable "varFirstDayMonth", with which value?

[@ToddWantz-v5y]

I apprecate the walk though. I addressed the number of active weeks with an algorithum. - I subtracted the end of the month date from the beginning of the range date minus 1, - I rounded down (I had an extra decimal from the previous step) - Devided by 7 - Rounded up - Multiplied by 7 This also handled Feb 2026 which has 4 weeks only.

[@gerusnero]

incredible work. even such a simple solution to change the start of week for us Europeans :D (had me scratching my head during the video until you so elegantly solved it!)

[@ShanesCows]

Glad to help and glad someone on Twitter reminded me.

[@parranoic]

If you are in an European country using DD/MM/YYYY use: Date(Year(Today()), Month(Today()), 1) for varVideoMonth instead of: DateValue(Month(Today()) & "/" & "1" & "/" & Year(Today())) If you don't, you will end up the calendar defaulting to January (since month and day are inverted) and the day will be the current month.

[@ShanesCows]

Thanks for sharing.

[@estherlopeznavarro6100]

Great video! Thanks Shane!! It is really fun to watch your videos!

[@ShanesCows]

Thanks 😊

[@bootsbax]

Thanks Shane! I’m looking forward to the second part too!

[@ShanesCows]

I think at this point if I don't release it next Monday I will be in trouble. 😊

[@seyitc1942]

One of your best videos! This knowledge helps a lot to develop some great Apps with a lot of functionalities. Looking forward to part two :) Greetings from Germany

[@ShanesCows]

Awesome, thank you!

[@parranoic]

Shane thank you so much for this, you don't now how much you helped me :).

[@ShanesCows]

Awesome Don!

[@manueldipaolo9708]

You're amazing!. I just needed to see a video like this! Thanks so much.

[@ShanesCows]

You're so welcome!

[@chrislee3378]

Thanks Shane, my company already thinks that I'm a magician..... lol, thanks to your videos!

[@ShanesCows]

Awesome Chris. Tell them we (I mean you 😂) deserver a raise.

[@jamesf.thomas7583]

Shane this was a great video tutorial on building the calendar application. Thank you for spending the time to make this video, and great job doing it.

[@bernierainerguy]

Thanks Shane - great video, really helpful. Can you provide the link to Part 2 please - the child gallery with the data - cheers

[@TyRey]

great one! Looking forward to part two

[@ShanesCows]

I promise it will be a week from today. ♥

[@mohdhanif8069]

Awesome shane , looking forward part two

[@ShanesCows]

6 days. 😎

[@karolinaunderwood1039]

Another great video Shane, thank you.

[@ShanesCows]

My pleasure!

[@annadewitt123]

Hello Shane! I suggested this calendar topic couple weeks ago at one of your tweet, I was looking forward to see it :) Thank you for this great video. I couldn't completely watched it yet, but I hope it involves (or will involve) picking date or date range for arranging appointments and it shows week numbers and events like holidays.

[@ShanesCows]

Thanks for the idea Anna! I couldn't remember how I got down the rabbit hole. 😹 Too many rabbit holes at this point.

[@vitorcalcenoni5385]

Just what I was looking for! Thanks man!!! 🙌🙌🙌🙌

[@ShanesCows]

Awesome, glad to help.

[@alejandraacosta4796]

Muchas gracias Shane, este video fue espectacular! tus tutoriales son realmente didácticos y me han ayudado demasiado. Saludos desde Colombia

[@sininv1]

Shane. This is great. Lookin forward to the part 2. Will u also show how to use calendar to let use block out for meeting ? And unblock. Anyway to send notification to the meeting user involved? Is is able to sync into outlook? Thanks. Thx

[@ShanesCows]

Part 2 is going to be about displaying data from SharePoint on the calendar. Maybe a part 3 will cover working with the source data. Not sure about it yet. Part 2 is next Monday for sure though.

[@abdullahbasher6030]

Greeting from Pakistan..valuable tutorials... learnt alot from you... have suggestion that make sequence of tutorials that will boost the learners understanding step by step... Thanks

[@ShanesCows]

If you go to training.powerapps911.com I have both free and paid classes that are more structured 😀

[@pamsmith1635]

Hey Shane! This video is great! I did notice that when adding the “Days” function it doesn’t seem to work. Do you know whether this has been removed? The formulas seem to work without it (ex. DateAdd(varVideoFirstDayView, ThisItem.Value).

[@pamsmith1635]

Think I figured it out! You have to put “TimeUnit.Days” instead of just “Days.”

[@BigLeafDropper86]

Knowledge BOMBS, thanks Shane!!

[@ShanesCows]

Glad to help. 😀

[@tuicakaukasaimatuku4716]

Awesome Tutorial Shane. Appreciate it!

[@tomaspisecny6038]

Hello Shane, firstly I would like to thank you very much for your tutorials! I would like to ask, is possible show in calendar item which is not only text but lookup or person? I tried, but it does not work. Thank you. Best regards, tom

[@ShanesCows]

ThisItem.LookUp.FieldFromLookup I think is the pattern you are looking for.

[@tomaspisecny6038]

@@ShanesCows Hello Shane, thank you for your help. I used Text(DataCardValuePerson.Selected.DisplayName) and it works as well. :) Please, can I ask you for one more help? When you showed DateAdd(varVideoFirstDayView, ThisItem.Value, Days) = reservations are visible. When I use Text(DateAdd(varVideoFirstDayView, ThisItem.Value, Days), "dd") = reservations are unvisible. How can see short version of dates and reservations as well? Thank you. Best regards, tom

[@NikiNuts1]

@@tomaspisecny6038 Did you find a solution to this?

[@louisemcquillen9857]

Thanks Shane, love your videos. I built the calendar, wow surprised myself.... But dates keep converting to DateTime format instead of staying in Date format... all I did is change some variable names... very frustrating. How do I get it back to display Date format?

[@ShanesCows]

Use the Text function and you can control how the date is displayed.

[@latrobe15]

Awesome as always. Thanks Shane

[@ShanesCows]

My pleasure!

[@keithdavies9150]

I have just two words - Freakin' Awesome!

[@ShanesCows]

Thanks. Wait till you see part 2. I am close to recording it and it is melting my mind. 🐶

[@aliciachoy7921]

Hi Shane, a great calendar app that you have created. How to go back to "Today"? there is the previous month and the next month. Please advise thanks.

[@ShanesCows]

I haven’t done that. Sounds like a a fun video. I think most of the logic would be the OnStart logic for getting the variable and collection back to base.

[@igobyness]

Hi Shane! I’m getting stuck at the 13:46 mark, trying to add the DateAdd(varVideoMonth; - Weekday(varVideoMonth, Days) fx

[@ShanesCows]

You need 2 ) at the end of the formula 😀

[@zerokhan858]

thanks shane! this one was particulary intersting hahaha

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@juandavila4035]

Thanks Shane, great video.

[@ShanesCows]

My pleasure!

[@anittaalex8487]

Hi Shane. You are amazing. Can you help me on why Varvideomonth = Blank . I am not able to assign value to variable. I am kind of new to powerapps

[@andreasalazarmolina2892]

Hello, did you manage to solve this error?

[@朱珈樂]

I have the same question , too

[@glennbullion9069]

Trying to watch parts 1 and 2 to fully wrap my head around things. Quick question. How did you go about color coding different events?

[@ShanesCows]

Conditional formatting. Set the label full color if the condition is what you want.

[@cristinay4685]

HI Shane, thank you so much for this video. I was wondering if this is possible using Shared calendars?

[@ShanesCows]

Yes, but you have to use the Graph API to do it. :( One of my students built herself the solution but it was a lot of work for her.

[@cristinay4685]

I wish they would make it easier to achieve! @@ShanesCows

[@nitzan300]

Thanks a lot like always, such a great video!!

[@ShanesCows]

Thanks 🙏

[@danielroldan9288]

Join the team! great video!

[@scotsunnergren9127]

Thanks for this Shane... small question... in the designer, you click the button and it performs the action. Mine does not. how can I get it to do that in design mode without taking the app to preview?

[@scotsunnergren9127]

Nevermind... found my ALT key... :)

[@ShanesCows]

Glad you got it Scot

[@shelleylau7603]

Hi Shane! I changed the text of the calendar label to "Text(DateAdd(varFirstDayView, ThisItem.Value, Days), "d")" so instead of displaying the full date, it only shows the day number, but this has a knock-on effect on the 'Fill' formula, which lifts today's date as a point of comparison. I've tried "If(Text(DateValue(Label11.Text)) = Text(Today(),"d"), Purple, White)" but this doesn't work. Is there anyway around this or will the fill function only work when the full date is on display? I'm rather new to PowerApps, so something might easily be going over my head! Thank you!

[@shelleylau7603]

I also tried "If(DateValue(Label11.Text) = Day(Today()), Purple, White)" which didn't do anything either...:(

[@jimwaldron3858]

Great Video Shane - when will the link for the next part be available

[@ShanesCows]

Monday the 29th at 8:30 AM it hits KZbin. Will be in the curated library at training.powerapps911.com tonight.

[@BurningSock]

Question for part 2, Shane - do you know of a way to add recurring calendar items within PowerApps (with a SharePoint calendar list as the datasource) without using say a daily Power Automate flow

[@ShanesCows]

I haven't tried. I will look at it when I dig in more.

[@NKBobcat]

Nice job Shane!

[@ShanesCows]

Thanks Bob!

[@enapier100]

This is fantastic! Great instruction as usual

[@dquez9]

Great Video! or vidoe if you will. on to part 2. I do have some problems with the (Today()) function adding the time when I don't want it to. But, strangely goes away when I same and close powerapps. Shane, is there a way to lock in the format of today() with no time shown with the steps you've provided? Thank you, -Dan V.

[@seadude]

Excellent tut! Thank you Shane!

[@DavidWallach-n9b]

How would you go about just displaying just the day number, like most calendars, instead of the full date for the day?

[@ShanesCows]

THere is a Day function that you could wrap around the full date to just return the Day portion.

[@Holru]

First off, a huge thank you Shane, your videos have been a godsend. Cannot even count how many times I have turned to your videos. Secondly, an European here, so your examples on date functions were much appreciated! However, when you switched to EU format on around 28:30, your red fill on Label 1 (on your galMonthView) disappeared (was on 03/21/2021). I guess it does not recognize the changed date formatting (from US to EU). Any ideas how to implement this Fill setting on top of the EU date formatting? Keep up the good work!

[@frankeddy2726]

I'm getting the same issue, any ideas anyone???? Shane please enlighten if you have the time thanks. Great work

[@ShanesCows]

What if you use the Text formula to convert both of them to the same format in your If for the fill color? That should do the trick. :)

[@matlionis6110]

Hi Niklas, did you manage to do this? I can not wrap my head around it. This is what I got in the Fill If(Text(DateValue(Self.Text),"dd/mm/yyyy") = Today(), Red, White) but it does nothing...

[@mccaslinhughes5211]

figured it out, set Text to "Text(DateAdd(varFirstDay, ThisItem.Value,Days),"dd/mm/yyyy")" set Fill to "If((Self.Text)=Text(Today(),"dd/mm/yyyy"),LightBlue,White)"

[@brat3141]

Modify the rest of the function in FILL for dates that are not part of the selected month (European date)? Solution: If((Self.Text) = Text(Today(),"dd/mm/yyyy"),RGBA(0, 18, 107, 0.7), Month(DateValue((Self.Text),"hr-HR")) = Month(DateValue(varVideoMonth)), RGBA(187, 221, 140, 1),RGBA(187, 221, 140, 0.5))

[@terriefuller4556]

Shane this is amazing! I used your code for shading out the month before, and the month after EXACTLY. My calendar is shading the month before, but not the month after. Any thoughts?

[@matthewhorstman740]

Hi Terrie, not sure if this is the best/easiest way but it worked for me. For reference, varClientMonth is the variable that displays the month in the large header. I was also just using a defined color vs. a variable like Shane did. If(DateValue(Self.Text)=Today(), White, Month(DateValue(Self.Text))= Month(varClientMonth), Blue, If (Month(DateValue(Self.Text)) > Month(varClientMonth + 1),ColorFade(Blue, 40%), If (Month(DateValue(Self.Text)) = Month(varClientMonth - 2),ColorFade(Blue, 40%),Blue)))

[@AaronHowell87]

Using your calendar, I added a dropdown for everyday so users could change who is 'on-call', but I'd like to have default set... how would I add the users name for a seven day stretch, every other week? Sun-Sat calendar, but the 7 days starts on a Tuesday and ends on a Monday..

[@julireid9574]

Is there anyway in Power Apps that you can detect the keyboard language and then use that to determine if the date is mm/dd/yyyy or dd/mm/yyyy?

[@ShanesCows]

There is a Language function that returns the users language. 😎

[@izaakfrost16]

Hi Shane, thanks so much for your videos, they’re great! I’ve built this app and it works perfectly on the web, but when I go onto my iPad to use the same app, PowerApps confuses itself. The standard date format on the web is mm/dd/yyyy, however when I use the iOS app, the standard format is dd/mm/yyyy, rendering the app useless on my device… any suggestions as I’m pretty stuck for a solution! Keep up the fantastic work!

[@ShanesCows]

Yikes. I have never seen that one. 🤔

[@izaakfrost16]

@@ShanesCows Hi Shane, my bad - I forgot to remove this comment! The browser I was on was set to English (US), when I switched it back to English (UK) it worked perfectly!

[@bradpayton4368]

Shane. I am new to Power Apps and have been trying your video on building the calendar. I am @ 14:09 and have enter the Set(varVideoFirstDayView portion, but it alway = Blank. I have no idea what I am doing wrong. Any suggestions on what I can try. Thank you for any help.

[@milidottori4057]

Hi Shane, I need some help to get a room calendar. The room calendar is already set on public mode so everybody has access to check this but when I want to add it to a powerapps gallery and have a full calendar from that room, I can only see the reservations I've made. How can I see the reservations my mates made? Thank you!! greatings from Spain

[@Marcelo_Trabalho]

Hi there, my power apps can´t find the formula "Months" or "Days" for some reason. Do you know why?

[@dougsmith6283]

I was pulling my hair out coz my dates were not aligning with yours, me thinking Ive missed a part of the math. Then I realised its 2022 not 2021!! 😆

[@ShanesCows]

Whoops 😂

[@jeremyk6456]

Question: Sharepoint List customized with a PowerApp, using a SP Calendar View, how can I make the Default Date for that SP record be the same as the Date that they clicked on from that Calendar View? (When they click the little 'new' link on the date to add a New Item, I want that Date to be the Default Date for that item)

[@manojhari7077]

Hi Shane, i have created the calendar and on each date i have added dropdown so when i select dropdown on the two different dates it not patching dates to list instead it is saving same date ,do you how i can get the date value for each dropdown?

[@ashokpershad]

Great Shane...

[@ShanesCows]

Thanks. I was pretty excited for this one.

[@sundrapillay6668]

Thanks Shane excellent

[@ShanesCows]

Thank you, thank you 🐶

[@GoWstingray]

Thar variable corrupting thing has been annoying me recently also, it keeps saying it’s a record value when it was just supposed to be a number. Glad it’s not just me haha cheers

[@ShanesCows]

Was driving me nuts. There is also another scenario it throws an error even though the sequence works. UGH

[@GoWstingray]

@@ShanesCows When your sat there at 1am trying to meet a deadline and that happens you start second guessing and it’s not good. I’ve now learned to just close and reopen lol same when data just won’t refresh grr

[@danielgil9651]

Hi Shane, sorry I have a question, can I use an app that is conected to a sharepoint list if I'm not included in the sharepoint site where the list belongs? I'm having trouble with that, thanks

[@ShanesCows]

Nope, you have to have access to the underlying SharePoint data sources.

[@avinoamrothenberg1244]

Great video and very useful. BTW 7 divided by 7 (33:23) is still 1 not 0 !! 🧐

[@ShanesCows]

Mod function returns the remainder so 7 divided by 7 is 1 but has a remainder of 0 😊

[@vijayp1380]

Thanks Shane. Is it possible Html body for the event?

[@ShanesCows]

Probably but I haven’t tried so not sure.

[@paulpage-p7j]

Hi Shane, what would you do if the 1st does land on a Monday?

[@sadafsiraj2]

Thanks for you video its helpful for us, please create a sales order application in power app using business central.

[@ShanesCows]

Will try

[@sadafsiraj2]

@@ShanesCows Thank you so much

[@NaderIdkeidek]

didn't you say that we can find the template or whatever in your link ?!!

[@ShanesCows]

You can download the pieces by subscribing here kzbin.info/www/bejne/bYbIg62chdRriKc

[@julireid9574]

Are you planning or have you considered figuring out how you could print that calendar to PDF to look just like it looks in the app, highlighted dates and all?

[@glennbullion9069]

This would be awesome.

[@dylanhaugen7875]

Shane, when I am adjusting the height of Gallery 1 (Gallery 4 in your case) and the Title, it is giving me a circular reference error. Do you have any guidance for this?

[@akhilnadhpc]

How to show the spinner on calender loads? What is the link to get this component?

[@ShanesCows]

I talk about Spinners here kzbin.info/www/bejne/i4jcZnyVgtp8nbc

[@nico4im466]

Hey Shane, great Video I loved it! But something is not working on My Calendar, Today is the 2nd February and my Calendar is still showing me the days from January, do u know how I can fix that ? Thank you so much and greetings from germany!

[@s6boi666]

I had this issue. I’m working on the maths part now, can’t understand why my DateAdd(VarVideoMonth, - Weekday(VarVideoMonth), Days) is returning 31/12/2022 Confused. Did you fix this?

[@s6boi666]

Figured it out it need to be in UK date format and not how the US example: Set(VarVideoMonth, DateValue(“1”&”/“&Month(today()) & “/“ & Year(today()))

[@guddu678910]

Hi Shane , Can you help me make one power app to maintain a shift schedule..Columns should have day and Date (example 30th Apr and Friday) and have employee Names in rows. And I want to plot Shift1/Shift2 against each. I want it to be displayed in power app screen and data saved in sharepoint list. ALso a screen for employees to request leave and approval from manager before it gets updated. Please Help !

[@ShanesCows]

You can reach out at www.PowerApps911.com we have options to help you build your app there.

[@guddu678910]

@@ShanesCows thanks Shane

[@julireid9574]

I just watched the Calendar and Clock Function video for MultiLanguage. Have you thought about how you could redo this to reflect the browser date format? Set(varMonth, DateValue(Month(Today()) & "/" & "1" & "/" & Year(Today())))? I set a browser to Spanish and with a label on the screen set to Text(varMonth, "mmmm") it shows January rather than September. I have some ideas but they all require a lot of lines.

[@julireid9574]

BTW I figured this out and it's beautiful. Just use actual date function values rather than text for places where you want it to automatically translate.

[@PitakYT]

Thank you very much.

[@ShanesCows]

You are welcome!

[@davidcarr7793]

This has a problem with months that have 5 weeks and the start of the is week is a Friday or Saturday

[@javiersobrini6035]

Amazing!!

[@franklinparker9502]

How are you accounting for Leap Years?

[@franklinparker9502]

Also thanks again for putting together this video. I saw some useful components out there from others but I really like this one you've built. I'm guessing that the leap year is accounted for once the year comes, because the math is completed by using the today function, but it just seems like it wouldn't correct itself until that day actually comes.

[@ShanesCows]

I am just not sure. I didn’t test for that but in my head it will work. 🤷‍♂️

[@franklinparker9502]

@@ShanesCows It indeed does work. Once I finished the app, I ran it all the way to 2032 and the dates were consistent. Thank you so much!

[@leetyler3102]

what about if a February starts on a Sunday? you'd only need 28 not 35.

[@ShanesCows]

Interesting no didn’t think about that. I guess so. 🤔 You could fix it by updating the sequence logic.

[@tilman1]

Sequence( If(DateDiff(varVideoFirstDayView, DateAdd(varVideoMonth, 1, Months), Days)>36,42, If(DateDiff(varVideoFirstDayView, DateAdd(varVideoMonth, 1, Months), Days)>29,35,28 )))

[@ShanesCows]

Thanks Tilman!

[@jimwaldron3858]

@@tilman1 I am getting error on that code

[@tilman1]

@@jimwaldron3858 Strange. Sure you have kept the variable names? The above code is just extended by one if clause of the same structure.

[@guzerocode]

when I try to use the argument "Days", power apps show me "days isn't recognized". Could anyone help me?

[@blessingroberts7658]

Have you tried TimeUnit.Days? That's what I did and it worked perfectly

[@mohanram.j]

Try "TimeUnit.Days"

[@ramlia72]

Thank You!

[@sunnyng8708]

Nice!

[@daFrimpster]

YIPPEE!!!!!

[@ShanesCows]

HOORAY!!!!!!!!!!!!

[@solarpunk_]

Shane, Here's your trick to getting short days of the week without having to type them out in an array: Gallery - Items: Calendar.WeekdaysLong() Gallery - Template - Label: Left(ThisItem.Value,3)

[@solarpunk_]

or just use Calendar.WeekdaysShort() 🤐

[@ShanesCows]

Thanks for sharing Tim. I like the short version below. 🤩