Power Platform Community Forum Thread Details

I would like to build a manual flow which uses an Excel spreasheet 'List rows present in a table' then picks who to send this to depending on job role then using email address to send an MS Teams invite and save in receipents calendar. I have got most of this done it's when I apply to each , job, role, name and email address I am stuck?

I would also like this sent froma group inbox, allowing the group mailbox users to add, amend or edit the invite once sent.

Categories:

Building flows

@EM-06051009-0

You're very close to completing a powerful flow! Let's break down the two parts you're stuck on and how to solve them:

1. Apply to Each: Filter by Job Role and Send Invite

Assuming your Excel table has columns like:

Name
Email
JobRole

You can do the following in Power Automate:

Inside "Apply to each" (from `List rows present in a table`):

Condition:
Check if item()?['JobRole'] equals the role you're targeting (e.g., "Manager").
If Yes:
- Use "Create Event (V2)" from Outlook or "Create a Teams meeting" (via Graph API or Outlook).
- Set:
  - Required Attendees = item()?['Email']
  - Subject, Start/End Time, etc.

2. Send from a Group Mailbox

To send from a shared mailbox or group inbox, use:

"Send an email from a shared mailbox (V2)"

Shared Mailbox: Enter the group email (e.g., team@yourdomain.com)
To: item()?['Email']
Subject/Body: Customize as needed

Make sure the flow owner has Send As or Send on Behalf permissions for the shared mailbox.

Bonus: Let Group Members Edit the Invite

If you're using Outlook calendar events, you can:

Create the event in the shared mailbox calendar.
Add group members as organizers or editors (this requires Graph API or manual calendar sharing).

🏷️ Tag me if you have any further questions or if the issue persists.

✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems.

❤️ Give it a Like if you found the approach useful in any way.