Using Calendars with Power Apps Not PowerApps Calendars

Подписаться 9 тыс.

Просмотров 18 тыс.

50% 1

Many people are recreating calendars completely in PowerApps. You can create a SharePoint Form with PowerApps much quicker. This video shows you how fast you can do that.
Part 2 with Calendars and Power Apps: • Create Meeting in Powe...
Add to My Outlook Button:
Office365Outlook.V2CalendarPostItem(varMyCalendar,DataCardValue1.Text,DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0),DateValue2.SelectedDate + Time(Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value), 0), {Importance:"Normal",ShowAs:"Busy"});
Yes Button:
Office365Outlook.V2CalendarPostItem(varMyCalendar,DataCardValue1.Text,DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0),DateValue2.SelectedDate + Time(Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value), 0), {Importance:"Normal",ShowAs:"Busy"});
UpdateContext({varPopUp:false});
SubmitForm(SharePointForm1);
Exit();
App Startup Property:
Collect(CalendarLocalizedLabel, {Value:"Calendar"},{Value:"Kalender"},
{Value:"Təqvim"},{Value:"Kalendar"},{Value:"Calendari"},{Value:"Kalendář"},{Value:"Calendr"},{Value:"Calendario"},
{Value:"Egutegia"},{Value:"Kalendaryo"},{Value:"Calendrier"},{Value:"Féilire"},{Value:"Am mìosachan"},{Value:"Kalanda"},
{Value:"Dagbók"},{Value:"Kalenda"},{Value:"Kalendārs"},{Value:"Kalenner"},{Value:"Kalendorius"},{Value:"Naptár"},
{Value:"Kalendarju"},{Value:"Agenda"},{Value:"Taqvim"},{Value:"Kalendarz"},{Value:"Calendário"},{Value:"Intiwatana"},
{Value:"Kalendari"},{Value:"Kalendár"},{Value:"Koledar"},{Value:"Kalenteri"},{Value:"Maramataka"},{Value:"Lịch"},
{Value:"Takvim"},{Value:"Senenama"},{Value:"Ημερολόγιο"},{Value:"კალენდარი"},{Value:"לוח שנה"},{Value:"کیلنڈر"},
{Value:"التقويم"},{Value:"कैलेंडर"},{Value:"दिनदर्शिका"},{Value:"ক্যালেন্ডার"},{Value:"કૅલેન્ડર"},{Value:"予定表"},
{Value:"行事曆"},{Value:"日历"},{Value:"క్యాలెండర్"});
Set(varMyCalendar, LookUp(Office365.CalendarGetTables().value, DisplayName = LookUp(CalendarLocalizedLabel,Value=DisplayName).Value).Name);

Опубликовано:

5 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 54

@imran002ali 9 месяцев назад

Hi Andrew, I can't believe, in 17 minutes, you have provided such great information. This is AWESOME 👍👍 and thank you for sharing knowledge!! 😊

@andrewhess123 9 месяцев назад

Thank you for watching Imran!!

@viaMikeLawson Год назад

Thanks Andrew! God bless your home

@andrewhess123 Год назад

Thank you Michael! Same to you!

@saschageng5747 2 года назад

Hi, very interesting. Just one recommendation: as a viewer that uses iPad to watch videos certain parts are difficult to see. Zooming on content you are talking about would make it better to understand.

@andrewhess123 2 года назад

Thanks Sascha, I appreciate the feedback. I'll see if I can figure something out :)

@donghonggu6882 2 года назад

I have the same problem even using computer to view. Once I changed the setting to increase the Quality, I can see it clearly.

@andrewhess123 2 года назад

@@donghonggu6882 Yeah, I am working on making my videos better, but should be able set it all the way up to 4K

@lucaslegz 10 месяцев назад

Thank you for a great video. You came up on my feed as I was looking to create a form and app that would allow someone to choose a meeting time from a list on the form and have the app automatically add that meeting to a calendar. Hope that makes sense. Oh, and not my calendar but a calendar that I am a delegate for. Have you ever done something like that?

@andrewhess123 9 месяцев назад

Hi Lucas, So you have to be careful when doing this because you need permissions to their calendar. It's a security thing. I have tried a few different ways but that will be one roadblock that you will run into. It is possible though

@vipersip9349 Год назад

Hi and is it possible to add other people, send an email invitation to a meeting with the option of accepting or rejecting?

@andrewhess123 Год назад

This sounds like it's possible, I did see a Shane Young video where he had some options in his email that triggered Power Automate in different ways. Not sure of the exact video it was though.

@donghonggu6882 2 года назад

How come I don't have the "Integrate->Power App" option in SP? Is that a permission issue?

@andrewhess123 2 года назад

I would guess this is a permission issue. I'm not sure why you would not see it. I would ask your admin.

@radhikaM914 2 года назад

Thank you for simplifying the "Calendar View" using Power Apps. Really appreciate simplicity. When I view my calendar event, it is not rendering the Power App form. Is this expected behavior? or should we create view form, edit form and new form and bind it to Calendar accordingly?

@andrewhess123 2 года назад

Hi Radhika, it should render the Power Apps form on the view event also. Not sure what's going on there.

@rauseomo Год назад

Thanks you so much buddy!! and thanks a lot for sharing a lot info :)

@AndreaRavasio-dk9hr 5 месяцев назад

hi Andrew, This video is very useful. I was just doing a similar thing for a need of ours and I wanted to ask you how you could, before saving the record in SP, check if that slot is already occupied. example: in the SP list I already have a record that has as startdate today at 10:00 and as endate always today at 11:00. I would like that if I tried to enter a record with Starddate today at 10:15 the power app would block me! I was trying to launch a power automate flow to which I pass the start date and the end date and then this flow, through a getitems actions on the sharepoint list, checks if there are already records in that time slot; Then I would have Power Automate return the result of the check to the Power App and block the save in case of overlap. How would you do this check? Thank you very much!

@andrewhess123 3 месяца назад

Hi Andrea, sorry for the late reply, but to do this I would probably write to Outlook instead and then do this example. Outlook has some out of the box functionality that already does this. I have used the "Book a room" template that Microsoft has to figure out how they do this. How you would do that in SharePoint could become much more complicated because of the way SharePoint writes to the back end. When people Take off between 5/12 - 5/15, it doesn't write each instance to SharePoint just the start and end time. There could be ways around this issue but it would not be an easy straight forward answer. Hope this helps some.

@AndreaRavasio-dk9hr 3 месяца назад

@@andrewhess123 Hi Andrew, in the meantime I managed to do something with a power automate flow: it works very well with events that "consume" themselves over the course of a day. In this case I have 4 parameters (new appointment start date, new appointment end date and busy slot start date and busy slot end date) and it was not difficult to create a condition in the flow. The problem now is to do the same thing with appointments that last whole days and I'm seeing it right now. Thank you

@andrewhess123 3 месяца назад

@@AndreaRavasio-dk9hr Hi Andrea, Interesting and thank you for sharing how you are doing this.

@rauseomo Год назад

Hi andrew, thanks a lot for your videos, I have a question its possible add a new app calendar and when you click new element edit all that information? I think I found it but looks complicated. Regards

@andrewhess123 Год назад

Hi Luis, I think what you are asking is possible yes. If you can explain more, but yes you can add a new calendar app and click new element and add that information.

@rauseomo Год назад

@@andrewhess123 yes, add new I got it. I mean what I need is edit the default fields in that new element, like put a logo, add 2 more custom boxes.

@andrewhess123 Год назад

@@rauseomo Hi Luis, totally possible to do. Think of Power Apps like a white sheet of paper. You can totally customize it. Power Apps can be a little intimidating at first, but it is made for what is called "citizen developers" after a few weeks/months of practice, I'm sure you can get it!

@acostaae90 2 года назад

Would there be a way to create a powerapps that shows a traditional exchange calendar or office resource calendar? We have a sharepoint page that users use like intranet, they want to be able to add a widget or powerapps that displays normal office365 user/resource/ shared mailbox calendars, Sharepoint only allows you to add group calendars, but I am wondering if one could create a powerapps that pulls the resource calendar or user calendar (with permissions obviously)?

@andrewhess123 2 года назад

Hi Andres, I'm not sure about this one, I have not done this.. but if you take a look at this template, it connects to Microsoft Graph/User Data. It would be difficult to do what you're looking for.. but, Check out this tutorial from Microsoft they have a calendar that they made and they pull in room data... it could be possible to get what you're looking for. If you go to PowerApps and load from a template you can also find this.. powerapps.microsoft.com/en-us/blog/office-template-book-a-room-now-available/

@nocodecreative 2 года назад

I just cannot get this to work, error on the OnStart "unsupport function", then the in sharepoint there are errors with the table

@andrewhess123 2 года назад

Hi Wayne, I would need more information to help you.

@marieclifford5267 Год назад

Hi Andrew, I think this video could be the answer to my prayers, but I'm really struggling to get this to work. When I copy/paste the Collect Calendar formula from the template (just as you did) PowerApps tells me there are all sorts of errors with it! e.g. "CalendarGetTables is an unsupported function in Office365". I'm new to all this, any ideas?

@marieclifford5267 Год назад

PS CalendarGetTables_V2 doesn't work either

@andrewhess123 Год назад

Hi Marie, did you add the data source for O365 to the Power App?

@marieclifford5267 Год назад

Really appreciate your replies. I did get this to work eventually (and yes, added the data source). Not entirely sure why some things don’t work and then magically they do, but usually stepping away and coming back later helps 😂

@andrewhess123 Год назад

@@marieclifford5267 For sure! That's always the trick, take a nice walk and forget about the issue... and then pooof! It'll just come to you

@bryanstark324 2 года назад

I think this is a cool idea, but my coworkers will tell me, "why are you doing that when Outlook already creates appointments on the calendar?" So what is the justification for using powerapps and sharepoint to make appointments or meetings in Outlook?

@andrewhess123 2 года назад

To run Power Automates on calendar events that can do various things, to color code calendars automatically, to apply other metadata to calendar events, like checking out equipment or vehicles.. To run approval flows on calendar events, for approval processes. To share calendars externally with other clients/customers. To apply certain permissions/views to calendars.. to attach files to calendar events and store them in SharePoint, Just a few reasons I thought of off the top of my head... I don't think SharePoint calendars are the best, but options are available and I'm sure Microsoft will push out more content for calendars. The main reason though is Power Automate + SharePoint + Calendars.

@bryanstark324 2 года назад

@@andrewhess123 I will try to learn more. Thank you for taking time to teach this.

@andrewhess123 2 года назад

@@bryanstark324 Thanks Bryan, SharePoint is just another tool for your toolbox. Just use the right tool for the right job, there are calendars in Planner, MS Project, Outlook, SharePoint, Power Apps, SP 2013 Task lists, and even new ones in MS Lists.

@amaralgi 2 года назад

Hey, thanks for all your content, I have been learning a lot with your videos! Also, I got one question, what if I wanted to prevent others to schedule meetings at same time of the ones which are already in the list? I am not sure how to set a formula and maybe come up with a pop up saying that the specific time is not available... Or offer buttons to the user book meetings only with the times that are available for that day. I believe the MS template uses something similar with buttons but I couldn't understand, it's a bit complex for me yet. Cheers!

@andrewhess123 2 года назад

Hi Gisele, Thanks for watching the videos, hope they are helpful. You are right the MS template is very complex how it stops people from setting up meetings at the same time. I'll have to look into this one more, to get you the exact answer. The pop up part though, I have done something similar in a video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W_C7Bgm5K5U.html&t I'll see if I can break down the part where the template doesn't allow meetings on the same day. Thanks Gisele!

@amaralgi 2 года назад

@@andrewhess123 many thanks Andrew! I will take a look at your video 👍

@carvalho_sau 2 года назад

Hey Giselele, did you get how not allow two people to schedule at the same time? I'm having the same problem haha

@andrewhess123 2 года назад

@@carvalho_sau yeah that's a tough one, I gotta get back to this one. I'll get back to it, gotta figure it out too.

@amaralgi 2 года назад

@@carvalho_sau as Andrew said, this was a tough one, but I could figure it out after a while. It's a bit complex to show here, but you can send me a message through LinkedIn and I would be happy to share. Unfortunately later on I got another requirement from users in this calendar solution: when you click in the "+ new" button in the calendar date it doesn't bring specifically the day you clicked new, only a "default date", which confuses users a bit. The thread below talks about it - towards the end specifically. And sadly I couldn't figure out how to fix it: techcommunity.microsoft.com/t5/power-apps-power-automate/powerapps-form-default-date-as-selected-date-from-calendar-view/m-p/2943342

@JPPVCC Год назад

Dude! Freaking awesome

@andrewhess123 Год назад

Thanks JP! You TOO 😁

@nandonando4421 Месяц назад

can this handle recurrence? How?

@andrewhess123 Месяц назад

You will need to calculate recurrence yourself. There are date formulas.

@christopherlawes9286 2 года назад

When you click on a date on the SP calendar how do you get that to be the selected date in the date picker?

@andrewhess123 2 года назад

Hi Christopher, I have not been able to successfully do that yet. I will research some more, but so far, I do not think that is possible. You can set the default date to Today() though. Let me know if you figure it out also :)

@marieclifford5267 Год назад

One more thing, how do I get the PowerApp to appear when you click +New in SharePoint? I used the Integrate/PowerApps to create the Customized Form, saved and published, but it does not appear when I create a new event.

@andrewhess123 Год назад

It should save, but you can always go to List Settings > Form Settings, and make sure Use a custom form created in PowerApps is selected.