PowerApps Calendar Control - Build your own using Galleries 

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

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

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!

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

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

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

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.

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

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

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.

thanks shane! this one was particulary intersting hahaha

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

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.

great one! Looking forward to part two

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

Another great video Shane, thank you.

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

Awesome shane , looking forward part two

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

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

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

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

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.

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

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

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.

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

Knowledge BOMBS, thanks Shane!!

I have just two words - Freakin' Awesome!

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

Awesome Tutorial Shane. Appreciate it!

Thanks Shane, great video.

Nice job Shane!

Join the team! great video!

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.

Excellent tut! Thank you Shane!

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

This is fantastic! Great instruction as usual

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

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

Great Shane...

Thanks Shane excellent

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

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

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

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

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

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

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

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

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.

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!! 😆

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?

Thank you very much.

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

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?

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

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!

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

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!

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

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?

Amazing!!

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

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

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?

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.

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?

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

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

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)

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

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?

Thank You!

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

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.

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

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?

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!

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

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

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..

Nice!

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?

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

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.

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 !

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!

Hello, Looks awesome Could you helpme out please I like to make this on a phone app instead tablet Because 7 days on 1 line is to big Is this possible? so yes, could you show me Thanks ;)

How are you accounting for Leap Years?

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

YIPPEE!!!!!

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)

Awesome as always. Thanks Shane