How to send bulk Outlook calendar invites without showing everyone's email address

Create an Excel file in OneDrive (the video uses attendees.xlsx) with two columns: Name and Email. Name is optional, so you can leave it blank for some people.

Select the columns, click Format as Table and pick a style. Note the table name (here Table1).

Create or open the Outlook event you want people added to. In the video it already has one participant. The flow will add everyone from Excel to this same event rather than creating new ones.

Open Microsoft Graph Explorer and sign in with the same Microsoft 365 account that owns the event. On the Modify permissions tab, consent to the calendar permission so it can read your events.

Set the method to GET, paste this URL and click Run query:

https://graph.microsoft.com/v1.0/me/calendar/events?$select=id,subject,start,end

The response lists your recent events with their subject, start and end. Find your event by its subject and copy its id. Keep it somewhere handy for the next steps.

In Power Automate, click Create > Instant cloud flow. Name it Add Excel list to Outlook event, choose Manually trigger a flow and click Create. You run it on demand whenever you have a list to add.

Add the Excel Online (Business) action List rows present in a table. Set Location to OneDrive for Business, Document Library to OneDrive, choose attendees.xlsx and select Table1. This returns every person on your list.

Add Initialize variable, rename the action and the variable to AllAttendees, and set Type to Array. For each Excel row, this array is rebuilt to hold the event's existing attendees plus the current person.

Add Apply to each and set its input to value from List rows present in a table. With five people in Excel, the loop runs five times. Everything below goes inside this loop.

Inside the loop, add Set variable, choose AllAttendees and set the value to []. This empties the array at the start of each person. Without it, attendees from earlier rows pile up and repeat.

Add the Office 365 Outlook action Send an HTTP request and rename it Get event attendees. Set the method to GET and the URI to:

https://graph.microsoft.com/v1.0/me/events/YOUR_EVENT_ID?$select=attendees

Replace YOUR_EVENT_ID with the ID you copied. $select=attendees tells Graph to return only the attendee list, which you need before adding anyone.

Add Parse JSON. Set Content to the body of Get event attendees. Click Use sample payload to generate schema, paste a small sample of the GET response and click Done so Power Automate builds the schema.

Add a second Apply to each and set its input to the attendees array from Parse JSON. Inside it, add Append to array variable, rename it Append existing attendees, choose AllAttendees and paste this value:

{"emailAddress": {"address": "", "name": ""}}

Place the cursor between the address quotes and insert address from Parse JSON, then between the name quotes and insert name (both under See more). This puts everyone already on the event back into the array.

Outside the inner loop but still inside the outer loop, add another Append to array variable and rename it Append new attendee. Use the same AllAttendees array and the same JSON structure. This time insert Email and Name from List rows present in a table.

The array now holds the existing attendees plus exactly one new person.

After Append new attendee, add another Send an HTTP request and rename it Add attendees. Set the method to PATCH and the URI to:

https://graph.microsoft.com/v1.0/me/events/YOUR_EVENT_ID

Replace the placeholder with your event ID. Open Advanced parameters, add Body, and send the attendee array with the attendee list hidden, for example {"attendees": @{variables('AllAttendees')}, "hideAttendees": true}.

Because the list you send matches the event plus one new person, Outlook only emails that one person. People already on the event are not emailed again. Save the flow.

Click Test, choose Manually, then Test and Continue. Watch the run: the outer loop processes each Excel row, clearing the array, reading the event, adding existing attendees and adding the new one.

When it finishes, close and reopen the event in Outlook. Everyone from the Excel file is now on the attendee list.

Check Sent Items. You should see one invite per person (five in the video) rather than one bulk message. Open the invite in one attendee's inbox: it shows only that person, and no other email addresses are visible.