You’re offline. This is a read only version of the page.
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?
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 -
5.4- use compose action to add 2 weeks to end date
Expression -
5.6- increment the index variable by 1
Now the flow is ready, it will create 5 events each having 2 weeks interval.
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! 🙌
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.
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 ?
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! 🙌
It would be 40 minutes the duration of the event.
Hi @Luilui8090 ,
what should be time duration for the event ?, i could not see it as mentioned.
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! 🙌
#1
WarrenBelz
146,731
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,079
Most Valuable Professional
Share
Report
All responses (
Answers (