Teams Meeting links - Bulk creation

Question

Hey there,

I need to create 50 Teams meeting links for each Event I organize.
Currently am creating links 1 by 1 from Outlook calendar. I copy the link and paste into Excel, which is a time taking process.

Is there a way to create these meeting links in Bulk and save time.

I sincerely appreciate your thoughts & suggestions.
Thanks in Advance.

Answer 1

@Nagarjuna Vijayagiri - This can be automated using Graph APIs to create online meeting. You can try this using Graph Explorer as well as code by following these steps.

Answer 2

Hi!

You can try to invite those participants in Teams channel. Then you don't need to specify people just the channel in the invitation. This will automatically invite all members of the team. It should appear in their Outlook.

Answer 3

Hi guys,

I have used Power Automate to automate this process.

Thanks for your suggestions.

Answer 4

How did you this? I have exactly the same challenge.
I tried to use create events connectors ik power automate but then I need calendar id's but of course I don't have id's. Because the people we invite are externals with Gmail hot live etc etc mails. Hope to hear!

Answer 5

There is a relatively easy solution for this:

Step 1. Create an Excel document and save it to Onedrive

Step 2. Add a Table, containing any fields that you want to be able to customize. RoomName, Start Time, End Time works well for me. (This must be formatted as a Table. Do this by highlighting the range and click Insert > Table). Date and Time format must be YYYY-MM-DDT00:00:00

Step 3 - Sign in to Microsoft Power Automate.

Step 4 - Create an Instant Cloud Flow and select Manual Trigger

Step 5 - Add a Step and select "List Rows Present in a Table". Fill in the information, so it can find the table you created in Excel

Step 6 - Add another Step. Select "Create a Teams Meeting", and fill in the information. Any of these fields can be dynamically populated based on the contents of your Excel document (Subject, Start Time, End Time etc.) - You may want to open the advanced settings and turn reminders off so you don't get all the notifications come through at once.

**

**

Step 7 - Save and Run your flow. The meetings will then automatically schedule in your diary

Step 8 (Optional) - If you want to access all the links, without opening up each meeting, export your calendar from Outlook as a CSV file. I tend to schedule the Teams Meetings for an unused day (eg. Sunday Morning) and just export that day, so no other meetings get mixed in.

Step 9 (Optional)

Take your Exported CSV file and delete all columns except Subject and Description (leaving them in column B). Then enter the following formula into cell C2 and drag it down for each row of your sheet

=MID(B2,SEARCH("<",B2)+1,SEARCH(">",B2,SEARCH("<",B2)+1)-SEARCH("<",B2)-1)