Hello Make community !
I created a scenario that triggers whenever a new event is added to my calendar.
The goal is to add new attendees to any new event, following the name of these events.
E.g: New event “Barack Obama and Xi Jinping” should automatically invite “email@example.com”.
Important: Barack Obama has already been invited to this event prior to the Make workflow. It’s important that Make lets him as an attendee and only adds Xi Jinping. The name Barack Obama can change following the event. The event is hosted by a third email adress (firstname.lastname@example.org), that never changes, whatever the event is.
Here’s the workflow:
Module 1: Watch Microsoft 365 to trigger whenever a new event is added.
Module 2: Search Rows in the Google Sheet which displays matching between names and emails. Sheet contains 2 columns, Name (A) and Email (B).
Module 3: Update an Event of Microsoft 365 Calendar. See screenshot below.
The workflow runs without error. But it doesnt reach its objective: it invites the new attendee (email@example.com) but cancel the initial attendee (firstname.lastname@example.org) from the event.
Any idea from my fellow Makers ? Thanks a lot to the community for helping.