Hi All,
New to power automate, but my goal is to create a flow that works with a Microsoft form where team members can input details about an event, then the flow will create a outlook event on a shared calendar based on the form submission. Here is how I set up the flow so far:
Step 1: Triggered when new response is submitted in the form.
Step 2: Get response details from form.
Step 3: Switch
- Case 1: Single day event -> Create an event (V4)
- Case 2: Weekly Recurring Event -> Create an event (V4)
- Case 3: Monthly Recurring Event -> Create an Event (V4)
I made a switch with each case creating a different event because it made sense with the calendar event parameters that I can change things like "Is this an all day event?" and I can specifically change the recurrence structure, but I am not really sure how to set up the monthly recurring event case. If someone wanted to submit an event that repeated "every second Monday" of the month or "every last Tuesday" of a month, how would I do that? Would I need to put a specific formula into the 'recurrence' section that would account for the day of the week in question and when in the month it repeats?
Likewise, if there is a specific way that the information needs to come from the form, I can do that. As of right now, I have a question asking them to choose what day of the week and choose which week of the month (first, second, third, or last).
Any help is appreciated!