Teams Meeting links - Bulk creation

Nagarjuna Vijayagiri 6 Reputation points
2020-08-18T07:53:39.003+00:00

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.

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,047 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
4,883 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
2,836 questions
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Wajeed-MSFT 231 Reputation points Microsoft Employee
    2020-08-18T08:48:21.087+00:00

    @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.

  2. JimmyYang-MSFT 48,706 Reputation points Microsoft Vendor
    2020-08-18T09:36:13.727+00:00

    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.

  3. Nagarjuna Vijayagiri 6 Reputation points
    2022-02-02T14:40:55.623+00:00

    Hi guys,

    I have used Power Automate to automate this process.

    Thanks for your suggestions.

  4. Najib Aynan 1 Reputation point
    2022-12-27T12:23:41.973+00:00

    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!

    0 comments
  5. AdamMorgan-9912 0 Reputation points
    2023-03-13T12:39:49.0433333+00:00

    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

    User's image

    Step 3 - Sign in to Microsoft Power Automate.

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

    User's image

    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

    User's image

    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.

    **User's image

    **

    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)

    0 comments