How to create calendar event from SharePoint list using Power Automate

[Luilui8090]

When an Item is created in my Sharepoint:

I need to create 5 calendar events for that new item, each events needs to have a recurrence of 2 weeks.
How can I make this in Power Automate?

[Nived_Nambiar]

Hi @Luilui8090 ,

what should be time duration for the event ?, i could not see it as mentioned.

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Luilui8090]

It would be 40 minutes the duration of the event.

[Nived_Nambiar]

Hi @Luilui8090 

so how flow should trigger - should it trigger when the sharepoint list item is created ? also what should be date when the recurrance should be started ? where the date can be obtained ?

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Luilui8090]

It´s when the item in sharepoint list is created, like this example

Mentee is the student
Mentor is the teacher
HoraInicio is the time and date when the first event needs to be created or started,.

So in my example, the power automate need to create the first event with that new item created, then it need to create the other 4 events every 2 weeks in the same time of the item created.
Horafin is the time and date when the first event needs to be ended.

[Nived_Nambiar]

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.

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌