Skip to main content

Notifications

Community site session details

Community site session details

Session Id : dGJv6GFQOgIYqnMrXdqUAQ
Power Automate - Using Flows
Unanswered

Get MS Teams Participants using Power Automate

Like (0) ShareShare
ReportReport
Posted on 5 Feb 2024 23:43:34 by 3

Hi

 

I am new to Power Automate and I was wondering if it's possible to get participants from MS Teams Meetings and then update Salesforce automatically?

 

I know I need to use Graph API but not sure which one to use and I also can't find any trigger for "when a meeting ends" in Power Automate?

 

 

Many thanks

Yu-Fen

  • jkic Profile Picture
    146 on 23 May 2024 at 11:39:58
    Re: Get MS Teams Participants using Power Automate

    Hi

    Yes, surprisingly the Flow works, even though the canvas app doesn't.  So I'm calling the Flow from Power Apps, passing the Teams URL.  The Flow goes through the 3 steps, each calling an action in the Custom Connector (getMeetingID, getAttendanceReports, getAttendanceDetails).  I have some work to tidy it up (reduce the Apply to each loops).  For info, I used a client secret for authorisation in the app registration. 

  • hrics12 Profile Picture
    26 on 22 May 2024 at 13:17:39
    Re: Get MS Teams Participants using Power Automate

    Have you had any luck? I'm in the same boat. I can get  all the attendance report info I need in graph explorer. When I try to call that data into an automate flow I am receiving the 403 forbidden error. I am have been using the HTTP request using a generated access token from the app registration ID's in Azure AD. I'm at a loss right now on what to do. Any info will be helpful!

  • jkic Profile Picture
    146 on 10 May 2024 at 03:13:04
    Re: Get MS Teams Participants using Power Automate

    I'm currently trying to get info into a canvas app using graph API.  Note that 'attendees' really means invitees not those who actually attended.  The Teams attendance report (downloadable as a csv) can be accessed via Graph API using GET https://graph.microsoft.com/v1.0/me/onlineMeetings/{meetingId}/attendanceReports/{reportid}/attendanceRecords.

    {meetingId} is the Teams (not outlook) id, and is the same for all meetings in a series; {reportId} is the report for the specific event.  I do this in 3 steps: 1. get the meetingId using the JoinWebUrl 2. get the Attendance Reports for all occurrences in the series 3. get the reportid for the date I'm after to get the attendanceRecords for that event (that's the example call above) 

    ....BUT....although this works in Graph Explorer, I'm finding it returns 403 Forbidden response via my Custom Connector.  Probably because this call isn't supported for Custom Connectors.  I'm now going to pursue a Flow solution using HTTP request and see if I can call that from the canvas app....will update if I succeed...

  • yufenhunter Profile Picture
    3 on 13 Feb 2024 at 11:27:45
    Re: Get MS Teams Participants using Power Automate

    Thank you. I will try!

  • zbeg Profile Picture
    295 Super User 2025 Season 1 on 06 Feb 2024 at 07:46:06
    Re: Get MS Teams Participants using Power Automate

    hi,

    Try this

    104445.png

    there is three attendees that you can initialize with.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,776 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,093 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow