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.
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! 😍😍😍
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 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 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
@@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/
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
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
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.
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 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!
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?
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
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..
@@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.
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?
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.😀
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
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.
@@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
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.
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 ^^
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
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
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!
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.
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??
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.
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!
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?
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?
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
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 RU-vid 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.
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.
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
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! =)
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 :)
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.
Hi, please can you make a video how to select multiple dates in this calendar template, Your videos are so helpful ,please post a video to select multiple dates , Thanks in advance
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 topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
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!!
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.
Hello Reza, How can we stop power automate flow going into the infinte loop ? Scenario - Let's say we have a flow which is getting triggered on update of account name field on account and is updating same field with microsoft dataverse's actions. This action will trigger our flow again and makes it to run infinitely.
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)?
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...
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. :)
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?
@@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.
@@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
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??
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..
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!
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.
@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.
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.
@@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?
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 ?.
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
@@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 .
Hi Reza great video as usual. I followed & did everything, but couldn't connect my data source which is SharePoint. It shows me table & connector when I tried add data. Any idea?
Video description has link to download sample app. As for your issue, 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
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.
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.
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 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
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!!!!
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
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
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?
I have done a video on calculating business days - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QVvhDe6puq0.html 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.
Hi Reza, I am following all of your steps and not getting any errors, but the circle icon is not showing up for when I have events. I have tried connecting to a Sharepoint List and Excel spreadsheet. Do you have any ideas as to how I can fix this?
Your query to get the data may not be correct or not returning any results. That could be the reason. I cannot guess what the error/issue is without looking at your App. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@andieoconnell4922 You cannot post screenshots in YT comments. Also, I only go to forums in my free time to assist. There are many better experts than me on the forums.
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 :)
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
Hello, Excellent contribution and help... However, I still have some doubts... What happens in the event that an event is overwritten on the same date and time. There is some way in powerapps to compare both fields and that in the event that you are choosing a date that already has an event, it will notify you that that date is already occupied. Is it possible to do that?
@@nicolascorreacavieres5392 I do not have a video reference on this and will have to try it out to provide the steps. I recommend posting your query on forums at powerusers.microsoft.com/
Do you show the data source / sharepoint list anywhere? I'm trying to understand how to create lists to interface with your demo, without having to reverse engineer the code. Thanks.
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.
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.
Hey Reza! Reaching out to learn if you have had a chance to think through how to customize the Calendar Control for Weekly Views? I suspect that might be helpful for a lot of folks.
I do not have video plans for a weekly calendar view. 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 RU-vid 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.