One of the constant feedback I get from users is the default date picker (why you have to select a date and HAVE to click Ok). Brilliant April! Thanks so much for sharing!
OMG I just added this to my app hahahah LOVE IT!!! The only bad thing (that I assume has to do with the actual PowerApp app from the playstore) is that when I look at it from my phone, the events won't show, I want users to see our pay dates. But everything else looks amaaazinggggggg, thank you as always April!! :)
@@AprilDunnam Hello! I think it's fixed! Or maybe I was doing something wrong hahahaha The only way I can see the events it's when I click on Today. This works great!
@@HikaruLychee Thank you so much Grace! I was trying to show events but I couldn't do it. After your comment, I click today and they just appear! Today buton triggers the events. Thank you!
For those experiencing the incorrect date issue, you can set the app 'OnVisible' command to reset your calendar component 'Reset(CalendarComponent). Then in the 'OnReset' property, insert the function that is tied to the Today button on the component. This will allow the date to automatically reset without needing to click a button each time the app opens
Thanks for building this. I wanted to add one more option here....What if we can select half day also.!!!.... Taking the reference of Applying Leaves.(Session 1 and Session 2)
@@AprilDunnam In Singapore, the government is funding us to take up upskilling / reskilling courses such as Digital, data automation, data analytics ... the list goes on. Your videos provide relevant content, resources and techniques to help us complete projects in building Power Apps and more. With my sharing of your YT CHANNEL, there are many appreciative viewers 😀 Thank you very much for all your efforts. BTW, the descriptive list of your video content is very useful too. I highlighted this point whenever I direct my mates to your channel. Please keep it up 🖕
I don't think this works still in 2023, I imported the custom component into a blank app and the formula errors that popped up resembled the acne on a teenager's face. I wish, especially for IT type video tutorials, there was a community notes feature where people could flag videos as "no longer working" and when enough people flag it that way - it displays some sort of overlay to the beginning of the video. Just my two cents.
Hey April, love this! One minor glitch I found - if you turn "Start week on Monday" off, and "Allow selection of weekends" off, it disables Friday/Saturday instead of Saturday/Sunday...
Hi April, Thank you so much for your awesome tutorial! Do you have a trick for concurrent booking? Like Daily, weekly and monthly. Also is there a way to check for conflict booking, delete the conflict and continue with the one you are trying to booked? Thanks heaps!
Excellent class! It was exactly what I was looking for. I would like to know if it is possible to add an address field when using the calendar for events. Thanks April
Great Component April, I'm trying to figure out how to populate my text input if you select a range...Sorry if it was reviewed in the video! Thank you.
For those that are experiencing the date issue, I was able to get around it by adding a button to the component that says 'Select Dates' in the center of the calendar. When pressed, it will advance the calendar one month and then back to the current month so the issue corrects, and then the button will hide based on a variable that is set to true when the button is clicked. Select(btnNextMonth_1); Select(btnPrevMonth_1); Set(varDateButton,true)
If you don't want to use a button each time the app opens, you can set the app 'OnVisible' command to reset your calendar component 'Reset(CalendarComponent). Then in the 'OnReset' property, insert the function that is tied to the Today button on the component. This will allow the date to automatically reset without needing to click a button each time
Hi April, I have followed your steps but upon import it has a bunch of red cross errors and the section where the dates should be is all black. Any idea why that's happening?
Hi April, thank you very much for sharing this very useful calendar. I am using it now on my app, however, I am having problems with the start date or default date. I've set it to reset the calendar whenever the screen displays where the calendar is. But the date (which is today January 23, 2023) shows Sunday on the Calendar when it should be Monday. When I click the "Today" button only then will it correct the date. May I know how to resolve this? Every time the app launches the users are complaining about the wrong day, it is always delayed by 1 day (ex. Jan 23, 2023, falls on a Sunday instead of Monday).
hi April, I tried using your files to create the Calendar page. however, the formula seems like it's not working anymore. functions like AllowLongWeekend etc is not working. Is it because the current version of the Power Apps?
Hi April, thanks a lot for this component; it is very useful ! I see the property DaysAheadRestriction is not available anymore in this fantastic Component... Do you have any suggestion on how to limit day selection in a range (e.g. 120 days) ?
Hey! This is amazing! Only thing that is an issue is when I share the app and run it. The days seem to go off for example in Jan Monday's date will be incorrect also the weekend doesn't block instead its Friday and Saturday. Only resolution I can find is by clicking the btnPrevMonth (the arrow to change month) which seems to reset and put back the correct dates for the days and the blocked weekend gets corrected. But can you please fix this in the component, would be so so helpful. And thank you again for this video April!
Great Video April!! I was wondering is there a way to pick multiple certain dates? ex just Monday and Wed and the person doesn't need Tuesday off? thanks again!
Hello April, Could you kindly do a similar video in which we can see weekends and public holidays dates only as editable rest weekdays to be disabled? Thanks! :)
April this is a fantastic component! My week starts on Sunday and I am excluding weekends and the math is working perfectly. When it opens, however, it opens as if the week starts on Monday and grays out Friday and Saturday until I click Today or one of the arrows and then it looks as it should. Have I set something up incorrectly?
Hi there, I was struggling with the same issue. What I did is copying the OnSelect code from the Today button to the OnTimerStart code. Now it seems to work fine!
@@MatthewLowden I've found a different solution. Copy the code in today button into the onReset property of the component. And reset the component onStart of the page which has the component
Thank you so much for sharing, its really helpful. I am stuck at a point, I want to select a range of dates and should be able to show all the selected dates onto the gallery, how can I achieve this? Please help!
Very Very Excellent. My question is, how can i restrict selection of a date to a range? I was thinking of creating a variable, based on the current week and previous week but the variable would be based on today(). Meaning current = monday through sunday of the current week and previous week = not greater than current week. Is my vague idea plausible?
Hi April, I am somewhat new to power apps and have just found this video. It is excellent and just what i needed. However i am trying to get the calendar to return the start and end dates of a range selected for holiday selection. I can only get it to display the start date in the text box. is there a way to get it to display both in the same text box or do i need separate ones? many thanks Paul.
Hi, just saw your email. I've tried to d/load the msapp file but failed since it is either unsopported or damage. Any alternative for me to d/load this? Tks
Awesome Video as always. I was just wondering why you weren't using Sequence() for populating the values of your component 😊 I will definetly check it out.
Sequence is cool - feel free to update it to use sequence if you're all about the sequence. I started from the sample calendar component Microsoft had released awhile back which was pre-sequence so I didn't bother to change it :)
Brilliant, April! However ,it is April 2023, I can't find File -> Advancing Settings to enable component. Also can't find where I can import the component in current version
Hi April, this calendar is exactly what I'm looking for! I'm not able to use a component library because I need to build my app in Teams to use Dataverse. I did import the component to Power Apps, and I'm trying to build the calendar by hand as a Component in Teams app. I get the red squiggly lines when I use the "self." operators on the buttons. Any ideas what I might be doing wrong? Also, there are some errors in the component download that wasn't there a few days ago. It looks like all the expressions with a DateAdd using Days are broken.
Thank you ever so much for sharing your amazing work! I started out with your desk booking & reservation template for a "booking computer-app" and I'm so grateful for this channel! I replaced that calendar with this one (because of the Monday-start) and it's almost done and working really well! If I may ask you one question; I can't figure out how to make the date selection fill disappear from the last booking as I enter the date selection page, do you have an idea if it's possible? Thanks again and sorry for my english, you rock! \,,/
You can select multiple dates but not by holding down the ctrl button. You have to click the first date and then the last date and it will automatically get the range
Hi April, I sent a comment a couple of days ago. Is there an update for the calendar control you created? For some reason, it shows 0 for everyday. Thanks
Thanks April, really useful. Do you know of a way of colouring the dates? i.e I’m a shiftworker, working 6 days on 4 days off. I wish the 6 working days only to be coloured green. thanks again
Problem with the format of date ( powerapps & powerautomate) , i can't use my app on computers with different languages I would like to inform you that there is a problem with the format of date. It works with some users while others are facing difficulties using it. I tested it many times to see whether it works properly. I tried with a user whose Windows is English as well as his Microsoft teams. For him the format of the date (month / day / year) works with no problems. However, when tested the format with those who have Ms teams and Windows in Slovakian language, I found out that it doesn't work. In the list sharepoint it gives the opposite i.e Day/month/ year. With the latter user, I changed Microsoft Teams into English and the format of the date has changed too. The application works properly. I wanted to test another user, trying the application on his computer who has Windows in Slovakian and we changed Microsoft teams in English, the format doesn't work either. I wanted to try the link of the powerapps without using Microsoft Teams, always the same result. That is, The format is always dependent on sharepoint and Ms teams. (FYI : I fixed the format date in my application (powerapps) Month/day/year)
Hi April, by far this is the best calendar component I have seen, thank you for that. :) However, I am struggling a bit with the part, where I need to replace the CalendarItems. I would like to replace it with my data from SharePoint list. In the component itself I have changed the fields, which I will use to have the key values same as in my list. So instead of Date, Title and Time I have Date, Title and Type with some dummy values. In the app I have the CalendarItems as following: Table( { Date: 'listname.Date, Title: 'listname'.TypeOfWork, Type: 'listname'.Type } ) Is this approach correct?
It seems that when you try to insert this component into a Form's Datacard, it doesn't behave as expected and none of the elements are selectable. Is there a quick fix for this?
Thanks for sharing the video on this and Happy ThanksGiving Day April , However how we can implement the same in Power BI. I can see still when its comes to Financial reporting in power bi , most developers don't have idea and not sure what is the best way to implement Power Appps concepts and how !! It's really struggling !
I'm stuck at the part where I want to connect the calendar component to a SharePoint list. I have a list Named TestList with the Columns Title, StartTime (date). How could I connect the date from this list to the calendar component please?
Indeed, its a great work.. much appreciated and thank you so much for sharing it🙌. I have a one more requirement with this calendar , on closing this "X" icon of this calendar component i want to update a variable in my screen, is that possible.. If yes, please let me know.
Hi April, I'm using the calendar component and am having an issue. I have it set to lock out selecting weekend dates but upon initial load, it blocks out Friday and Saturday instead of Saturday and Sunday.
Hi April, Thanks for sharing this component. I am trying to integrate this component with PowerBIIntegration. Basically whenever the date is selected in PowerBI report, it should reflect in the Calendar component as the date selection. But i am not able to do that, i tried setting the defaultStartDate and DefaultEndDate, Resetted the calendar but did'nt worked. Please could you suggest on this issue.
Hi April, I can successfully import and use the calendar you provied, however when the calendar is first loaded, the TODAY show on the calendar is 1 day before today, means that 21 Jan 2022 is Thur in my timezone, but it shows 21 Jan is Thur, is it issue with regional setting or timezone setting?
This is a great component - thank you April for all of your content. I have been using this component in a vehicle reservation app, but I would like to allow someone to modify an existing reservation and I can't find a way to easily pass the existing start and end date of the reservation to the calendar and have it represented visually. Any tips there? Thanks again!
And for anyone who is struggling with the same thing, I figured it out. On the Component Properties window, set "Access app scope" to On. It will allow you to use controls to pass data to the component.
The Start on Monday function is not working correctly. You just switch the weekdays but the date stays the same. So the hole week is then wrong bi one Day.
i want to use this for a booking system, so i need to gray out date ranges already selected by another user. can this component do this, or can i edit source code?
It doesn't do that as-is but you should be able to modify the code to make that happen. If you import the component and go to the components tab in your app you can edit it. I will add this to my growing list of new videos to make when I get time
Hi April, Thank you so much for your tutorial...!!! I like to create the custom calendar for my team member, which need to fetch the data from online excel & shown the scheduled work details. Could please help me the way to develop the on PowerApps?
Hi, thanks for your usefull Component! Unfortunately, I have a problem with this: Has already encountered the problem that sometimes the number of days will be zero? All days zero. After I inserted component, first everything ok, than later, when I run app again, problem is comming. (meanwhile I didn't change anything in the app) I'm hungarian developer, maybe the problem causes my environment? Thanks!
April I have a ? I exclude the weekend and enabled the date range, but when I get the date diff it include the days count with weekends. I can I manage this to exclude weekend from dateDiff function please 🤞
Great work! Do u think there's a way to write on top of several days at once? Like giving a start date and end date item and having the added item a rectangle bar on top of specified calendar days (kind of like Outlook)?
Hi, I have tried to use this calendar component on my app, Once i import the component and added on screen, its showing error mention invalid argument type,expected numbers on five places error is on this part Set( _firstDayOfMonth, DateAdd( _firstDayOfMonth, -1, Months ) ); And Day( DateAdd( _firstDayInView, ThisItem.Value, Days ) ) can you help me with these?
Hi April, thanks so much for this! I used this to build an app that's working great, except for one thing that I can't figure out. I'm using the component as a personal date scheduler (so it's filtered to only show the current user's dates) and the little indicator dots (that show the user which dates in the future they have an event) are only appearing for my account (as the app creator), but when my users log in, the indicator dots for their own dates are missing. The data is there because if they click on the date, the app shows the matching item in a separate space below (from the source SharePoint list), but the indicator dot is missing. I'd really appreciate any ideas on how to fix this. Thanks!
hi, loved the calendar video.. How do I enhance it to make it to link to my Outlook Calendar and to allow users to select a date/time to book a meeting?
Thanks for your app ! I'm having some trouble when I refresh the app : it seems like the hole calendar is filled by 0.. Could you help me solving this ? Thank you
Hi April, a great calendar component. If I want to set the workweek on the 1st column, is it possible? Wk 1 is Jan 1-2 or Wk 1 Jan 3 - 9. One year got 52 weeks.Thank you.
Hi April, thanks for the GREAT solution. One question. I've enabled the select range. How do I hide the component automatically upon selecting the end date?
Hi April! This is fantastic but I am having the same issue that numerous people are experiencing where the first of the month is showing on the wrong day of the week. Switching months and then back or clicking Today resolves the issue but is there a fix for this or is there a piece to this that we are missing? Many thanks for all of your vids.
Thanks! I don't have anything included in the component right now to customize the language but you can certainly edit the component itself to change the language
Thanks for the wonderful app. I do have a question though. I ran it this morning and the dates are off by one day in January. (Jan 1 is on Thursday). If i forward to Feb and then back, it fixes itself. But if I start the app again, it goes back the Jan 1 begin on Thursday. Any suggestions?
Hi April how can I get the last submit id from SharePoint using a collect with patch and not forms as I am using a scrollable screen will appreciated it thanks in advance
Dear April, thank you so much for that tool! I successfully added it to my app and it worked for a certain time, then suddenly it only showes 0 values and not Month anymore. Also reinstalling the component did not fix the issue. Thanks for any ideas !
Hi, really nice component, thank you. I am experiencing this strange beahvior when I get to the screen where the component is, days and other settings like weeks starting on monday don't apply correctly until I hit the today button. Have you seen this behavior? Thanks.