Requirement: create calendar events from excel in Power Automate.
An Excel called Events, where events are stored, so create an event on Calendar in Outlook from Excel.
Steps for power automate create calendar event from excel
Step 1: Create an Excel
Create an Excel sheet called Events, with the column listed below
- Events
- Start Time
- End Time
- Body
- Hour
- Start Date time
- End Date Time
Step 2: Create a Flow
Click on +Create and select ‘Instant Cloud Flow‘. Next, provide the Flow name, then select ‘Manually triggered Flow‘. Then click on Create button.
Get all events from the Excel
To get all events in Excel, click on the next step and then select the ‘List rows present in a table‘ action. then provide the Location, Document library, File, and table of the Excel file.
Create an event in the Calendar
Now create an event in the calendar, so, click on the Next step and then select ‘Create Event (V4)‘ action. Then set the calendar id and map the subject, start time, and end time with the excel value.
Then choose the time zone, which must be like the outlook calendar time zone. When user map the subject, automatically Apply to each action will create.
Step 3: Run the Flow
Now to run the Flow click on Save and run the Flow manually, Flow ran successfully.
Now check the calendar, that event is created like below.
