cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KGuthrie-NF
Helper I
Helper I

Power Apps with Power Automate flow to add Calendar event

Hello all,

I am just learning how to use all the Microsoft Power 'stuff'.  I followed an online guide to create a vacation request Power App with the data stored in a Sharepoint List.  That part is working great.  It also notifies the user's manager of the request with approval.  The guide I followed is here.  I am trying to take it one step more by adding a calendar event on the submitter's calendar with the vacation request.  After some digging it seems like the best way is to use a "Get calendars (V2)" block.  The array that is generated from that is then filtered in a for each to look for the "Calendar" calendar and then create the event on that calendar.  Everything with the creation of the event works.

 

The problem I am having is no matter the user who submits the request, the calendar event ALWAYS ends up on my calendar, not theirs.  

 

KGuthrieNF_3-1653581506322.png

 

KGuthrieNF_4-1653581523545.png

 

KGuthrieNF_5-1653581543903.png

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @KGuthrie-NF 

 

Depending on what you want to do with the Calendar event, you can also just create it directly from PowerApps too.  There is an Outlook Connector - Office365Outlook.

 

DamoBird365_0-1653594124244.png

 

It can be called with the following expression:

 

Office365Outlook.V4CalendarPostItem("Calendar","This is a calendar event created from PowerApps","2022/05/26 09:00","2022/05/26 17:00","(UTC+00:00) Dublin, Edinburgh, Lisbon, London")

 

This would mean that you do not need PowerAutomate.  I have run this solution as another user and it creates the calendar event in their calendar.

 

Failing that, if you want to use PowerAutomate, use the PowerApps V2 Trigger 

 

DamoBird365_1-1653594282704.png

The flow connector will run as user:

DamoBird365_2-1653594400532.png

Make sure you update the calendar name in flow with a custom value "Calendar" or you will get an error.

 

Cheers,

 

Damien

View solution in original post

15 REPLIES 15
DamoBird365
Employee
Employee

Hi @KGuthrie-NF 

 

You want the action to run in the context of requesting user.  The easiest way to do this is to change run only permissions but that can only be done if the trigger is in the context of the user.  When an item created is in the context of the flow owner - i.e. you.  Could you change the flow trigger to be from PowerApps using the V2 trigger?  Then you would create the item via this flow.  This would also allow you to run the calendar action in the context of the user and it would therefore be in their calendar.

 

DamoBird365_0-1653582253439.png

 

Manage owners and users in your Microsoft list flows with Power Automate | Microsoft Docs - specifically run only users.

 

Damien

 

So I have been looking into this solution, however, it won't work for this application.  I have even tried to modify your solution by using the PowerApps V1 trigger.  

I also am not seeing the run-only permissions card.

Hi @KGuthrie-NF 

 

It would have to be v2. Can you explain why it won’t. Is it an error or something else that needs overcome?

 

Damien

I guess the biggest reason is the ability to track the user vacations in a SharePoint list.  Currently, they enter the details in a PowerApp.  The Submit button adds the values to the list, then this triggers the flow.  

 

KGuthrieNF_0-1653590146862.png

Can the same thing still be accomplished with PowerApps v2?

 

Hi @KGuthrie-NF 

 

Is this a patch or a form or all done via a flow? You could just have a flow that creates the event. You might even be able to create the event straight from PowerApps too. I would need to check.

 

Damien

I'm not sure what you mean. 


Is this a patch or a form or all done via a flow?


The idea was to create a simple way for users to request vacation from our SharePoint site.  I may be overcomplicating it, but the users don't want to do another step of creating the vacation on their calendars once it is approved.  

 

So the current process I am trying to get working...

1.  Open a Power App.

2.  Enter info for vacation.

3.  Press Submit

    a. The button action is to submit the form to the SharePoint list that holds all the data.

    b. The creation of a new item triggers a flow to start the approval process

        i. First the flow gets the user that created the new item on the list.  

        ii. Based on the user a manager is found for the approver.

        iii.  A calendar item is created on the submitter's calendar as a "tentative" event.

        iv.  An approval is started

        v.  Based on the approval the calender even is changed to out of office or deleted.

        vi. Based on the approval an email is sent to the submitter stating if the vacation was approved or rejected.

 

Hi @KGuthrie-NF 

 

You’ve got a PowerApps form 👍 you can call a flow when the form submits.  That flow could create the event in the calendar and run in the context of the app user.

Damien

Yes.  That is what I am trying to do.  However, from what I can tell this needs to use SharePoint V1 trigger.  Right?

@KGuthrie-NF you’ll need to use the PowerApps trigger v2. If you’re not sure I can try and put together a proof of concept. Built ultimately you swap out the existing trigger for when an item is created and instead run the flow directly from the submit button. This will allow the flow to run as your user and not as you.

 

Damien

KGuthrie-NF
Helper I
Helper I

I think I have something like that...  

 

KGuthrieNF_0-1653592912742.png

 

Hi @KGuthrie-NF 

 

Nearly, you could still have the form create the item when you submit. The flow just needs to do the outlook bit. Then you’ve still got the list item you want. So from the image above, drop the create item action. If there is data you need to capture from the list item, you can use get item and pass the item id to the flow.

 

Damien

Hi @KGuthrie-NF 

 

Depending on what you want to do with the Calendar event, you can also just create it directly from PowerApps too.  There is an Outlook Connector - Office365Outlook.

 

DamoBird365_0-1653594124244.png

 

It can be called with the following expression:

 

Office365Outlook.V4CalendarPostItem("Calendar","This is a calendar event created from PowerApps","2022/05/26 09:00","2022/05/26 17:00","(UTC+00:00) Dublin, Edinburgh, Lisbon, London")

 

This would mean that you do not need PowerAutomate.  I have run this solution as another user and it creates the calendar event in their calendar.

 

Failing that, if you want to use PowerAutomate, use the PowerApps V2 Trigger 

 

DamoBird365_1-1653594282704.png

The flow connector will run as user:

DamoBird365_2-1653594400532.png

Make sure you update the calendar name in flow with a custom value "Calendar" or you will get an error.

 

Cheers,

 

Damien

KGuthrie-NF
Helper I
Helper I

Thank you for your help!  

I was able to get it working.  It is also MUCH easier to follow than the last go-around I was attempting.   I ended up using the PowerApps (V2) in a flow that does all the heavy lifting.  

KGuthrieNF_0-1653599299887.png

 

KGuthrieNF_1-1653599310014.png

 



ppcb
New Member

Hello, 

I hope you are doing well. I've been tasked with a similar mission, mainly to let people ask for a remote work day, and let the manager approve or not. If the request is approved, then the calendar would be updated.

 

Would it be possible to ask for a screenshot of this flow in detail? I am sorry if it is a lot to ask, I can barely use power automate, much less power apps. 

 

Thank you anyway this post and the links have helped me quite remarkably already.

 

Kindest Regards

kelleyll23
New Member

@KGuthrie-NF 

I too would like to see the whole flow, I'm not a guru, just know enough to copy what others have figured out. 

Thank you!

Helpful resources

Announcements

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!    

Welcome to the Power Automate Community

You are now a part of a fast-growing vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun.   Now that you are a member, you can enjoy the following resources:   Welcome to the Community   News & Announcements: The is your place to get all the latest news around community events and announcements. This is where we share with the community what is going on and how to participate.  Be sure to subscribe to this board and not miss an announcement.   Get Help with Power Automate Forums: If you're looking for support with any part of Power Automate, our forums are the place to go. From General Power Automate forums to Using Connectors, Building Flows and Using Flows.  You will find thousands of technical professionals, and Super Users with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Automate community forums. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered. Galleries: The galleries are full of content and can assist you with information on creating a flow in our Webinars and Video Gallery, and the ability to share the flows you have created in the Power Automate Cookbook.  Stay connected with the Community Connections & How-To Videos from the Microsoft Community Team. Check out the awesome content being shared there today.   Power Automate Community Blog: Over the years, more than 700 Power Automate Community Blog articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on the future of process automation. In the Power Automate Community Blog, you can read the latest Power Automate-related posts from our community blog authors around the world. Let us know if you'd like to become an author and contribute your own writing — everything Power Automate-related is welcome.   Community Support: Check out and learn more about Using the Community for tips & tricks. Let us know in the Community Feedback  board if you have any questions or comments about your community experience. Again, we are so excited to welcome you to the Microsoft Power Automate community family. Whether you are brand new to the world of process automation or you are a seasoned Power Automate veteran - our goal is to shape the community to be your 'go to' for support, networking, education, inspiration and encouragement as we enjoy this adventure together.     Power Automate Community Team

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Users online (4,566)