Skip to main content
Question

Inserting attendance data from Microsoft Teams event back into Airtable

  • March 25, 2026
  • 4 replies
  • 33 views
C
Forum|alt.badge.img+1

Hello everyone,

I am currently developing a base which will allow one of our departments to plan employee trainings (which will be conducted via Microsoft Teams).  Tranings can be planned and employees can be linked to events (via a Employee_Training table).

Part of this solution should be, that after the event has happened, the business department wants to track, which of the invited collegues took part in the Teams meeting.

So I would need a way to get the attendance list of a Teams meeting, cross reference this list with employee list in Airtable (propably via email) and then mark them as “show-up” if a match is found.

Has anyone ever done something like this or has an idea how to achieve this?

 

I appreciate all the support I can get. Thank you in advance.

 

Best regards

Christopher

 

4 replies

Milan_Automable
Forum|alt.badge.img+12

You need to use the Microsoft Graph API, which has a meetingAttendanceReport endpoint that returns this info.

This is possible with Airtable scripts, usually it is simpler to use an automation tool such as N8N to set up the connection and the requests.

I have a video walkthrough of working with Airtable and N8N, check it out here: https://youtu.be/lQh1fuIrBN8

Alternatively, Make or Zapier would work too, although I find these tools less flexible and harder to debug.

Also feel free to schedule a free strategy call with me where we can go through how to achieve this in more detail.

 

    C
    Forum|alt.badge.img+1
    • Christopher
    • Author
    • New Participant
    • March 25, 2026

    Thank you, good to know that this exists!

     

    So i would need to somehow connect Airtable to Microsoft Graph API so it can request (via some form of automation) the attendance report. I would then store these reports in a new table and create another automation to compare entries in this table propably based on meeting name & email (maybe date) - am I on the right track here?

     

    How do I set up the connection between Airtable and Graph API?

    Milan_Automable
    Forum|alt.badge.img+12

    Yes, that is definitely a way to do it!

    For the connection, I would use N8N or Make, which make it easier to integrate with APIs than it would be with code.

     

      ScottWorld
      Forum|alt.badge.img+35
      • ScottWorld
      • Genius
      • March 25, 2026

      As mentioned above, you should be able to do this with Make’s Microsoft Teams integrations along with Make’s Airtable integrations.

      If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you can instantly trigger a Make automation from Airtable. 

      I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.

      Hope this helps!

      If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

      Terms & ConditionsAccessibility statement