Keep track of who attended a meeting

[Json123]

Hi!

I currently have a form asking users if they want to attend a meeting. Their answer updates in an Excel sheet.

Is there a way to see if a person actually attended the meeting or not? I know MS tracks users but I wanted to automatically update it in the Excel sheet next to the person's name. 

Thanks!

[David-]

Are you asking if there is a way to track if people attending meetings scheduled with Microsoft Teams, or something else? If it is MS Teams, it has the ability to do this automatically, although it needs to be enabled by your admins. This will show you how to do this View and download meeting attendance reports in Teams (microsoft.com)

We don't have this enabled in our environment, so I don't know if you can then capture this information through Power Automate.

[Json123]

Thanks for the response! It's in Microsoft Teams. 

I know about the CSV attendance report but is there a way to automatically update a name in an Excel if they joined the meeting. Instead of downloading the file, I want Power Automate to handle it in the backend pretty much. 

[DamoBird365]

Hi @Json123 

Take a look at the following docs List meetingAttendanceReports - Microsoft Graph v1.0 | Microsoft Learn and Get meetingAttendanceReport - Microsoft Graph v1.0 | Microsoft Learn.  Hopefully you can list the attendance report for a meeting and then get that specific report.  

Let me know how you get on.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts. Thanks

[Json123]

Hi Damien,

As mentioned above, I already know how to extract the report. However, I don't want to manually pull the report and then compare it with my Excel to see who actually attended. I was hoping to update my Excel sheet automatically from who attended the meeting without me pulling any reports.

Thanks! 

[DamoBird365]

Hi @Json123 

I don’t think you’ve understood. This is the graph api. It’s where the magic happens beyond the standard actions for a connector.  There are two api calls, list reports and get report. These can be combined with an action in Power Automate to retrieve this info automatically.  If you want to see the graph api in action check out this video of mine
https://youtu.be/45AWJH6jiDI where I demonstrate a limitation of the outlook actions but we can overcome this my using graph.  To get meeting reports, you’ll need to use graph, get the data into PowerAutomate and then repurpose as an excel file etc.

Damien

[Json123]

Gotcha! I will play around with it and see if it works. I watched your previous video on updating an invite from a form which is helpful. I will see if I can combine it with your second video in not sending duplicate invites.

The only issue for my actual question is if I use the graph API, I don't think I can read the actual data inside it (like reading tables in an Excel sheet) - so that it would automatically update whether a user attended or not on my list

[DamoBird365]

Hi @Json123,

The data from the api will be returned as a json array and whilst you might need to repurpose using a select, you should then be able to (apply to each) add a row to an excel file containing a table. If not, you might want to use office scripts as it allows you to read/write excel without a table.

Damien

[suji1]

Did you find solution for this? I want to do the same

[drkmccy]

Graph will not get you what you need. All you get back is the number of people who attended, start and end time. Pretty much uselsess.