Unanswered

How to add a condition if a calendar event happens in a certain month it will create another calendar event

(1) Share

Report

Posted on by SuzyK

Hello, I'm fairly new to Power automate. My flow is almost complete but stuck on the last ask of my supervisor. How do I add a condition (or maybe I should be using something other than a condition) that will create a calendar event on July 31st only if the earlier calendar event happens in the Month of July. Basically, I created a flow that creates calendar events for students depending on when they started their rotation. If they start in January their rotation will occur 6mths later sometime in July and then I need a calendar event created for their mid year evaluation to happen on July 31st. For instance if they start in March their rotation will happen 6mths later in September so they will not have a mid year eval calendar event. So I guess I just need something for the students that start in January? Thanks for any help!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

trice602 15,402 Super User 2025 Season 2 on at

Like (2)

Report

Hi @SuzyK ,

What I what consider doing here is having my students in an excel table with name, email, startdate, and mid-year columns. The mid-year column can be a simple excel formula that writes the desired date based on their start date.

Create a array variable.

Next you can List rows present in a table with a filter query that says

mid-year eq '2023-07-31'

This is going to give you all the students that need that July 31st evaluation.

In your for each loop you want to loop through the rows and add the student email addresses to your string array with a ';'. This will end up giving you a string array of tom@somwhere.com; mary@somehwere.com; jim@somewhere.com , etc

Then at the end, below my apply to each, I create my event and the attendees are my string array.

I would have to create this and maybe clean up some steps and/or redescribe them but that's the general process.

Was this reply helpful? Yes No
SuzyK 13 on at

Like (0)

Report

Hi Tom! I really appreciate your feedback! But, before I go ahead and create the excel spreadsheet. Wondering if your thoughts would change... I should have mentioned that this flow is triggered by a Microsoft form that is filled out with the Student name, rotation (1,2 or 3) and the start date. Is there a way to use that information to create a condition or something like that instead of excel? Thanks again!

Was this reply helpful? Yes No