Stuck: Flow that creates recurring calendar entries based on 1st occurrence date.

Hello!

I have a SharePoint Automate problem that I just can’t figure out how to solve. I have been working on it for days and I am at a loss! I am hoping you can help.

I have 2 lists that I am working from: a Meeting List and a Meeting Calendar List.

The Meeting List contains the list of meeting names, how often they occur, the first occurrence date, etc:

The Meeting Calendar List has entries that are entirely generated from a Power Automate Flow which is based off of the info provided in the Meeting list mentioned above.

When a new meeting series is entered in the Meeting List, it needs to generate a year’s worth of recurring meeting entries in the Meeting Calendar List.

The problem is that the recurring entries are not just simply monthly or biweekly, so I cannot add 1 month, or 2 weeks to the prior meeting to get the next calendar entry date. They are specific days of the week, for example:

MONTHLY - 1st Monday of every month

BIWEEKLY - 2nd and 4th Tuesdays of the month

I think I need to create an “Initialize Variable” for each scenario but can’t figure out how to create them for the correct days. I think the closest I have gotten for the meetings that occur on the 1st Monday of every month is this:

addDays(formatDateTime(addToTime(variables('Month0'), 1), 'yyyy-MM-01'), mod(sub(8, dayOfWeek(formatDateTime(addToTime(variables('Month0'), 1), 'yyyy-MM-01'))), 7))