Wow, I thought this screen was just for Outlook calendars, now that I know it can connect to other data such as SharePoint lists it will definitely be very useful, thanks for helping me understand! ;-D "Just drag" for cranky position dependency re-sets is another great tip, I will pass that on.
Thanks Rebecca. I'm trying to connect to a calendar on my sharepoint site, but it doesn't show up as a potential data source. In the video are you connecting to a sharepoint calendar or a regular list with date fields?
Hi Rebecca. Great video demonstration. Two questions: How do I make the circle stretch to include a multi day event? Circle 1 icon is just for the start date. In my data source I have a column for event type. How do I filter my data source using a combobox with distinct, need multi-select ability?
Hi Rebecca, Thank you for the video. It helped me . On screen visible all my dates are as 0 when i click next arrow and come back it is showing 1 2 3 on screen visible it is showing as 0 in all dates not sure where i did wrong Also is there a way to show records based on date range like from and to
Hey Rebecca, I have created a monthly calendar based on one of your previous YT tutorials, which works a dream, but the end users want a different view similar to this one above, but instead of a monthly view, with a back forward/forward monthly. They have asked if it is possible to change this, based on this calendar screen to a yearly scroll and display the 12 months below, and by selecting the month display in a gallery list on the right hand side all the scheduled audits for that particular month? Great work and easy to follow tutorial.
Hi Rebecca - great video and I was able to successfully implement your example, so thank you! I was wondering if you have a video on how to show event information that spans a two week period. Example: a single entry has been added on the 10th day of the month. The event starts on the 10th and ends on the 24th. What I would like to accomplish is display that event when the current day is between the 10th and the 24th. I hope that makes sense. Do you have any ideas on how to do this?
thank you Rebecca, how can I also display all the overdue and upcoming tasks in the blank area? or even a pie chart shows each status of all the tasks?
Hi Rebecca, thanks for this! I’ve added a function where users are able to add an event to their outlook calendar. However, when an item is updated in the underlying SharePoint after the fact, I can’t seem to figure out how to communicate that change to the users who already added the event. I was hoping maybe you’d have an idea!
This is awesome, I am new to this and needing to select items for checkout from a Sharepoint list and then be able to make sure that if it was checked out then another user could not check it out also. You make this look so easy but I have used the calendar function but I really like the way you have it setup more. Any help would be appreciated.
For checking in and out I often use “hidden” status columns that can only be filtered and changed by actions within the app. I normally just use a single line text field for it so it gives me flexibility. Then you can have in your gallery the ability to check out disabled if that status shows it has already been checked out. We also use several different apps for approval process that I use this same setup for where I have a column for “assigned to” so if it isn’t currently assigned to the user they can’t modify it. Best of luck..so much can be done with this and I use mostly sharepoint for mine. It is there and already included at no additional cost! :-)
@@kevssignsngraphics so an example of how I use is when a job is closed it is “assigned to” the department manager. I have a people field for the manager of the job and so the gallery looks to see if the user is the manager listed and the assigned to is “Manager” and if it is he/she can click the approve button or edit. When they do then it is assigned to upper management so then only those people can edit or approve an item. They can also return the item which assigns back to manager if they need to. I use the column of assigned to to decide who can edit items but I also use other factors. At manager level it is a people field that is set up when initiated but upper levels the department decides who can and cannot edit or approve an item. I hope this helps.
@@rebeccasackett6472 Thank you for the replies, I am wondering what kind of programming background you had previous to doing the PowerApps? I am struggling to make some of these apps and just need to figure out what training I might need to get me up to speed per-say. I have been in IT over 30 years and find PowerApps amazing to do these apps but just trying to put everything together is a whole another thing.LOL This Calendar checkout seems pretty simple and I have equipment in a SP and you just select what your going to checkout, but the user can come in and select the same items in the SP list. I just need a way for them to see what is already checked out and then displayed on who has it checked out so another use cannot check it out also. I really appreciate you taking the time to reply.
Thanks! I followed every step and could make it possible. I was wondering if there is a way to block the days that appear already with an event registered in the calendar? So that none else can put an event on a day that has one already.
Yeah, there are several different ways you could do that. You could have an icon in the calendar that is a "+" or something that is visible when they click on a date but make it disabled if something is already scheduled then. There are a lot of ways you could do that...just depends on your need and how you want to do it.
Thanks for the video, can you also use the common data service as a data source the same way? I did try but I had some issues and the dates were coming up as completely different dates so I tried this way and it worked fine. If you can think of anything to look and have the time that would be great. Thanks
Bradly Stewart I haven’t really used CDS, I work for a smaller company so just haven’t had the need. I did do one like this that was pulling from SQL and it worked basically the same but a few differences. I’ll look back at it and see what the differences were and maybe it can help u work through some ideas.
Check out my latest video. It goes into way more details on the set-up. I just realized you commented on the older one. czcams.com/video/NFPaCqYSpUs/video.html
I know this is old, but I would like to build this with the ability to switched between different Sharepoint lists (dropdown). is there a way to do that?
yes, it would really be just an if statement. Something like (on the items of the gallery)... If(Dropdown1.Selected.Value = "List 1", Filter(List1, filter criteria), Filter(List2, filter criteria)) or you could use switch for the same concept. I normally do If statement if just two options and switch if there are more than two but either will do.
Hi Rebecca, how do i break my schedule to hours within the day let say i want to make appointment for mr A from 8am till 2pm and mr B 2.30 - 5pm working hour is from 8 - 5pm.
Two ways u cld do this. One is u can allow for a start date/time and end date/time. Second is u cld just have the start date/time and then duration and display the end based on a calculation for the start plus duration. I’ve tried it both ways and really don’t have a preference.
Hi Rebecca , How can I avoid the delegation warning? My list has over 5000 items, I have manually increased the limit to 2000 but that wont help. Any suggestions on how the delegation warning can be solved ?
Nice video here, I am impress. Just one question. How do I submit the data to sharepoint and an outlook calendar using datepickers for start and end date?
You could create a Flow (PowerAutomate) to do that. Have a date column on your SP List and when an item is created have a Flow that runs and creates the outlook event.
@@rebeccasackett6472 nice reply. OK I tried that now but the date and time sharepoint columns for the start and end date are not showing from the list of dynamic content so I can select them into the calendar start and end box.
@@utoroprincewill7808 what is your trigger? When an item is created or something else? You might have to do inside an 'Apply to each' if you are using the 'Get items' instead of just 'Get item'.
@@rebeccasackett6472 my trigger is just when an item is created. I noticed that in the dynamic content listing only single line text columns are showing up and not the date and time columns. What I want to achieve is when an item is created in the list also create an outlook calendar.
@@utoroprincewill7808 I just did a test on my end and can see my date/time column under Dynamic content. You might try saving it, getting out and then go back into edit mode. Also might check you if you have a see more option in the dynamic content. I will mention also that I don't like the 'Create event' action in Flow because there is not a good way of doing it with no reminder set. It is a big complaint for it. If you are okay with that then you should be good but if you are not you might want to research all the "work around" options for it. I have not found one I like...which is why I keep my stuff in PowerApps instead of Outlook on a lot of data I have.
Hi Rebecca, Have you been able to display all instances of a recurring event from a SharePoint calendar list in PowerApps? I only get the master event.
I haven't really used the SharePoint calendar much...this example here (which is most of what I do) is for a simple SharePoint List that has a date column in it. So...mine doesn't allow for a Recurrence to look for. I would like to try a few test to weigh my options between using the SharePoint Calendar and a SharePoint List and compare the two. So, when I do I will make sure to check out out the options with the Recurrence and let you know what I find or maybe make a quick video on it.
Usually holding down alt puts it into "Play mode" (that is what I call it). Did you open it where it is not in edit mode and see if you still have to click the alt key? There are a few things that don't work right in Edit mode (Exit() is one of them also).
Rush Davis-Hall awesome! Keep in mind that u will also need on the button that brings u to that screen a ResetForm();NewForm() to let u start over new again each time
Thanks Rebecca! Great tutorial. How did you get round the delegation warning though?
Wow, I thought this screen was just for Outlook calendars, now that I know it can connect to other data such as SharePoint lists it will definitely be very useful, thanks for helping me understand! ;-D "Just drag" for cranky position dependency re-sets is another great tip, I will pass that on.
Thanks Rebecca. I'm trying to connect to a calendar on my sharepoint site, but it doesn't show up as a potential data source. In the video are you connecting to a sharepoint calendar or a regular list with date fields?
Brilliant example and excellent training. Well done
EXTREMELY HELPFUL!!! Thank you Rebecca!!!
Thank you, so much, for this video. So excited to share with my colleagues.
Congratulations on the very good video, suggestion to put in the description some commands that you use in the video, it helps in learning.
Hi Rebecca. Great video demonstration. Two questions:
How do I make the circle stretch to include a multi day event? Circle 1 icon is just for the start date.
In my data source I have a column for event type. How do I filter my data source using a combobox with distinct, need multi-select ability?
Hi Rebecca,
Thank you for the video. It helped me .
On screen visible all my dates are as 0 when i click next arrow and come back it is showing 1 2 3 on screen visible it is showing as 0 in all dates not sure where i did wrong
Also is there a way to show records based on date range like from and to
Superb video! Thanks very much!
Thank you so much. God bless you.
I have 'Days' as a invalid argument. Is a name of a SharePoint list column?
Hey Rebecca, I have created a monthly calendar based on one of your previous YT tutorials, which works a dream, but the end users want a different view similar to this one above, but instead of a monthly view, with a back forward/forward monthly. They have asked if it is possible to change this, based on this calendar screen to a yearly scroll and display the 12 months below, and by selecting the month display in a gallery list on the right hand side all the scheduled audits for that particular month?
Great work and easy to follow tutorial.
GREAT TUTORIAL! THANKS ALOT!!! SAVED LIVES!!
This was great thank you! Helped a lot
Very informative. Bookmarking this one. Thanks.
Hi Rebecca - great video and I was able to successfully implement your example, so thank you! I was wondering if you have a video on how to show event information that spans a two week period. Example: a single entry has been added on the 10th day of the month. The event starts on the 10th and ends on the 24th. What I would like to accomplish is display that event when the current day is between the 10th and the 24th. I hope that makes sense. Do you have any ideas on how to do this?
thank you Rebecca, how can I also display all the overdue and upcoming tasks in the blank area? or even a pie chart shows each status of all the tasks?
This is fantastic! Thank you!
Hi Rebecca, thanks for this! I’ve added a function where users are able to add an event to their outlook calendar. However, when an item is updated in the underlying SharePoint after the fact, I can’t seem to figure out how to communicate that change to the users who already added the event. I was hoping maybe you’d have an idea!
Looking for way to create the "Recurring Events" feature.
AND a reason WHY microsoft decided calendars weren't needed in SPO.
Hi guys, The datescheduled variable is not working in the updated version of power apps...Can someone help me with this please ?!
Hi Rebecca, very good tutorial, but I have problem with the navigation from month to month it's very
slow
This is awesome, I am new to this and needing to select items for checkout from a Sharepoint list and then be able to make sure that if it was checked out then another user could not check it out also. You make this look so easy but I have used the calendar function but I really like the way you have it setup more. Any help would be appreciated.
For checking in and out I often use “hidden” status columns that can only be filtered and changed by actions within the app. I normally just use a single line text field for it so it gives me flexibility. Then you can have in your gallery the ability to check out disabled if that status shows it has already been checked out. We also use several different apps for approval process that I use this same setup for where I have a column for “assigned to” so if it isn’t currently assigned to the user they can’t modify it. Best of luck..so much can be done with this and I use mostly sharepoint for mine. It is there and already included at no additional cost! :-)
Posted this today with weekly view calendar:
czcams.com/video/eEB2RIyVuzg/video.html
@@rebeccasackett6472 can you give me a brief overview of this process?
@@kevssignsngraphics so an example of how I use is when a job is closed it is “assigned to” the department manager. I have a people field for the manager of the job and so the gallery looks to see if the user is the manager listed and the assigned to is “Manager” and if it is he/she can click the approve button or edit. When they do then it is assigned to upper management so then only those people can edit or approve an item. They can also return the item which assigns back to manager if they need to. I use the column of assigned to to decide who can edit items but I also use other factors. At manager level it is a people field that is set up when initiated but upper levels the department decides who can and cannot edit or approve an item. I hope this helps.
@@rebeccasackett6472 Thank you for the replies, I am wondering what kind of programming background you had previous to doing the PowerApps? I am struggling to make some of these apps and just need to figure out what training I might need to get me up to speed per-say. I have been in IT over 30 years and find PowerApps amazing to do these apps but just trying to put everything together is a whole another thing.LOL This Calendar checkout seems pretty simple and I have equipment in a SP and you just select what your going to checkout, but the user can come in and select the same items in the SP list. I just need a way for them to see what is already checked out and then displayed on who has it checked out so another use cannot check it out also. I really appreciate you taking the time to reply.
Can you post the Screen OnVisible formula? I can't make out the what you typed in....quality is blurry
You are a Star !
Are you using a regular SharePoint list or a SharePoint Calendar as a data source?
I need to know this
Thanks! I followed every step and could make it possible. I was wondering if there is a way to block the days that appear already with an event registered in the calendar? So that none else can put an event on a day that has one already.
Yeah, there are several different ways you could do that. You could have an icon in the calendar that is a "+" or something that is visible when they click on a date but make it disabled if something is already scheduled then. There are a lot of ways you could do that...just depends on your need and how you want to do it.
Thanks for the video, can you also use the common data service as a data source the same way?
I did try but I had some issues and the dates were coming up as completely different dates so I tried this way and it worked fine.
If you can think of anything to look and have the time that would be great.
Thanks
Bradly Stewart I haven’t really used CDS, I work for a smaller company so just haven’t had the need. I did do one like this that was pulling from SQL and it worked basically the same but a few differences. I’ll look back at it and see what the differences were and maybe it can help u work through some ideas.
I fuckxng love you girl, you saved me
Thank you for the video! How did you get the date selected to change based on what date is selected?
Sujay Sooknanan towards the end of the video u will see the code I put on the OnSelect of the three things inside the gallery will show u
Check out my latest video. It goes into way more details on the set-up. I just realized you commented on the older one.
czcams.com/video/NFPaCqYSpUs/video.html
Thanks crack!
I know this is old, but I would like to build this with the ability to switched between different Sharepoint lists (dropdown). is there a way to do that?
yes, it would really be just an if statement. Something like (on the items of the gallery)... If(Dropdown1.Selected.Value = "List 1", Filter(List1, filter criteria), Filter(List2, filter criteria)) or you could use switch for the same concept. I normally do If statement if just two options and switch if there are more than two but either will do.
Hi Rebecca, how do i break my schedule to hours within the day let say i want to make appointment for mr A from 8am till 2pm and mr B 2.30 - 5pm working hour is from 8 - 5pm.
Two ways u cld do this. One is u can allow for a start date/time and end date/time. Second is u cld just have the start date/time and then duration and display the end based on a calculation for the start plus duration. I’ve tried it both ways and really don’t have a preference.
Thanks!
This is cool stuff
Hi Rebecca , How can I avoid the delegation warning? My list has over 5000 items, I have manually increased the limit to 2000 but that wont help. Any suggestions on how the delegation warning can be solved ?
I am having the same issue. Did you address the limit issue?
Nice video here, I am impress. Just one question. How do I submit the data to sharepoint and an outlook calendar using datepickers for start and end date?
You could create a Flow (PowerAutomate) to do that. Have a date column on your SP List and when an item is created have a Flow that runs and creates the outlook event.
@@rebeccasackett6472 nice reply. OK I tried that now but the date and time sharepoint columns for the start and end date are not showing from the list of dynamic content so I can select them into the calendar start and end box.
@@utoroprincewill7808 what is your trigger? When an item is created or something else? You might have to do inside an 'Apply to each' if you are using the 'Get items' instead of just 'Get item'.
@@rebeccasackett6472 my trigger is just when an item is created. I noticed that in the dynamic content listing only single line text columns are showing up and not the date and time columns. What I want to achieve is when an item is created in the list also create an outlook calendar.
@@utoroprincewill7808 I just did a test on my end and can see my date/time column under Dynamic content. You might try saving it, getting out and then go back into edit mode. Also might check you if you have a see more option in the dynamic content. I will mention also that I don't like the 'Create event' action in Flow because there is not a good way of doing it with no reminder set. It is a big complaint for it. If you are okay with that then you should be good but if you are not you might want to research all the "work around" options for it. I have not found one I like...which is why I keep my stuff in PowerApps instead of Outlook on a lot of data I have.
Hi Rebecca,
Have you been able to display all instances of a recurring event from a SharePoint calendar list in PowerApps? I only get the master event.
I haven't really used the SharePoint calendar much...this example here (which is most of what I do) is for a simple SharePoint List that has a date column in it. So...mine doesn't allow for a Recurrence to look for. I would like to try a few test to weigh my options between using the SharePoint Calendar and a SharePoint List and compare the two. So, when I do I will make sure to check out out the options with the Recurrence and let you know what I find or maybe make a quick video on it.
@@rebeccasackett6472 Thanks for this tutorial; i will be waiting for the test using SharePoint Calendar.
How about putting the code from 1:36 in the video description...
I actually did some clean up on how this is done and created a new video on this back in March.
czcams.com/video/NFPaCqYSpUs/video.html
App - OnStart =
Set(_CurrentDate, Today())
------------------------------------------------------------------------------------------------------------------
Screen - OnVisible =
Set(_DateSelected, _CurrentDate);
Set(_FirstDayofMonth, DateAdd(_DateSelected,1 - Day(_DateSelected), Days));
Set(_FirstDayInView, DateAdd(_FirstDayofMonth, -(Weekday(_FirstDayofMonth) - 2 + 1), Days));
Set(_LastDayofMonth, DateAdd(DateAdd(_FirstDayofMonth, 1, Months), -1,Days));
Set(_MinDate, DateAdd(_FirstDayofMonth, -(Weekday(_FirstDayofMonth) - 2 + 1),Days));
Set(_MaxDate, DateAdd(DateAdd(_FirstDayofMonth, -(Weekday(_FirstDayofMonth) - 2 + 1), Days), 35,Days))
------------------------------------------------------------------------------------------------------------------
Prev Month Icon - OnSelect =
Set(_FirstDayofMonth, DateAdd(_FirstDayofMonth, -1, Months));
Set(_FirstDayInView, DateAdd(_FirstDayofMonth, -(Weekday(_FirstDayofMonth) - 2 + 1), Days));
Set(_LastDayofMonth, DateAdd(DateAdd(_FirstDayofMonth, 1, Months), -1,Days));
If(_MinDate > _FirstDayofMonth, Set(_MinDate, _FirstDayofMonth))
------------------------------------------------------------------------------------------------------------------
Next Month Icon - OnSelect =
Set(_FirstDayofMonth, DateAdd(_FirstDayofMonth, 1, Months));
Set(_FirstDayInView, DateAdd(_FirstDayofMonth, -(Weekday(_FirstDayofMonth) - 2 + 1), Days));
Set(_LastDayofMonth, DateAdd(DateAdd(_FirstDayofMonth, 1, Months), -1,Days));
If(_LastDayofMonth > _MaxDate, Set(_MaxDate, _LastDayofMonth))
------------------------------------------------------------------------------------------------------------------
Label in Gallery - Show Date Value (Day) - Text =
Day(DateAdd(_FirstDayInView, ThisItem.Value, Days))
------------------------------------------------------------------------------------------------------------------
Gallery - any items - Select Day in Gallery - OnSelect =
Set(_DateSelected, DateAdd(_FirstDayInView, ThisItem.Value, Days))
When I play my app it says on the form "No item to display" do you know the reason for this? It works fine when I hold alt.
Usually holding down alt puts it into "Play mode" (that is what I call it). Did you open it where it is not in edit mode and see if you still have to click the alt key? There are a few things that don't work right in Edit mode (Exit() is one of them also).
@@rebeccasackett6472 I found a fix. I had to go into the form and put the default mode as "new". Then it works perfectly.
Rush Davis-Hall awesome! Keep in mind that u will also need on the button that brings u to that screen a ResetForm();NewForm() to let u start over new again each time
went way too fast...
We'll just have to pause and rewind a lot.
Slow down!
I have problem with the navigation from month to month it's very
slow
I am getting error while writing this code due to dateAdd function
Set(_firstDayOfMonth, DateAdd(Today(), 1 - Day(Today()), Days));
Set(_firstDayInView, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1 ), Days));
Set(_lastDayOfMonth, DateAdd(DateAdd(_firstDayOfMonth, 1, Months), -1, Days));
Set(_minDate, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1 ), Days));
Set(_maxDate, DateAdd(DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1 ), Days),40,Days))
try
Set(_firstDayOfMonth, DateAdd(Today(), 1 - Day(Today()), TimeUnit.Days));
Set(_firstDayInView, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1 ), TimeUnit.Days));
Set(_lastDayOfMonth, DateAdd(DateAdd(_firstDayOfMonth, 1, TimeUnit.Months), -1, TimeUnit.Days));
Set(_minDate, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1 ), TimeUnit.Days));
Set(_maxDate, DateAdd(DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1 ), TimeUnit.Days),40,TimeUnit.Days))
Hi, have you find a solution ?
Yes it got resolved
@@NerdIntern How did you resolve it?
@@navyjax2 i used a different logic