Organize Large Meetings Easily with Power Automate | Power Automate Tutorial

     In this tutorial, Nick Lee from Pragmatic Works walks viewers through an intermediate-to-advanced use case of Microsoft Power Automate. The objective: automatically send calendar invites to users based on their Microsoft Form selection. This approach is perfect for coordinating training seminars, town halls, or large company meetings across multiple days, allowing users to pick the session that fits their schedule.

Overview of the Scenario

Nick creates a Microsoft Form offering users multiple meeting dates—January 6th, 7th, and 8th. Once a user selects a date and submits the form, Power Automate triggers a flow that:

• Reads their response
• Identifies the correct meeting
• Pulls their user profile
• Adds them to the appropriate meeting invite on the calendar

Step-by-Step Breakdown

1. Start a New Automated Cloud Flow:
   Go to make.powerautomate.com and create a new flow triggered by a Microsoft Form submission.
2. Configure the Trigger:
   Use “When a new response is submitted” and select the correct form titled “Form for Meeting Invitations.”
3. Retrieve Form Details:
   Add the “Get response details” action to pull data from the submitted form using the dynamic response ID.
4. Identify the User:
   Use the Office 365 Users connector’s “Get user profile” to retrieve the responder’s name and email address.
5. Initialize an Attendee Variable:
   Create an array variable to store attendees, since multiple people may select the same date.
6. Add Conditional Logic:
   Use the “Condition” action to detect the selected date (e.g., if the selection contains "January 6").
7. Find the Matching Calendar Event:
   Use the “Get events (V4)” action to find the event with the subject “Meeting January 6.” Apply OData filters to isolate the event.
8. Send an HTTP Request:
   Retrieve existing attendees from the event using Microsoft Graph’s API endpoint with the event ID and attendees attribute.
9. Set and Append Attendees:
   Extract the attendee data from the HTTP response and append the new user's profile to the array variable.
10. Patch the Calendar Event:
    Use another HTTP request with the PATCH method to update the meeting’s attendees list, effectively adding the user.
11. Repeat for Other Dates:
    Copy and modify the condition logic for January 7 and January 8, updating each flow section with the correct meeting ID and filter values.

Final Test and Confirmation

Nick tests the entire flow using a demo account in an incognito browser. After selecting a meeting date and submitting the form, the meeting appears in the user's Outlook calendar within seconds—validating the automation's success.

Conclusion

This tutorial highlights how Power Automate can be used creatively to streamline coordination for large-scale meetings. Though the solution involves intermediate to advanced concepts—such as HTTP requests, dynamic content handling, and expression logic—it demonstrates the power and flexibility of automation in Microsoft 365.

Let’s Hear From You!

Have ideas for how you’d use similar flows in your organization? Share your thoughts in the comments—your use case could inspire another automation!

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power Automate and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.