Re: How to create calendar event from SharePoint list using Power Automate
Hi @Luilui8090
Try like below
Assume i have these 4 columns in my sharepoint list
Start time represent the first date time at first event should start
end time represent the datetime at which first event should end.
See the following design in flow.
1. Use when item is created or modified trigger OR when item is created trigger
2. Initialize a integer variable with value 1
3. Use initialize variable to intialize start date time as shown below
4. Use Initialize variable to initialize End Time
5. Use a do until loop which loop until 5 iterations are completed so create 5 recurrances with interval of 2 weeks
The next steps would be under Do until loop
5.1- Create a event using below parameters
I am using mentor email id and mentee email id as attenders which may be optional in your case.
5.2- Use compose action to increment the start date by 2 weeks
Expression -
addToTime(variables('StartDate'),2,'Week')
5.3- use set variable to set the value of compose
5.4- use compose action to add 2 weeks to end date
Expression -
addToTime(variables('EndDate'),2,'Week')
5.5- set the variable as output of compose action
5.6- increment the index variable by 1
Now the flow is ready, it will create 5 events each having 2 weeks interval.
