Here is how you can setup the flow to achieve your requirements. I am using an instant trigger, but you can change that to a recurring trigger. And instead of Compose, you can send an email notification.
Here are the details on the actions:
1. Send an HTTP request: The Get events (V4) action does not expose the attendees and their responses, so we need to make a direct Graph API call. We will apply the filters to only return future events where you are the organizer.
Parameters:
- URI: https://graph.microsoft.com/v1.0/me/events?$filter=isOrganizer eq true and start/dateTime ge '@{utcNow()}'
- Method: GET
2. For each: Need to loop through all the events returned.
Parameters:
- Select an output from previous steps: @{body('Send_an_HTTP_request')?['value']}
3. Apply to each: Now, we need to loop through all the attendees to current event in the loop.
Parameters:
- Select an output from previous steps: @{items('For_each')?['attendees']}
4. Condition: Add two conditions joined with the OR operator to only process the attendees that have either tentatively accepted the event or have not yet responded.
Parameters:
- Operator: OR
- First condition: @{items('Apply_to_each')?['status/response']} is equal to tentativelyAccepted
- Second condition: @{items('Apply_to_each')?['status/response']} is equal to notResponded
Now, in the true block of your condition action, you can send an email notification to that specific user. You can get their email by this formula: @{items('Apply_to_each')?['emailAddress/address']}
This flow will essentially:
- Get all future events where you are the organizer
- For each event, get the attendee list
- For each attendee to each event, check their response
- Based on the attendee response, you can send email notifications.
Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item.
If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like! 🩷
_______________________________
