As promised, part 2 of the calendar app. This time pulling in data from SharePoint. It also talks about nested galleries which is always interesting. I hope you enjoy! Power Apps Consulting and training at www.PowerApps911.com
Want to thank you. I had a similar app and was having some issues with a few layout "quirks" you've helped steer my thinking and helped me overcome those issues. Much appreciated.
As expected, another excellent video. Next step for me is to try out nested galleries in the week view so that I can show the hours of the day and really see the schedule data pop. Thanks Shane!
Hi Shane! I can't tell you how much I've learned from you... so thank you! You said that if we wanted to see a video on using this with time, to put it in the comments - this is me following directions.
@@ShanesCows I, too, would like to see the addition of the time video. I can pull the dates if they are all day, but anything less will not show. And thank you for your awesome resources!!!
Fantastic video Shane. This helps a ton. I'd like to add a function that shows a view of conflicting events. When selecting or mousing over a date, can a view show events that one or more people are assigned, as well as any conflicts and what the specific conflict is between events (e.g. people on leave and not available to be assigned tasks, or tasks happening at the same time assigned to the same person and therefore showing a conflict of date availability)?
Great video's Shane! You're the source of my wisdom :). Noticed a little bug with a calendar view: When using "European" view (Mon-Sun) month of February starts Monday (1/2/21) and ends Sunday (28/2/21) exactly 4 weeks! Had to make little mod to your formula to accommodate that... Sequence(If(DateDiff(varVideoFirstDayView, DateAdd(varVideoMonth, 1, Months), Days) < 30, 28, If(DateDiff(varVideoFirstDayView, DateAdd(varVideoMonth, 1, Months), Days) > 36, 42, 35)))
Hi Shane! Thank's for another just brilliant video. Video tips - Just miss the gantt view in modern lists. Using excel for staff vacation overview, tabs with departments and under each tab all department staff listed in one column then colums with weeks where they color code cells for plotting out vacation.🤔 Old gantt view and calendar views pretty ok for this but modern - no no. Tried custom view formatting gantt but leaning torwards creating a power app. Happy Easter
Hi Shane, Thank you so much for these. Brilliant series. Any videos or suggestions on pulling in events from an Outlook calendar and displaying it on PowerApps?
Hi Shane, im working with powerapps and i have a question, i have a nested gallery and i want to find a way to change their size if their children gallery contains something, like reduce their size if they contain nothing, and keep them big when they do, is there a way to dynamically change the size of the templatesize for each element of a gallery rather then they have all the same size?
Hi Shane, as mentioned by others both videos in this series are great. I am using your calendar code to create a vacation calendar for our office (small team). I would like to highlight the stat holidays as a different color on the calendar for the whole day, not just as an entry on the day. Any ideas? Worst case I will just add the stat holidays as events, but would be nice to cover the whole day/box of the day on the calendar.
As always, another great video and detailed explanations. Question on the Fill color dialog around the 25:25 minute of the video. You were illustrating how if a calendar event was selected, the color would change for that event (brown or blue in the video). Could you share any insight on how the calendar events displayed on the calendar could have a different Fill color based on Start or End Date? In this video example, it would be Start Date=brown and End Date=blue.
Great video (as always). Did you consider making a video where Date AND Time is a part of it? Thinking that there could be several numbers of events in one day, and it could be great to see them with the time included as well. But again, very very nice job Shane 👌👌
Hey Frank. I did think about it but never did. Maybe the time slots video would give you some ideas? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hIePqg2Ui2I.html
thanks for the video Sensei. I stumble upon the date picker in power apps from teams as well and copied it over. I like the fact that control has a max and min date range to control the dates a user is allowed to select, a feature that's missing on the regular calendar control. I found it to be buggy when defaulting the date from a data source, it just won't default. Let's see if you have that same issue.
Hi Shane. Thanks for your videos they are amazing. I have created a calendar similar to the one you have made. The problem I get is that I want an Event to start on 2022/09/07 07:00 and end on 2022/0908 16:00. When I look at my calendar, the Event does not start on 09/07/2022 but on 09/08/2022 because I have the time included. How to fix it??
@@ShanesCows I'm waiting for that one as well! Thank you for the very informative videos thus far. Trying to figure out the Patch. I have tried on my own, but get an error with the Patch function about not being able to patch a table.
Hi Shane, I am using the week based calendar that was made not to long ago. I am using it as a base for my small team and tracking generic hours (i.e. sure we say 13 Jan - 20 Mar but we aren't awake for the whole time) was wondering what would be the easiest way to implement it so that I have the staff list on the left hand side and then the block out the days for this staff member? Kinda like how a timetable would work. Thanks
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?
Hey Shane, So thankful for your videos. Is there a way to have the weekly calendar that shows hours on the days and then add events for specific times?
Yes, but I haven’t done a video on that. You just have to shape the data for the hours. It is possible. Consider something like sequence function to help.
Great Video! However you posed a question that you said that you would explain later; Why You did not use a SharePoint Calendar. Something along the lines that they were doing something evil. I have been trying to pull data from a Classic SharePoint Calendar into PowerApps or even Power Automate and have been unable to see this data. I can only see regular lists, not Event Lists. Is there a way to get data out of a Classic SharePoint Calendar using PowerApps?
Hi Shane, another brilliant video. Through your excellent tutorial I have managed to get this up and running for my team and even managed to build another screen to allow them to input events like rest days and leave and show using this calendar. I do have one question though - is there a way to add a recurring feature so when people book a rest day - it occurs every 4 weeks? - The data writes to a SharePoint List
I am looking for some guidance on using StartTime along with a duration. For example we would have either a StartDate & StartTime field with a duration or dedicted StartDate, StartTime, EndDate and EndTime fields.
Hello Shane, thank you some much for your help. Your videos are amazing and are helping me so much. Now, i have a little problem, in the 16 minute youre explaining about setting the "VarVideoFirstDayNextMonth". Im using the European view Mon to Sun and the formula isnt giving me the last day that shows in that month (4/3/21 in the example), instead its giving me a day prior (4/2/21). Im sure i have to consider "Monday" like u explain in the past video but i keep getting error. Could you help me?
Hi Shane, Excellent Video. It helped me a lot. Is it possible to create the video regarding the add event, display event, as you mentioned in the end of the video? (Or do you already have it? I couldn't find it). I'm not being able to do the display mode on my calendar..
This is awesome as always . I would like to know how to get the events counts for that particular days in the sub gallery which coming from SharePoint List
Use CountRows to count the sub table shown in the sub gallery. So in your main gallery have a label CountRows(ThisItem.DATA) if I remember the video correctly.
Hi Shane, great video and really is helping me learn more about PowerApps while I build a calendar for work. I do have a question. In my setup I have multiple events on the same day and have to use a scroll feature within the calendar to see them all as there is a huge space between each event. Is there anyway to remove that space so up to 3 events can be see within the date without the need to scroll?
Great video. Not sure if this is possible, but figured I'd ask. Am implementing this, toying along the way. Is it possible to make the calendar gallery expand depending on number of items? Example, the day has 1 event, the height's not that big. But, if a day has 10 events (I'm trying this for a vacation type calendar, so 10 events wouldn't be out of the ordinary), the height would be larger to accomodate?
Hi Shane, Could you please make a video for Invetory System. I just make inventory apps, but i confuse how to make all history recorded on Apps (include all input data/not only latest input, All tool certification update history) an so on. Help me Shane
Shane, I have a calendar that displays items from a share point list. The list is reservations with a start and end time. When a user clicks a date on the calendar, there is a gallery that shows existing reservations for each item that can be reserved. By default they are just stacked up in order regardless of start and end time. I’m trying to display them in a view similar to an Outlook calendar so I visually see the start and end with appropriate gaps when there are no reservations for that day. I can use the start hour and end hour on the Y and height…..that works for the first reservation of the day but for subsequent reservations everything is messed up because I can’t reference the previous item to know how much time, if any, is between them. Thanks for any ideas.
Kevin the last time I did something similar I created slots for the whole day, like outlook and then showed the taken ones. A bit of a different approach but made it easier for viewing and scheduling
@@ShanesCows thanks for your response. In your case were all slots for the same duration? Any chance you have a video describing this approach? Are the slots saved in a different list from the reservations? Edit: I created a separate list of time slots. I managed to fill it n the gallery based on filters comparing the start and end time of the reservation to the time slot….looking good. Thanks for the suggestion!
How do It = remove time from a date value from sharepoint column but keep in date format. Converting to DateTime > Text > Date has delegation issues, I just want DateTime > Date - is this possible?
Hey, Shane, great video as always! I'm a bit late, but I wanted to ask how you managed to make it possible to edit and view the entries afterwards. I'm a student and I'm writing a study paper about it and I can't really get far :( Maybe you could help me or make a short video about it. Thanks a lot and keep up the good work! Greetings Nico
seems like you could apply this to the weekly calendar in the other video, but do flexible height nested galleries to get them to scroll? does that logic work?
Im doing a similar app but this one will work for my whole team, 24 persons, I want to know how to display all absence for on day, for example, 4 guys will be out of office 29/09/2023, I want to select the date on the calendar and display this 4 out of office, could also be more but I dont know how to do it, do you have any other tutorial for this topic?
Hey Joel, I wish I remember exactly what it was. I think the fields like start and end dates aren't delegable or somethign silly like that. Whatever it was made the idea a non-starter.
Hi Shane, this is some quality great video (as any other that you make) but in particular i was searching for something like that. All working perfect but i get some doubt and i don't know if is needed to edit something in the code: I have put events for the next year (01/19/2024 for example) and is patched in the list on the site in SP but is not showing on the calendar. Maybe is needed to pass the year to be reflected? its possible that whit the next sentence im giving to myself the answer because at some point you make Set(varVideoMonth, DateValue("1" & "/" & Month(Today()) & "/" & Year(Today()))) and it is specified as today the year to show the events. And if that is true how you can edit to still seeing the events on the previous or the next year? Requires a new formula?
Could we automatically adjust the gallery height to accommodate all the text of the event within a day? I suppose we would need to utilize a flexible-height gallery for that purpose. However, in attempting to do so, I discovered that there is no wrap count available, which makes it challenging to create a calendar using this method. Do you have any suggestions or ideas on how to overcome this limitation?
How do I insert Birthdays, that are repeating every year but are stored in Sharepoint list as "dd/mm/yyyy". I need to use a seperate collection to events and ignore year when putting it in correct day/month.
Hey Shane, quick question. Built a calendar similar to yours. I'm at the part where I'm trying to add a form. Clicking on a record in the calendar though takes 4-5 seconds to load the record in the form. I thought it was because I set the form source to the SharePoint list and not the collection. But even changing that made no difference. Have any thoughts?
Okay, actually, rewatching the video for the 11th time, (don't forget I'm a toddler), it looks like you have basically two sets of form controls. One for Adding, one for Editing, and you show/hide depending on buttons pushed? And the patch statements vary depending on which set of form controls are visible? That also means 2 different save buttons, etc?
Good morning My question is can you make an event that covers multiple days that only displays the title once over the week in the centre? My goal is to have events that are two or five days that display as one event.
Excellent tutorial, Thank yoU! @15:30, a slightly simpler way to grab varLastDayView is to use the last Value in the gallery.AllItems. Since you already solidified the math in Sequence(), I think the following is trustworthy: Set(varLastDayView, DateAdd(varFirstDayView, Last(galMonthView.AllItems.Value).Value))
Shane want to display only the start date of the event even if it is a multi day event. Currently have not figured how any assistance would be highly appreciated.
hey Shane and all. (awesome vid as always by the way :)) Any ideas on how to get rid of the time from displaying please? i.e th 12.00AM from the current date label. Thank you!
@@ShanesCows Thanks Shane! Because that label is using ThisItem.Value to retrieve the Date/Time, I can't get any text function to work with it. This is the code: DateAdd(varFirstDayView, ThisItem.Value,Days) Thanks again!
Hi Shane, Thanks for the video.I couldn't understand after the 23rd minute. Those two codes you wrote there don't work for me: varFirstDayViewMinus1 varFirstDayViewNextMonth Where did you create these variables?
I have never tried, sorry. A few people have commented it seems to be a stumbling block, if I ever explore it I will surely make it a video. Do let me know if you figure it out though. :)
I am not sure. I would start by just using a regular galley and hard coding the formula. See if you can get that to return a match. Troubleshot small problem then apply it to the dynamic gallery.
@@ShanesCows Thank you for your help, the issue wasn't the Monday fix but in the date format, it was trying to compare two strings with different formats and therefore didn't show anything :) Thanks again.
That should work as long as you use the start date and end date to drive what shows up. I thought I showed it in the calendar videos but maybe i didn't? Hmm.
Urgent: Hi shane, i followed all the steps but data from my sharepoint list is not showing in calendar of power app. Tried to rework thrice but still same, any ideas?
Hi Hun, I ran into the same issue. I ended up looking on the Title tab nested in GallDayDetails and noticed that when I connected to my SharePoint date it changed the ThisItem. to something totally different than what the column was named in the SharePoint list. Once I changed it to what it should be it appeared on the calendar.
Hi Shane, thanks for another great video. At 24:44 you patch a new event to sharepoint and then clearcollect colSharePointEvents. I believe the clearcollect is not needed as you can can collect varSelectedEvent to colSharePointEvents. Or am I missing something? Thanks for any reply and have a nice day!!
I am trying to get the max number of records in a nested gallery in an effort to dynamically set the template height based on the max number of events. so far I am setting the number of records for each day. I am starting to realize that this is both impractical and likely wont work. I could use some help with a better way. Set(r1,CountRows(Filter(MonthRecords,DateAdd(MailDate,TimeZoneOffset(MailDate),Minutes)=DateAdd(CalFirstDayofFirstWeek,0,Days)))); Set(r2,CountRows(Filter(MonthRecords,DateAdd(MailDate,TimeZoneOffset(MailDate),Minutes)=DateAdd(CalFirstDayofFirstWeek,1,Days))));
Has anyone come up with a solution for this? Would be a nice "add". I'm working on a "Time Off" calendar, using this system. Also experimenting with the new PDF feature. Would be nice to dynamically set the height of each week, remove some scroll bars.
@@glennbullion9069 this is what I had to do. Once I got this number then I used it as a multiplier in the template size. It is not elegant but it seems to work. Also BTW if you want something like this to work for each week separately you could experiment with multiheight galleries or creating separate nested galleries for each week. I didn't have good results with that myself. Set(CalRecCountMax,3); Set(CalRecCountMax,Max(CalRecCountMax,CountRows(Filter(MonthRecords,DateAdd(MailDate,TimeZoneOffset(MailDate),Minutes)=DateAdd(CalFirstDayofFirstWeek,0,Days)))+1)); Set(CalRecCountMax,Max(CalRecCountMax,CountRows(Filter(MonthRecords,DateAdd(MailDate,TimeZoneOffset(MailDate),Minutes)=DateAdd(CalFirstDayofFirstWeek,1,Days)))+ ' Repeated up to 28 days If(CalNoofDays > 28, Set(CalRecCountMax,Max(CalRecCountMax,CountRows(Filter(MonthRecords,DateAdd(MailDate,TimeZoneOffset(MailDate),Minutes)=DateAdd(CalFirstDayofFirstWeek,28,Days))) ' Repeated up to 35 days If(CalNoofDays > 35, ' Repeated up to 42 days
@@davidcarr7793 Oh wow, thanks. Will have to read this 10 times or so to understand it. :) Each week would be nice, but definitely sounds complicated. A simple multiplier on template size sounds just fine.
Hi Shane, thanks so much for sharing this and all your other wonderful videos! I'm really enjoying working with PowerApps thanks to you. I was wondering whether you ended up elaborating on your comment about calendars being evil ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-8qqEfzdVM0Y.html anywhere? I don't doubt it for a second but I want to be able to explain why when I hand over an app which uses a gallery which is set up tp mimic a calendar layout.