Power Apps Calendar with SharePoint Data

[@MichaelDeBlasis1369]

Total masterpiece of a video Shane. I have been toying with this all month and failed many times. You made quick work of it and it works well.

[@ShanesCows]

Awesome. Glad to help! 🤩

[@amerritt2007]

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]

Got it Amanda! Thanks 😀

[@debhildrethpisarcik5945]

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

[@cristianoCR7shortytbe]

Hey Shane! Have you done the next part of this video? Is awesome I am working on the Gallery and need help for the Edit and Add form

[@ShanesCows]

I don't think I have done that next one yet. Still on the list.

[@megan7146]

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

[@texas_rascal3091]

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.

[@andressamarques3459]

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

[@megan7146]

I would like this video too.

[@glennbullion9069]

Same.

[@wendymason3263]

Another great video Shane, thanks so much. And thanks for mentioning the data picker from Teams it's great!

[@ShanesCows]

Happy to help Wendy. :)

[@michaelcarrillo2368]

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?

[@davidclarke7952]

Hi Shane, around the 9:10 mark you filter the gallery I've followed it and mine will only let me filter though "Filter ('Calendar Events', StartTime

[@ShanesCows]

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.

[@davidclarke7952]

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

[@christophermitchell3572]

@@davidclarke7952 do you chance have the formulas? I did the same thing. I only wanted to show "d" and the filter didn't work per video.

[@shining.youth.jewelry]

For anyone who is still struggling with this one. I also used european format and show only the "d" in the calendar. So I had to use this formula which worked pefectly fine: Filter( 'SharePoint List name', StartDateTime = DateValue(Text(varFirstDayOfCalendarView + ThisItem.Value, "yyyy-mm-dd")) )

[@keithdavies9150]

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!

[@ShanesCows]

Awesome Keith. 😎

[@BigLeafDropper86]

Working this Date + Time would be good to explore, finding it difficult to avoid delegate to add in the filter

[@vaidasgrazulis4242]

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

[@ShanesCows]

Thanks for sharing 😎

[@chrislee3378]

Thank you, we are working under the so called "European" calendar as well, lol

[@brat3141]

How to put it in European format?

[@stephendarier1390]

You blow my mind Shane killer video keep them coming

[@ShanesCows]

Thanks 😊

[@joelgeorgeejoseph]

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?

[@Zeslonatrus]

Do you solve this? I need some help with that too

[@nakulagham2058]

Thanks for all your excellent video's Shane, I've learnt a lot from you thanks again for everything..!

[@ShanesCows]

My pleasure!

[@jimwaldron3858]

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

[@danilogamut]

Also wondering how that logic would work

[@beccad3296]

I would also love an example of how to do this

[@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?

[@Prabinesh]

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?

[@GunneboBerg]

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

[@michaelvanslyke2039]

Awesome video, Shane! Would love to see a more in depth video on how you're updating events using the datepicker.

[@ShanesCows]

Noted. Thanks :)

[@rakeshs6928]

@@ShanesCows Waiting for the next video

[@SheIsObiquitous]

Exactly what I need right now. Thanks Shane.

[@ShanesCows]

Awesome

[@ParkerLearnsStuff]

Amazing video! You have a real gift for teaching!

[@ShanesCows]

I appreciate that! Thanks

[@razercleriyou8554]

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?

[@jeremyweaver2908]

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.

[@Blade007Mega]

I don't understand how to make such a beautiful calendar from “PowerApps Dataverse from Teams” in the canvas app?

[@ShanesCows]

This video should work the same way in Dataverse for Teams kzbin.info/www/bejne/iZ3Jn5uHnLKLqLs

[@JimFeaster]

Shane, is there a way to make recurring events in a PowerApps calendar? Do you address that in any of your videos?

[@beccad3296]

Did you ever find a solution for this?

[@marcelgraf4608]

Great video. Exactly what I needed to create a leave planner. Thanks!

[@ShanesCows]

Glad it was helpful!

[@torgeirkind23]

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

[@ShanesCows]

That would have worked also. 😊

[@michaelhazen7410]

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.

[@ShanesCows]

Hey Michael, I have never tried that. I need to, a few people have asked.

[@akbarmahfuzalam]

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

[@ShanesCows]

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.

[@matthewfritch9491]

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?

[@matthewfritch9491]

I figured it out. It was the template size. I changed it from 68 down to 30 and that did the trick.

[@ShanesCows]

Glad you got it figured out. 😊

[@glennbullion9069]

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?

[@nikhilkondaraju5248]

Hi good question were you able to solve auto height property based on number of items in a row?

[@rafaelrivero4269]

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?

[@sofikurban6382]

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?

[@ShanesCows]

I think they were in app OnStart. They are important

[@esterraful]

hi, did you discover how these variables were created? i stuck on the same moment. we havent created them ealier

[@lynnlong8154]

Hey, wondering if you ever do this video but with time. I haven't been able to figure it out

[@joshernst8050]

Maybe I missed it, What did you put inside of the Edit groups update button?

[@juansepowerplatform]

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.

[@ShanesCows]

Not sure. I will try to check it out next time I get a chance. 😄

[@ABCD-ABCDEFGH]

do you have any idea to display recurring events correctly in the powerapps calendar from the SharePoint calendar

[@ShanesCows]

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

[@joelgeorgeejoseph]

Hi Shane, You did mention during your video that there were issues in using the sharepoint calendar list , could you elaborate on that?

[@ShanesCows]

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.

[@hanspetersdorf1729]

hi i know this an older video but can i still find the source project of this video? i would like to dig in and have look how you managed certain things.

[@ShanesCows]

Yes, it is available as part of our KZbin Library training.powerapps911.com/courses/video-library

[@daniela5137]

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.

[@birphon]

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

[@gfraser78]

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.

[@dibarra72]

Is there a way to restrict entries to just Monday through Friday? For my purposes, I don't want anything entered on the weekend dates.

[@ShanesCows]

Yes but you would have to create logic to check if the day of the week was Sunday or Saturday and then disable it.

[@lydiablanar9319]

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?

[@ShanesCows]

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.

[@wild_things6582]

Did you make a video with date and time ?

[@ShanesCows]

I never did. This was as far down the rabbit hole I got. Sorry

[@AlejandroHernandez-w6j]

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?

[@chrismarsh2669]

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.

[@sundrapillay6668]

Thanks once more Shane for the excellent video

[@ShanesCows]

Glad you enjoyed it

[@hillaryburkett5301]

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?

[@ShanesCows]

I haven’t tried flexible height galleries so not sure

[@scotthoyt2773]

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

[@whalenkm]

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.

[@ShanesCows]

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

[@whalenkm]

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

[@glenmaxheleau1081]

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.

[@alesa081]

When you had multiple events on the same day, they automatically stacked on top of each other. Mine are overlapping the words. How do I change that?

[@marney720]

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]

Use the Text function and you can format the output to be what you want.

[@marney720]

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

[@giuliofalcao12]

I need to create a schedule training page, but I need to check the availability on my Office365 schedule. Do you have a ideia can I make this?

[@ShanesCows]

There is an outlook connector. It can query your calendar. I would start there.

[@stonesupermaster]

Hello! Where can I download this demo? Thanks in advance!

[@ShanesCows]

You would have to be a subscriber to this training.powerapps911.com/courses/video-library then you get all of the downloads. 🐶

[@JimFeaster]

Shane, Is there a way to have multiple day events span across those days of the event?

[@ShanesCows]

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.

[@JimFeaster]

@@ShanesCows Do you have an example to point to?

[@TheBananisen]

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

[@franknielsen3219]

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

[@ShanesCows]

Hey Frank. I did think about it but never did. Maybe the time slots video would give you some ideas? kzbin.info/www/bejne/nnrIgaSdZ7qcaKs

[@nickobalboa]

How to remove the time on the sequence?

[@ShanesCows]

Use the Text function to only show the date portion.

[@glennbullion9069]

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?

[@glennbullion9069]

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?

[@BigLeafDropper86]

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?

[@nico4im466]

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

[@jimenarojas6008]

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?

[@gsam3]

did you ever find a solution?

[@adityajadhav5064]

Hello showing the events according to date and time in calender can help

[@jusmansitohang733]

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

[@seadude]

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

[@smash461986]

I was having trouble grabbing the correct date. I assume because I'm doing this European style, but you code fixed it. Thanks.

[@Govindahya]

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?

[@matthewfritch9491]

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.

[@MrKhulaid]

This is exactly what I'm looking for

[@davidcarr7793]

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

[@ShanesCows]

I will have to think about this one. 🤔 I get how this is a deep rabbit hole.

[@glennbullion9069]

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.

[@davidcarr7793]

​@@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

[@glennbullion9069]

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

[@glennbullion9069]

@@davidcarr7793 Hey David. Sorry, I"m not sure how to apply the above. Where exactly did you put these formulas?

[@gjovalinnikolli592]

Hi Shane, I need some help on recurring events.

[@beccad3296]

Did you ever find a solution for this?

[@barunroyghatak4380]

This is the nice video Shane but I would request you to if you please keep your pace little slow then it would be better to understand otherwise everything perfect. ❤

[@ShanesCows]

Sorry, sometimes I get a little too fast. I try to catch myself but sometimes I miss. 🥲 Remember in the bottom right on KZbin you can turn the speed down. 🤩

[@barunroyghatak4380]

@ShanesCows thanks Shane

[@BigLeafDropper86]

DEMO IDEA: Daily Calendar for mobile format with swipe function for next day / previous day

[@ShanesCows]

Sounds fancy. I have never done a swipe in Power Apps... hmmm....

[@TheClearwall]

Hey, FYI, your title image says "Calender".

[@ShanesCows]

😂 Whoops. I will try to fix it tomorrow. Thanks 🙏

[@sahrchitect]

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 kzbin.info/www/bejne/bqLUdpmwmbuAZrs 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.

[@haodeng5227]

very useful

[@ShanesCows]

Glad to hear that