Build CALENDAR Control in POWER APPS in Minutes | Connect to SharePoint List

[@dougydoe]

Great video again. I have seen the Calendar and other screen templates but I've never had the need to use them in Apps..... well, until now. Lol. One thing your videos do to me is to open up my imagination and appreciate what is possible. Thank you for always pushing me to strive for more.

[@RezaDorrani]

Glad it was helpful! Thank You so much for watching.

[@ytubid]

Thanks for sharing this awesome video, Reza! Happy to send u a small gift! :)

[@RezaDorrani]

Thank You so much Krishna Kumar.

[@adammykris7029]

Thank you so much for posting this video! This is exactly what I needed to add into my application, and I just had to give all the recognition you deserve for taking the time to educate everyone on this concept. Thanks again!💯👍👍👍

[@RezaDorrani]

You're so welcome!

[@mattfreeman8482]

I can not thank you enough for all the time, experience, knowledge and detail you put in to this video. This is definetly one of my most favorite videos on PowerApps. Keep up the amazing work Reza! 😍😍😍

[@RezaDorrani]

You're most welcome!

[@hs4279]

One of the best instructors on KZbin. simple, direct & informative. Thanks, man, for your time and efforts.

[@RezaDorrani]

Thank You for the appreciation

[@MichaelDeBlasis1369]

You make the best videos Reza! They are all so clear and well laid out. And so consistent on the lessons and layout. Well done Sir.

[@RezaDorrani]

Many thanks! A lot goes into making these videos and it feels amazing to receive such appreciation

[@christianhuidobro7452]

@@RezaDorrani hola, podrias subir el video para poder crear la lista?

[@sandyspringer55]

I am only half way through the video but THANK YOU!! I always find the exact solution I am looking for on your page and it’s always the simplest and well explained option out there.

[@RezaDorrani]

Thanks Sandy 😊

[@sandyspringer55]

@@RezaDorrani although I added a reset filter for the reset fields and now it’s broken 😞 accessibly issues with labels. And now no information shows from my list even with all filters removed. Any ideas?

[@RezaDorrani]

@@sandyspringer55 Video description has link to download sample app. You can check the logic I used in it.

[@MrAllybell]

Another great video Reza, you've an answer for everything. Much appreaciated!

[@RezaDorrani]

Thanks so much

[@jamiemcgrath3305]

I'm sure you must have seen my Reddit post the other day looking for this! Amazing thank you

[@RezaDorrani]

Sorry, I did not but I'm happy to know that this is what you were looking for.

[@jamiemcgrath3305]

@@RezaDorrani one thing I was trying to do also was to have a comparison with a SharePoint list data against a users calendar. I am making a training booking app currently and wanted them to be able to easily see at a glance if they were free during that time, potentially piling together an agenda for their day with the training time overlaid. Is this possible? Really struggling to get my head around the calendar connector functionality

[@RezaDorrani]

@@jamiemcgrath3305 Possible but I would have to try it out to learn more about it. I will recommend posting your issues/queries on the forums at powerusers.microsoft.com/

[@adrianoberholzer1873]

I could not praise this video more! Thank you

[@RezaDorrani]

Wow, thank you!

[@necdetsaritas8722]

This weekend was wonderful through your great video. Thanks Reza

[@RezaDorrani]

Glad you enjoyed it

[@kearley8792]

This is a great video. Easy to follow and well-explained. Thank you very much!

[@RezaDorrani]

You're very welcome!

[@chrisproctor2854]

Another awesome video where I learned some things that I can't wait to implement!

[@RezaDorrani]

Glad it was helpful!

[@SHAli1474]

Hi Reza Haven't finished the video yet but got to give you a thumbs up :). Great Idea Thanks for educating us.

[@RezaDorrani]

Hope you enjoyed it!

[@SHAli1474]

@@RezaDorrani Watching it again to build an app for Holiday Tracking. Can't appreciate enough for these amazing videos. But Thanks a lot.👍👍👍

[@Samshujayanagar]

Thank you for this video Reza. You are amazing and keep up the great work 👍🏼

[@RezaDorrani]

Thank you 🙌

[@simonball5602]

Another great video Reza. Genius- thank you.

[@RezaDorrani]

Glad you enjoyed it

[@UncleF115]

came from shane young's DIY calendar video, these 5 sec technique saved me!

[@RezaDorrani]

Thanks for watching

[@rubininarasimhan8681]

Thank you so much.. Your videos were helpful...

[@RezaDorrani]

Most welcome

[@Richkotite1]

This is a great video. Easy to follow and well-explained. Thank you very much

[@RezaDorrani]

Glad to hear that! Thanks for watching.

[@oluwatobiyusuf]

Awesome trick around calendar control. Thank you Reza for another amazing content. New knowledge learnt

[@RezaDorrani]

Happy to hear that!

[@maryampour8914]

Thank you so much Reza! it's simply just brilliant 🙂

[@RezaDorrani]

You’re most welcome

[@JPPVCC]

Reza: Many thanks for this. Not just for me but for my client. This is going to make a significant difference in their productivity and analysis. I'd like to help others as well. My client's needs were a bit different and I wanted to have just a single button on the Interview calendar that counted the number of events for that day. At a glance they can now see how many field service calls are loaded by day. I achieved this by adding the vertical gallery, but adding just one button and setting the Text to: "Total PMs: " & Text( CountRows( Filter( 'SP List', Your Date Column= (DateValue( (DateAdd( _firstDayInView, ThisItem.Value, TimeUnit.Days )) )) ) ) ) If there is a better way I'm always interested! Thanks again, JP

[@RezaDorrani]

Thanks for sharing

[@adrianoberholzer1873]

Brilliant video!! Thank you so much!

[@RezaDorrani]

Most welcome

[@russthedutch]

Amazing as always, learning so much because of your channel!!

[@RezaDorrani]

Great to hear! Thanks Russ.

[@RiRi69RiRi]

This is super useful!

[@RezaDorrani]

Glad it was helpful!

[@nicolettevandenheever4230]

Thanks for you video's I learn a lot from it.

[@RezaDorrani]

Glad to hear it!

[@dsars79]

@Reza thanks for sharing. It is almost catering all my needs. Thanks once again.

[@RezaDorrani]

Most welcome

[@navarrocloud]

Very nice explanation. Thank you for sharing.

[@RezaDorrani]

Thanks for watching

[@kingthranduil8807]

Amazing! Exactly what I needed! thanks for the video!

[@RezaDorrani]

You're most welcome!

[@DNCubeVlogs]

Thanks Reza, Thanks a lot. Every time you will change the developer design aspects. Love you again. Once again thanks for your great efforts and insights for us.

[@RezaDorrani]

You are most welcome. Thank You for your kind words.

[@SadekInfos7392]

Thanks a lot for your efforts, life seems so easy with your videos and your neat way🙏🙏🙏🙏

[@RezaDorrani]

Thanks a lot

[@raj7sam]

this new template will be very very helpful. thanks for video

[@RezaDorrani]

Glad to hear that

[@coffeecuppepsi]

thank you for this, exactly what i needed

[@RezaDorrani]

You're most welcome!

[@CloudhoundCoUk]

Another magnificent packed presentation. I particularly like the link to real-world use. Thank you.

[@RezaDorrani]

You're most welcome!

[@markbrown8315]

Hi Reza, thanks for a great video. I was just wondering if there is a way to change this calendar to a Week view.

[@RezaDorrani]

Welcome! There is no out of the box option to do that. You would need to update entire app to show the week view. Possible but not something I have tried.

[@mayankranjan8154]

Amazing Videos! At 18:41 u have shown how we are filtering the record from drop down. How you have populated user dropdown with all the created by name and ALL??

[@RezaDorrani]

Check video description. I believe I shared the App. You can check the code there + I have done many videos on gallery filtering (that include All logic). You can check those.

[@MegaKumar0]

Another great video Reza.. thanks 🙏.

[@RezaDorrani]

My pleasure!

[@jasmingutierrez9280]

Great! Another masterpiece, Sir. Thanks for this. ☺️

[@RezaDorrani]

You are most welcome!

[@EpicBizHero]

Thanks so much Reza! You are Truly Appreciated!!!

[@RezaDorrani]

Thanks so much

[@tariksalihovic]

Thx a lot 🙌 tried to figure out how to copy parts of the component and logic, but now i know 🎉

[@RezaDorrani]

Most welcome

[@RezaDorrani]

Most welcome

[@MrPirani]

Beautifully done!

[@RezaDorrani]

Thank You

[@Test-oc1fr]

Amazing work ❤

[@RezaDorrani]

Thank you! Cheers!

[@jasonmoreton461]

Brilliant video- very helpful and as usual easy to follow. I am intrigued by the modal pop up you showed in the video do you have a video on how to go about that at all please?

[@RezaDorrani]

Thanks! kzbin.info/www/bejne/boWcgZRrba1kedEsi=NJmLxgvUpb4DBZE7

[@siscovasallo]

Hi Reza. I'm new to Power apps and love your videos. I used this to create a Calendar app for my team at work. Could you please create a follow up video showing how to create recurring items in this app? (e.g., enter an item once and have it repeat every day, week or month)?

[@RezaDorrani]

I have no plans for a follow up video. I make videos when I receive multiple requests on a topic. I have ideas in my backlog with over 30+ requests

[@siscovasallo]

@@RezaDorrani thanks anyways. Your videos are great! Thank you for sharing all this knowledge and tips. I was able to build a great app in days with little coding experience just by watching your videos!

[@home-tecserwiskomputerowyw5379]

Thanks, another wonderful recording! And can you tell us how to make one event that lasts several days and that overlaps another event display in one line?

[@RezaDorrani]

Thanks! For event lasting several days on a line - this is something I would have to try it out to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@cristinay4685]

Hi Reza, thank you so much for this video. Could you make a video showing how to prevent the selection of certain dates? For example, I want to create an appointments app, but only Tuesdays and Thursdays are open. Thank you!

[@RezaDorrani]

I make videos when I receive multiple requests on a topic. No plans to make a video on this. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@poshady2]

Great video as usual 👍

[@RezaDorrani]

Thank You

[@andythemouse]

hi reza, thanks for sharing this, i created the calendar in my app following your video. there is now a request for a weekly calendar, wondering if you have a video for that?

[@RezaDorrani]

I do not have a video on that. Check on forums in case someone has done something similar powerusers.microsoft.com

[@Jenny-zr6xe]

Amazing video! A common scenario is that calendar events fall across a range of dates. At 16:40 you show how to make the dot visible based on the 'Due date'. How can we make the dots visible across a range of dates inclusive of 'Start date' to 'Due date', instead of just the 'Due date'? Thank you :)

[@RezaDorrani]

You would filter on date range. I have done videos on gallery filters. I’ll recommend to check those videos.

[@faizzatulshafika3152]

Hi Sir, I'm having the same problem which i can't make the dots visble on the date range. I have seen the powerapps community platform but also fail. Mind to share the code for it if you got it? I've been stuck there for a week now.

[@fundacionsancebrian]

Great video with a perfect explanation. I have a question, how would I change the code if the week starts on a Monday? Thanks

[@RezaDorrani]

Most welcome! The code is based on a template and there is logic where it probably reads day of the week to start from. I do not have a video reference on changing start day of the week scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@lathanishikanthreddy8278]

Thanks a ton Reza!!!

[@RezaDorrani]

You are most welcome

[@Chgrtours]

Thank you Reza!

[@RezaDorrani]

👍

[@Mr007Rajan]

Matching my use case thanks a lot

[@RezaDorrani]

Most welcome

[@silasmangeni5976]

Fantastic video on the calendar control, can you do one where you incorporate date and time?

[@RezaDorrani]

I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZbin channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

[@esterraful]

thank you for this tutorial! it already helped me a lot. I have only one question. How did you create a gallery inside of Month Gallery?i stuck at this point

[@RezaDorrani]

Video description has link to download sample app. You can check code in there.

[@esterraful]

@@RezaDorrani thank you :) i found it. once again great tutorial

[@tomekliebert9282]

Hi Reza, Thanks for the videos, your work and a lot of inspiration you give :) I have a problem with the "Travel request" calendar. The type of my cells in the Sharepoint table "Travel start date" and "Travel end date" are date and time. In a situation where I select the date 01/06/2022 without the time, it's ok (I can see the date in the calendar), but when I select the date with the time, e.g. 06.01.2022 11:10 (start) it doesn't show up on my calendar. Thank you very much in advance for your answer :)

[@RezaDorrani]

It’s probably bcoz without a time element it take it as 12 am. I do not have any video references on this scenario or dates and times in power apps. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@hazeyn]

@@RezaDorrani Can you share or can anyone do to solve the hour and minute problem?

[@RezaDorrani]

@@hazeyn I recommend posting your ask on the forums.

[@artistlee5553]

Thank you very much for the video. As a beginner, this vedeo is perfect for me! One question is, how can i expand my calendar vertically? It seems to extend parallel as your video..

[@RezaDorrani]

Welcome! Not sure what extend parallel means. The calendar is a gallery and a gallery has scrollbar.

[@artistlee5553]

@@RezaDorrani 13:13 on your video, you could expand left and right of the copied calendar. But I would like to resize by expanding up and down..

[@RezaDorrani]

@@artistlee5553 You can try that also but you would also need to adjust the template size of gallery. I have done detailed videos on gallery control so I will recommend checking that out.

[@zerocool200380]

Great video Reza

[@RezaDorrani]

Thanks

[@brucemarriott3841]

Awesome thank you just what I needed, I have struck a couple of issues where my Patient List exceeded 5000, so split into 3. How can I accommodate this scenario, the other thing is that I have Clinics on certain days (but not all) and want to add a placeholder to these days, and then add a selected Patient to that Clinic slot. I am a novice and appreciate your efforts, thank you showing the way.😀

[@RezaDorrani]

Most welcome! I do not have any video references for your patient scenario. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@brucemarriott3841]

Thanks for that I will try the Forum@@RezaDorrani

[@brucemarriott3841]

Thanks again I decided to build from scratch, I have followed your demo but not getting very far, the Dots on calendar day do not show, the Visible property formula seems ok. I connected to Data source, select the date column, and return the Title field. Is there anything simple I may have missed ? Appreciated.

[@RezaDorrani]

@@brucemarriott3841 I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@alikarnib9776]

Awesome work. Might u perhaps know how to change the first day of the week?

[@RezaDorrani]

That would require updates to the code base related to the template. There would be multiple changes needed. I would have to try it out to provide the steps. Always check the forums first to see if someone has done something similar. I just did and seems someone may have done it - powerusers.microsoft.com/t5/Building-Power-Apps/Change-calendar-page-starting-day-to-monday/m-p/501377#M152449

[@AmyCustomer]

@Reza Dorrani I'm attempting to put the calendar only (the 5 components of it) into a container that is vertical. Of course it stacked everything. I put a horizontal container around the title and two arrows and that worked fine, the weekday names are fine, but in the calendar body I don't know how to vertically align the 3 components of the month view (title, subcircle, circle). I think I need a small vertical container but am unable to make that work No matter what I do, the little dot indicating an appointment is BESIDE the title and subcircle not under it. Can you do a quick video on how to do this within a responsive page that has both horizontal and vertical containers? It's the only thing that's not working right. Your video is awesome and I just need this help to make it look good. Thanks very much.

[@RezaDorrani]

Hi Amy, thanks for liking the video. I would have to try it out and make a video on it. I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted ideas get added to my backlog. I will recommend posting this idea in next topic suggestion post.

[@AmyCustomer]

@@RezaDorrani Thank you Reza, I will check out the monthly suggestions. But theoretically, wouldn't it work perfectly if PowerApps had a z-container? one that would allow you to stack elements on the z-axis? I think that would be the easiest way to solve this problem. Are you aware of anything that manipulates the z-index like containers that go horizontal or vertical?

[@RezaDorrani]

@@AmyCustomer Im not aware of that

[@adamshrinah2595]

Great video, thanks

[@RezaDorrani]

Thanks for watching

[@wendythiessen3718]

Great Video! I have been learning so much from you, thank you for all the videos you make they are great! I am having one problem, once I have followed your instructions when I click on the button created on the calendar using the nested gallery, it goes to my form screen but it tells me "No item to display" do you have any idea why this might be?

[@RezaDorrani]

Typical it relates to a misconfiguration with gallery and form. Video description has link to download app. You can check the logic in it. Alternatively, I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@marieraymond6512]

Your video is AWESOME as usual. Is there a way to create recurring events?

[@RezaDorrani]

Most welcome! I am not aware of any option for creating recurring events via power apps.

[@rafi9143]

Perfect video, you also do mentoring or advice/support, I am doing a project with MS Dataverse as a data source. Kind regards.

[@RezaDorrani]

Most welcome! I do not offer 1:1 support.

[@TehilaD-c8e]

thanks for this video, do you have more in depth explanation /video of how you created these 18:55 - Build Color Coded Calendar from SharePoint List 21:57 - Connect Calendar with Form Control like how you did the form control , and drop downs in the color coded calendar.. etc..

[@RezaDorrani]

This video is the best reference I have. Video description may have link to download sample app.

[@spen2431]

Amazing 👍💥

[@RezaDorrani]

Thank you! Cheers!

[@mercedescusi7653]

Excellent video!! Any ideas on how I could schedule or program (from the form) certain tasks that are repeated ? for example, register just one time a task wich is repeated every day from monday 8 to monday 15 from 9 to 12hr and the callendar shows this task in each day automatically. thanks!!

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@bryanmoore4574]

Hi Reza, at 18:01 in your video you will notice the orange vacation records down at the bottom that apply to the next months calendar but look like they fall under the current calendars dates of the 28th through the 2nd. How do you get those records not to show up under the current calendar?

[@RezaDorrani]

I would have to try it out to know how to remove it. I did this video long time ago and do not remember the specifics. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/

[@bryanmoore4574]

@@RezaDorrani here is the code if you want to fix it: Filter( Reservations, DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days) >= 'Reservation start date' && DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days) = _firstDayOfMonth && DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days)

[@rahullal2058]

Great Video ,Thanks Reza. I have connected my work progress tracker everything looks fine , Would it be possible to change the fill of circle 1 to Red if the item is overdue ?.

[@RezaDorrani]

Possible using formulas. I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@rahullal2058]

@@RezaDorrani Am trying with following formula in fill property of circle 1 , " If(LookUp('System Admin Controls','Actual date completion'=DateAdd(_firstDayInView,ThisItem.Value,Days)).'Due date'=LookUp('System Admin Controls','Actual date completion'=DateAdd(_firstDayInView,ThisItem.Value,Days)).'Actual date completion',Red,Green) " Due to some error on the formula it is not working as expected .

[@RezaDorrani]

@@rahullal2058 Not possible for error checking here on chat. I would recommend posting your issue on forums powerusers.microsoft.com/

[@adrianrodriguez2107]

How could I set the calendar not in english format but in European format, so as to say, that the starting day of the week to be monday and the latest Sunday? Great video btw, very helpfull ^^

[@RezaDorrani]

Thanks! I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@rubenpuertosmartinez]

Do you have a video for how to setup the filters based on the users? at 18:35 you are explaining ho to setu the filters in the nested galleries, but I can't see how did you set up the drop down options for the users that have sent a travel request.

[@rubenpuertosmartinez]

Great video by the way

[@RezaDorrani]

I have shown that in other videos (I have done 200+ videos hence do not remember which one). Check my playlist on Power Apps. I have done several videos on gallery filtering.

[@johnbrennan8442]

Hello Reza 16:40 if you are using this formula with dataverse would you replace the Title with the unique identifier primary column ?

[@RezaDorrani]

That would be the idea

[@johnbrennan8442]

That was quick ! Thank you

[@iulianburlacu]

Awesome content Reza. This solved a lot of issues for me. Is it possible tho. to select multiple dates with this component?

[@RezaDorrani]

Possible but would require a lot of changes to component. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@stephencuff]

Magic work as usual Reza. In my instance I created similar to your Recruitment buttons - I have selected current month March. At the bottom of the calendar I can see some of the April events without any matching calendar boxes. I am struggling to debug this - if something leaps to mind as to why this is happing, I'd love the guidance. :)

[@RezaDorrani]

Calendar may show a few days of previous and next month depending upon number of days in current month. Is that your issue or is it showcasing april events in march month?

[@stephencuff]

@@RezaDorrani Hi Rezi, the calendar is showing April events in boxes that are not inside the 0-41 gallery boxes. They appear as if there were gallery boxes 43, 44 and 45. These 'overflow' events are correctly shown in the April view. Any helps to debug would be fantasic.

[@RezaDorrani]

@@stephencuff I am not sure about what the steps to fix would be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@stephencuff]

@@RezaDorrani Thanks Reza! Cheers.

[@scarmentube]

Great video! Thank you so much for your time and effort to share your knowledge, is very appreciated. I do have one question I haven't found an answer for yet.....hopefully you will be able to help. Do you know when you have the List and then you create the Calendar view from the list and when you click on a particular day of that calendar view, the default form for a new event will open and the Start Date is set for the date you clicked on the calendar. However, when I customize the form in power apps, I cannot find a way to map this behavior. I would like the power app form to also get the date the user has selected on the calendar when clicking +New........Do you know any way to do this? Thanks in advance!

[@RezaDorrani]

I have not tried this scenario. I believe Power Apps would probably not get information for the date the user clicked + new event on. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@scarmentube]

@@RezaDorrani , thank you so much for your answer, I'll have a look. And once again, thanks for sharing with us.

[@johandeweerdt]

Hi, great video as always. I wanted to check something. Have you ever tried to add multi-day events? Where looking for a good way to visualize these on a weekly basis... So a combination of multi-day vs one day events...

[@RezaDorrani]

I had tried that a while ago on a project. Complicated to handle in power apps.

[@fanzfanzilla]

Hello RD, thank you for another valuable tutorial video. I downloaded the calendar app. I wanted to test it in my environment using your asset and travel SharePoint lists. It will be very helpful, if you could share both lists if possible with the sample data. Thanks again.

[@RezaDorrani]

They are based on the standard list templates asset and travel. Just create a list using those templates.

[@fanzfanzilla]

Thanks RD. I appreciate it.

[@fanzfanzilla]

A quick question is there a way to use MS Teams Shared Calendar in PowerApps?

[@RezaDorrani]

@@fanzfanzilla Not sure. Check on forums at powerusers.microsoft.com/

[@lynnarevard2672]

This was a great video! Do you have a app download available for members? I was looking through the content and I didn't see this one available?

[@RezaDorrani]

Memberships started in aug 2023. This app was probably before that. If there was a public link shared, then it would be in video description

[@NoCommentLeftUnsaid]

Very thorough video, once again. I downloaded the app, but I wonder if you have a link to the list structure that you used? It takes a bit of trial and error to recreate it from the hints in the video.

[@RezaDorrani]

Thanks! I do not have any links related to the list structure as there is no easy way to export SP list templates in modern SharePoint.

[@NoCommentLeftUnsaid]

@@RezaDorrani Thank you, the screenshot of the SharePoint list is then what I will work from!

[@zerokhan858]

thanks reza!!

[@RezaDorrani]

Welcome

[@alzsz6670]

Awesome video, is there anyway we can disable the previous days from today ?

[@RezaDorrani]

You can check if date < today and accordingly make the controls within calendar read only. This is not something I have a video reference for though.

[@berfinyldz571]

Hi Reza, thank you for all this information. I want to design a datepicker in this color labeled calender format for annual leaves. But I want to exclude holidays so that user can't select an holiday date for annual leave. Just like locking cells in excel. Do you know how I can solve this?

[@RezaDorrani]

I have done a video on calculating business days - kzbin.info/www/bejne/h4fZmXeba9Wop5I May be a combination of logic in video linked and this one may get you there. I will also recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@davidmashworth]

Awesome video as usual! Any ideas on how I would use a Gallery as a source rather than a SharePoint list? Also how would we format entries based on start and end dates (not just singular entries)?

[@RezaDorrani]

A gallery itself needs a data source. Calendar is a gallery.

[@jerriciakambonde3123]

Great video, thank you! I used a SharePoint list as my data source. Followed the steps in the video but my calendar in PowerApps does not display the events e.g. the dot on each day with an event. How to resolve this please? Thanks!

[@RezaDorrani]

I have not come across this issue hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@hygiearubio1616]

were you able to resolve this? I am experiencing the same, however I do see some events but not all events.

[@jjavi8685]

Reza great Video, on the last section when you can click on an itemto go back to edit form data, how can I create new item clearing out the form, I am having an issue where the variable set does not clear when trying to add new items. Thanks!!!!

[@RezaDorrani]

I did not understand the question. clearing form is resetform function

[@robinisathakur]

Hey Reza, if you needed to see a day view of the calendar and move between days (like classic SharePoint calendar) while displaying events within that day, would you have the calendar in the left of the screen and display the events in the right portion in time order? Just thinking of scenarios of where there are more than two events on a specific day, the PA calendar screen alone doesn’t quite have the screen real estate to deal with that.

[@RezaDorrani]

That would be an option for sure. When user selects a specific day in calendar, a connected gallery on the right hand side can list out all the events for that specific date.

[@txaussteve]

Great video. Note, at the 18:56 point, you show a gallery with graphics and text. When I see the code, you have text labels with images i.e. - Flag, Calendar and Arrow images inside of the label. How do you do this?

[@RezaDorrani]

Its a standard gallery with controls. Check kzbin.info/www/bejne/mJ-maahpnMmKqdU for gallery designs

[@txaussteve]

@@RezaDorrani I'm sorry, but I did not see an example of a graphic in a text label: "Image " & ThisItem.Progress.Value (Sorry I can't paste in the screen capture, but in your video you display images within the labels) When I highlight the image in the label, powerapp's displays Data type: text

[@RezaDorrani]

@@txaussteve Those graphics are emojis. Its a part of the data.

[@ray_jeremiah]

At 15:30 my column includes a time stamp with the date. I’m having issues setting the visible property based on that ‘due date’ column. Do you have any pointers here?

[@RezaDorrani]

I believe there are functions to simply grab date and ignore the timestamp. Check Power Fx formulas reference documentation for that.

[@chulitoalbo3958]

HI! Great Video Reza! :) Is it possible to modify this calendar so that multiple date fields can be selected, marked, and when clicked again, the marking is removed? I would like to collect the marked date fields and store them in a SharePoint list. Thank You! =)

[@RezaDorrani]

Possible by adding option for user to check multiple items in gallery. I dont have a specific video reference on it though.

[@utoroprincewill7808]

Great video, a question, what if I want to use the form from Powerapps to book for 3 interviewees who will come for an appointment 3 days ahead from a current start date to an end date i.e say from 1/1/2023 to 3/1/2023, so in this case after the start to end date is specified the tool create the interviews 3 items in a recurring manner

[@RezaDorrani]

This is a specific scenario and one that I would have to try out to know the steps. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@BatoolAljedani]

much appreciated

[@RezaDorrani]

Most welcome

[@txaussteve]

I really love this calendar. It is amazing. Quick question, when scrolling forward, it stops on Dec 31, 2022. Can the calendar go into the new year and if yes, how?

[@RezaDorrani]

If you look at the standard template screen, it does allow beyond dec of current year.

[@txaussteve]

@@RezaDorrani Not sure if this is the correct approach, but I went to the right arrow (To advance to the next month which currently stops on December) I selected the visible property and found this: _firstDayOfMonth

[@RezaDorrani]

@@txaussteve Not sure. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

[@christerrussberg3059]

Hi Reza, great video as always. But I have a question regarding this calender. Do you see it possible to get a year view ie have all the months for current year as starting point of the app??

[@RezaDorrani]

Most welcome! Not sure if thats an option. Something that I haven’t explored

[@michael498176]

Great video, Reza! Is it possible to select a range of days using the calendar control?

[@RezaDorrani]

Thanks! Not an option with the gallery control.

[@rukmanandhan4913]

Thanks for all your thoughts

[@RezaDorrani]

My pleasure!

[@akshay._.solanki]

Hi Reza, Great information as always I learn so much from you about Power Apps In this video, when you are showcasing the color code calendar screen from 17:55 to 18:56 I am trying to replicate the same scenario where I have a SP list with two date columns, start date and end date First, when I try to remove the circle and subcircle from the MonthDay Gallery I get errors Second, You mentioned to add second gallery inside of it which I tried as well but it is not showing the data in it as well By any chance can you put source code for those calendar gallery apps in your video description so I can take detailed peek into the code for specifically the color code logic calendar screen Thanks :)

[@akshay._.solanki]

Also, the calendar is not showing todays date , do you know what could be the reason for that?

[@RezaDorrani]

The video gives a full walkthrough (step-by-step). I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@ArthurSilva-q4h]

amazing content, i would like to watch from zero the orange app, if you can do that video... thanks

[@RezaDorrani]

Thanks! I don't remember what the orange app does or was. Video description may have link to download the apps shared.

[@giampaolocarli4728]

Good evening I created views to extract the data from my SQL database the reference date is extracted in a different way that is Datetime format dd / mm / yyyy 00:00 but if I try the SQL side to make it compliant with the data Power APP I enter the delegation problem Thanks form all : convert(varchar,isnull(R.DataPresConsegna, isnull(R.DataPresConsegnaRichiesta, T.DataDocumento)), 103) as DataRiferimento

[@RezaDorrani]

I have not done much work with sql. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@WakeZone]

If I have an event that extends multiple days, how would i dynamically extend it instead of having the same thing written everyday until it ends?

[@RezaDorrani]

I dont think that would be a straightforward option and not something I have tried. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.