I have created a holiday planner app in power apps using a SharePoint list. What I would like to do, is when the Approved column (in the SharePoint list) is updated to say "Approved", an event is scheduled in the person's Outlook calendar based on the 'Title' field matching the 'created by' field (please see the first image) I.e. the outlook calendar of whoever created the item.
The list is not synced to a SharePoint calendar. I have attached a screenshot of what I have tried so far, based on similar requests in this forum, and the error message that returns (Please see screenshot 2)
Any help or advice will be greatly appreciated.
The error is due to the invalid type to date field named LeaveDate. I suggest you convert the SharePoint date format and then pass the output to the Update action.
@NathanMowat you have an interesting flow. I recently created an approval flow which triggers when new PTO request is entered into MS Forms. Flow is triggered to initiate Approval from manager, upon approval create an item in SP list, send email to requestor and create event in Managers calendar (free, all day event) so that he has immediate visibility to any planned absences.
I'm curious in your scenario how the item changes from 'Pending' to either 'Approved' or 'Rejected'? I'm thinking that the Power App is used as the intake of information, an item is created on SP list which then triggers and Approval flow?
Firstly, thank you for your help I really appreciated it. I have converted my 'Leavedate' column in my SharePoint list to the format 'mm/dd/yyy hh:mm' so I am still wondering why the same error is being returned. Here's how my SharePoint list looks now and my flow.
Hi @PeggyLang ,
Thank you for your reply, I really appreciate it. Yes, you are correct, the Approve column is updated in the PowerApp. Basically, an employee logs in to the app, fills out a form, which then creates a item in the SharePoint list. Their manger gets a notification to approve/reject the request, which is done done within the app. So the part I'm stuck on is, when the list item is updated to read "Approved" the 'leave date & return date' is used to create an event in the person's (who created the request) outlook calendar. I'm interested in the flow of how you created the event in the managers calendar, maybe a similar flow could be used in my situation.
@NathanMowat you pose a great question. I have built and tested my flow with myself as the Approver. So when I create an event in the Calendar I'm assuming the Outlook 'Create event' action is connecting the individual who is approving. So I'm not sure now if this is going to actually create an event in Manager's Calendar. I'll have to test that and update you.
Alternatively I think you could use dynamic content (approver email) as a 'required attendee' on the calendar event.
Post testing - The only way I was able to get the event in the managers calendar was to include them as a 'Required Attendee'.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.