web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating recurring mee...
Power Automate
Unanswered

Creating recurring meeting invites using Excel Data

(0) ShareShare
ReportReport
Posted on by 2
I am completely new to Power Automate and have kind of been coerced here because of Windows pushing New Outlook.  I have a bunch of student project teams that I need to send meeting invites to for recurring meetings.
 
I've been able to set up everything in Excel, and setup the connection to the data using the List rows present in a table.
 
For each row I then send the data through a Compose step to setup a recurrence pattern and range for a Create event (V4) step.  My compose function looks like this:
 
json(concat(
    '{',
        '"pattern": {',
            '"type": "', toLower(item()?['RecurrenceType']), '",',
            '"interval": ', string(item()?['RecurrenceInterval']), ',',
            '"daysOfWeek": ["', toLower(item()?['Day']), '"]',
        '},',
        '"range": {',
            '"type": "numbered",',
            '"startDate": "', item()?['StartDate'], '",',
            '"recurrenceTimeZone": "Eastern Standard Time",',
            '"numberOfOccurrences": ', string(int(item()?['Occurrences'])),
        '}',
    '}'
))
 
... and I have every reason to believe that it is working well.  Here are the input parameters that the Create event (V4) is receiving:
 
{"table":"AQMkAGJlNWY1NjdjLWZjNzEtNGVhMC05NTA5LTc5ZWUBOTAzNTc1YQBGAAADOpg_jYqyHk_DH4xPcaZKGAcAIU8ywwmESU2a5Z9ouk1m5wAAAgEGAAAAIU8ywwmESU2a5Z9ouk1m5wAAAhnKAAAA","item/subject":"MECH 460 - Project Team 1","item/start":"2026-01-13T14:00:00.000Z","item/end":"2026-01-13T14:30:00.000Z","item/timeZone":"(UTC-05:00) Eastern Time (US & Canada)","item/requiredAttendees":"xxxxxx@gmail.com","item/optionalAttendees":"yyyyyy@zzzzzz.ca","item/location":"A real location","item/importance":"normal","item/isAllDay":false,"item/recurrence":{"pattern":{"type":"weekly","interval":2,"daysOfWeek":["tuesday"]},"range":{"type":"numbered","startDate":"2026-01-13T14:00:00.000Z","recurrenceTimeZone":"Eastern Standard Time","numberOfOccurrences":3}},"item/reminderMinutesBeforeStart":30,"item/isReminderOn":true,"item/showAs":"busy","item/responseRequested":true,"item/sensitivity":"normal"} 
 
However, I appear to be doing something wrong in the Create event V4. I have pointed to the outputs of the previous Compose step.  An invite is sent but the recurrence doesn't happen and my recipient account is adjusting timezones because it states that the email wasn't configured to UTC timezones.

Here is the output of the body of the Create event (V4).
 
{"subject":"Project Team 1","start":"2026-01-13T14:00:00.0000000","end":"2026-01-13T14:30:00.0000000","startWithTimeZone":"2026-01-13T14:00:00+00:00","endWithTimeZone":"2026-01-13T14:30:00+00:00","body":"","isHtml":true,"responseType":"organizer","responseTime":"0001-01-01T00:00:00+00:00","id":"AQMkAGJlNWY1NjdjLWZjNzEtNGVhMC05NTA5LTc5ZWUBOTAzNTc1YQBGAAADOpg_jYqyHk_DH4xPcaZKGAcAIU8ywwmESU2a5Z9ouk1m5wAAAgENAAAAIU8ywwmESU2a5Z9ouk1m5wAEG6IAzAAAAA==","createdDateTime":"2026-01-12T02:10:42.3747128+00:00","lastModifiedDateTime":"2026-01-12T02:10:42.8696243+00:00","organizer":"aaaaaa@zzzzzz.ca","timeZone":"UTC","seriesMasterId":null,"iCalUId":"040000008200E00074C5B7101A82E00800000000D91D78A76883DC01000000000000000010000000312DCEAB2B13FC448B509FADDEF466B7","categories":[],"webLink":"https://outlook.office365.com/owa/?itemid=AQMkAGJlNWY1NjdjLWZjNzEtNGVhMC05NTA5LTc5ZWUBOTAzNTc1YQBGAAADOpg%2BjYqyHk%2BDH4xPcaZKGAcAIU8ywwmESU2a5Z9ouk1m5wAAAgENAAAAIU8ywwmESU2a5Z9ouk1m5wAEG6IAzAAAAA%3D%3D&exvsurl=1&path=/calendar/item","requiredAttendees":"xxxxxx@gmail.com;","optionalAttendees":"yyyyyy@zzzzzz.ca;","resourceAttendees":"","location":"A real location","importance":"normal","isAllDay":false,"recurrence":"none","selectedDaysOfWeek":null,"recurrenceEnd":null,"numberOfOccurences":null,"reminderMinutesBeforeStart":30,"isReminderOn":true,"showAs":"busy","responseRequested":true,"sensitivity":"normal"}
 
I've been spending hours upon hours on this trying to stretch myself and learn something new but I've hit a wall.
Categories:
I have the same question (0)
  • Power Platform 1919 Profile Picture
    2,245 Super User 2026 Season 1 on at

    Hi,

    Could you please share a screenshot of your Create event (V4) action configuration?

    I am referring to the Microsoft documentation here:

    https://learn.microsoft.com/en-us/connectors/office365/#create-event-(v4)

    Based on the documentation and the available advanced parameters for this action, I do not see any input field or JSON placeholder where the custom recurrence JSON you built can be directly pasted or mapped.

     

    From the screenshots of the action configuration, it appears that recurrence is expected to be defined using the built-in fields such as Recurrence, Selected days of week, Number of occurrences, and Recurrence end date, rather than by supplying a custom JSON object.

    Could you confirm where exactly the output of your Compose action is being passed into the Create event (V4) step?

  • JH-12010144-0 Profile Picture
    2 on at
    I think I see the issue.  I was entering my JSON output from the Compose to the Create event (V4) "Recurrence" input based on the prompt - "The recurrence patern for the event:...".  I was informed (erroneously?) by Copilot that I could enter the pattern there.  Without this ability there is no way to enter the recurrence interval and create "bi-weekly events".  I see that others have expressed concern about this limitation.  Am I missing something?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 450

#2
Haque Profile Picture

Haque 366

#3
Valantis Profile Picture

Valantis 349

Last 30 days Overall leaderboard