How to Create Calendar Events from a SharePoint list using Power Automate?

In this Power Automate tutorial, we will see how to create calendar events from a SharePoint list using Power Automate.

Here we will create a SharePoint list named ‘Meetings’ which contains the below columns.

  • Title – Single line of text
  • Meeting Date – Date and Time
  • Meeting End Date – Date and time
  • Meeting Location – Location
  • Meeting Attendees – Person
  • Meeting Description – Multiple lines of text
  • Meeting Organizer – Person
Power automate create calendar events from the SharePoint list

In the above list when a meeting is created, the meeting will go for approval to the organiser. Once the organizer is approved, we will create an event. At last, we will inform the organizer, that the event you approved, has been successfully scheduled.

You can see the screenshot of the flow in Power Automate.

Create Calendar Events from a SharePoint list using Power Automate

Power automate create calendar events from a SharePoint list

Here we will see how to create calendar events from a SharePoint list using Power Automate.

Before creating the flow, you need to set up the SharePoint list with the above columns.

Step 1: Log in to Power Automate, then click on +Create -> select Automated cloud flow.

Microsoft Power automate create calendar events from the SharePoint Online  list

Then provide the flow name and select ‘When an item is created‘ and click on Create.

Microsoft Power automate create calendar events from the SharePoint Online list

After that, you can see the ‘When an item is created’ trigger action, then provide the below information:

  • Site address: Provide or Select the site address
  • List name: Provide or Select the list.
Power automate create calendar events from the SharePoint Online list
Power automate create calendar events from the SharePoint Online list

Step 2: Next, click on +New step -> select ‘Start and wait for an approval’ action. Then provide the below information:

  • Approval type: Approval/Reject-First to respond
  • Title: Select the Title from the dynamic content
  • Assigned to: Select Meeting organizer email from the dynamic content
create calendar events from the SharePoint Online list using Power automate

Step 3: Then click on +New step -> select Compose actions, and provide the below information:

See also  How to add Site columns to SharePoint content type using Power Automate?

Inputs: Provide the below expression to format date to iso 8061 format

formatDateTime(triggerOutputs()?['body/MeetingDate'], 'yyyy-MM-ddTHH:mm:ssZ')

Similarly, create another compose action, then in inputs provide the below information:

formatDateTime(triggerOutputs()?['body/MeetingEndDate'], 'yyyy-MM-ddTHH:mm:ssZ')
How to create calendar events from the SharePoint Online list using Power automate

Step 4: Next we will check the outcome of approval if it is approved then we will create an event. At last, we will send an email, the event is successfully created.

So, click on +New step -> select Condition control, then provide the below information:

  • Choose a value: Select Outcome from the dynamic content
  • Operator: Select is equal to as operator
  • Choose a value: Write Approve as a value
How to create calendar events from the SharePoint list using Power automate

If the condition is true, then in the If Yes part, click on Add an action -> select ‘Create Event’-Outlook. Then provide the below information:

  • Calendar Id: Select Calendar Id as Calendar
  • Subject: Provide the subject
  • Start time: Select the output from the dynamic content
  • End Time: Select the output from the dynamic content
  • Time zone: Select the timezone as per your requirement

Click on the Show Advanced options link.

  • Location: Select Location from the dynamic content.
How to create calendar events from the SharePoint list using Microsoft Power automate

Then send an email to the Organiser, so click on +New step -> select ‘Send an Email (V2) action. Then Provide the below information:

  • To: provide the organizer email from dynamic content
  • Subject: Provide the subject of an email
  • Body: Provide the body of an email.
How to create calendar events from the SharePoint list using Microsoft flow

Step 5: Now click on save and Run the flow manually, for this click on the Test icon -> select the Manually option -> Then click on the Test button. Next, connect to the credential, and then click on the Continue button -> Next click on the Run Flow button -> click on Done

See also  How to append a string to an array in Power Automate?

Now create a new item in the SharePoint list like below.

How to create calendar events from the SharePoint Online list using Microsoft flow

Then the organizer will receive an approval request, if the request is approved you can see flow ran successfully also the event gets created.

How to create calendar events from the SharePoint Online list using MS flow

This is how to create a calendar event from the SharePoint list using Power Automate.

Conclusion

In this Power Automate tutorial, we will see how to create a Calendar event from a SharePoint list using Power Automate.

You may also like:

>