Creating a SharePoint calendar entry from a Form and flow

Question

Afternoon all,

Relatively new flows and power automate. Honestly I have spend days and days trying to get my setup to work properly but I just cannot get over the last hurdle.

I have created a Form for holiday requests which is then approved or rejected fires off an email and updates a SharePoint list, all that is fine and works. 

Where i'm seriously struggling is i want to use the start date and end date entered on the form to create an entry into a SharePoint Calendar I've created. Ideally I'd like it to just list for the hours of 9am - 6pm on those days and exclude weekends in that. However I cannot even get the thing to add a simple calendar entry let alone work on those days.

The flow checker says everything is working ok, but I cannot see an issue.

Any help would really be appreciated.

Answer 1

Hi the Sleeper,

Thanks for your post in the Microsoft Community.

In my opinion you might use the following Power Automate template to achieve what you want. 

Instead of creating an event in the SharePoint Calendar directly, we could connect the SharePoint Calendar to our Outlook Calendar first so the events will be synced on both sides. 

And Once you have approve the holiday request, it will trigger the flow and create an event in your Outlook calendar. As SharePoint calendar is connected to your calendar, the event will also appear there. 

Unfortunately, this community is not dedicated in the Power AutoMate, if you need further assistance of the Power Automate flow, please kindly raise a new thread in the Power Automate Community.

Appreciate for your understanding. 

Regards,

Alex Chen