Connect corporate directory to Airtable - Microsoft Entra

Hi.

I can’t answer that directly sorry, but are you on an Enterprise grade Airtable account (so you have an Admin Panel)? Also, are all of your company members using Airtable?

If so, you can now sync a table from the Admin Panel into a Base and have a table with all of your Airtable Users, names and email addresses etc etc. Then go from there.

​@Tam 

Airtable doesn’t offer native communication with Entra, so you would need to use something like Make’s Entra integrations along with Make’s Airtable integrations if you want to have communication between Entra and Airtable.

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!

- ScottWorld, Best Airtable Consultant

It looks like Entra isn’t currently a supported sync I’m afraid: https://support.airtable.com/docs/airtable-sync-integrations-overview

As a workaround, what if you did a manual import of the Entra directory and then used Zapier/Make etc to keep it up to date instead?  

FYI, it seems that n8n does have an Entra integration for certain actions! You might want to check their documentation here.

Zapier documentation here.

Make documentation here.

For more on these automation tools, you might want to read this other article.

Mike, Consultant @ Automatic Nation 
YouTube Channel 

hi ​@Tam – this depends on your InfoSec rules, but more likely than not no-code connectors like Zapier, Make, and N8N will not be allowed in enterprise settings.

That said, Microsoft Entra services via code is the Microsoft Graph API. You can then use Claude Code or even Airtable’s proprietary AI to code a simple API calls given you have the logic in place (when to download a new profile, when to update it, etc.)

The Graph API allows you to download a wide range of data, including profiles which should solve your integration data issue.

• A note about authentication: Applications accessing the Graph API must authenticate using the Microsoft identity platform and the OAuth 2.0 protocol to acquire a Bearer token from Microsoft Entra ID.