Share attendance directly after meeting

Microsoft Teams stores the attendance in a report directly after the meeting. In this blog I will show you how you can retrieve that information and share it in an e-mail via a Power Automate flow.

Inspiration

This question from borensm:

Not looking for the list of invitees but those that actually attended the meeting (subset of those invited).

Power Users Community thread: Capture Meeting Attendees

List attendanceRecords method

In one of my earlier blogs I showed you how you could retrieve the transcript after the meeting. This setup uses a similar approach.

When navigating through the Graph API documents I noticed there was also a List meetingAttendanceReports method. The List meetingAttendanceReports method can be used to retrieve a list of attendance reports for an online meeting.

But the more surprising one was the List attendanceRecords method. This method can be used to retrieve the attendance records of an online meeting. It even shows things like seconds joined in meeting.

QuickChart.io

To make the flow a bit more challenging I also wanted to present that information in a visual appealing way. I decided to use the show the information in a doughnut chart.

Paul Murana has written a great blog about this using QuickChart.io approach. I highly recommend looking at his blog about this: How to generate a chart with Power Automate.

Flow setup

Checklist before you start:
– This example uses HTTP connector actions which are part of a premium feature, make sure you have a license which covers this.
– The HTTP actions also use an app (with the correct Graph API permissions) in Azure Active Directory for authentication.

1. Add a When an upcoming event is starting soon (V3) action.

a. Select your Calendar Id, in this case Calendar

2. Add a Get my profile (v2) action.
To retrieve my own email to send the message to.

3. Add a Initialize variable action.

a. Provide a Name, in this example onlineMeetingId
b. Select a Type, String
c. Leave Value empty

4. Add a second Initialize variable action.

a. Provide a Name, in this example AttendanceReportId
b. Select a Type, String
c. Leave Value empty

5. Add a Condition action.
In this condition the body field within the body is checked for the meetup-join hyperlink. A indexOf function is used. If this is found it will output 1. If it is not found (equal to -1), it will output 0.

a. Use the expression below for the where statement

6. Add a HTTP action (in the If Yes section).
A Get onlineMeeting method from the Graph API is used. In this case specifically with a $filter query parameter and the JoinWebUrl. This is information we can retrieve from the body/body of the event message.

a. Select the GET method
b. Use the URI from the code snippet below

c. Select Active Directory OAuth for the Authentication, provide the details of your Azure AD App.

7. Add a Set Variable action (in the If Yes section).

a. In the Name field select the onlineMeetingId variable
b. In the Value field use the expression from the code snippet below

8. Add a Delay until action (in the If Yes section).

a. In the Timestamp field use the expression from the code snippet below

9. Add a second HTTP action (in the If Yes section).
A List meetingAttendanceReports method is used to retrieve a list of attendance reports for the specific online meeting.

a. Select the GET method
b. Use the URI from the code snippet below

c. Select Active Directory OAuth for the Authentication, provide the details of your Azure AD App.

10. Add a second Condition action (in the If Yes section).
In this condition a length function is used to check how many items are returned by the previous HTTP action. If this is greater than 0 we continue with the rest of the steps.

a. Use the expression below for the where statement

11. Add a second Set Variable action (in the If Yes section of the second condition).

a. In the Name field select the AttendanceReportId variable
b. In the Value field use the expression from the code snippet below

12. Add a third HTTP action (in the If Yes section of the second condition).
A List attendanceRecords method is used to retrieve the attendance records of the specific online meeting.

a. Select the GET method
b. Use the URI from the code snippet below

c. Select Active Directory OAuth for the Authentication, provide the details of your Azure AD App.

13. Add a Select action (in the If Yes section of the second condition).

a. Use the expression from the code snippet below in the From field

b. Use the json from the code snippet below in the Map field

14. Add a second Select action (in the If Yes section of the second condition).

a. Use the Output from the first Select in the From field
b. Switch to text mode and use the expression below from the code snippet in the Map field

15. Add a third Select action (in the If Yes section of the second condition).

a. Use the Output from the first Select in the From field
b. Switch to text mode and use the expression below from the code snippet in the Map field

16. Add a fourth HTTP action (in the If Yes section of the second condition).
A HTTP request is used to generate a QuickChart.io chart.

a. Select the POST method
b. Use https://quickchart.io/chart for the URI field
c. Use the body from the code snippet below

17. Add a Compose action (in the If Yes section of the second condition).
The image will be embedded into the body of e-mail message. This action is the create an IMG tag with a base64 version of the image.

a. Use the value from the code snippet below in the Inputs

18. Add a Send an email (v2) action (in the If Yes section of the second condition).
In this example I am sharing it with myself. Obviously, you could change this setup to share it with others, like the organisers or the attendees, etc.

a. In the To use the Mail field of the Get User Profile (v2)
b. In the Body use the Outputs of the Compose action

That is it for the setup of this example.

Happy testing!