Skip to main content
Solved

Microsoft Flow integration with Airtable

A

Hello everybody, heavy airtable user here.
While developing the production+ecommerce+shipping tool for my company, I started to crash repeatedly against the microsoft integration walls. Basically there isn’t any integration to push/pull data from airtable to MFlow.
The only solution is using third parties integrators like Zapier. As crazy as it’s sound, microsoft don’t provide this integration inside the Microsoft Flow integrator.
This is also very condensed in a post on their forum which is 4 years old now, with people still asking for it: https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Airtable-Connector/idc-p/598121#M21464

I hope that maybe some pushing from Airtable itself could work, ending in a long awaited integration, as many of us end up with some company using microsoft soon or later…
Hope somebody can answer on this!

Best answer by Bill_French

Antonio, welcome to the community!

This is not true. I recently built a Microsoft Flow integration with Airtable using its webhooks API. It also supports a REST API so every integration imaginable with Flow is possible. It’s not easy (like with Zapier), but possible.

You need to understand that not every vendor believes integrations through “codeless” glu-factory services are a good thing; there are drawbacks and Microsoft is generally cautious about encouraging security tokens shared with other services that exist in countries with different privacy laws. No company or product should be blamed for trying to protect your data. :winking_face:

The current Airtable API works really well with Microsoft Flow webhooks, you just need to get someone involved who is skilled at these disparate APIs.

View original
    S
    1 person likes this
    • S
      Shandi_Greve_Pe
    Did this topic help you find an answer to your question?

    3 replies

    B
    • Bill_French
    • Inspiring
    • 3264 replies
    • Answer
    • June 17, 2020

    Antonio, welcome to the community!

    This is not true. I recently built a Microsoft Flow integration with Airtable using its webhooks API. It also supports a REST API so every integration imaginable with Flow is possible. It’s not easy (like with Zapier), but possible.

    You need to understand that not every vendor believes integrations through “codeless” glu-factory services are a good thing; there are drawbacks and Microsoft is generally cautious about encouraging security tokens shared with other services that exist in countries with different privacy laws. No company or product should be blamed for trying to protect your data. :winking_face:

    The current Airtable API works really well with Microsoft Flow webhooks, you just need to get someone involved who is skilled at these disparate APIs.

    A
    1 person likes this
    • A
      Antonio_Gaglia1
    A
    • Adam_Minich
    • Inspiring
    • 104 replies
    • October 22, 2021

    Though I can’t speak to its effectiveness, a customer shared with me that there is now a connector between the two services that can read/write to Airtable from a few different services that Microsoft offers. :winking_face:

    B
    1 person likes this
    • B
      Baden_Appleyar1
    M
    • MarkPercival
    • New Participant
    • 1 reply
    • October 29, 2021

    We’ve been working on a couple of ways of connecting Power Automate and Apps directly with Airtable. There are existing Swagger implementations but they don’t give you easy access to all the fields.

    We’ve built an open source app that lets you quickly build a custom Swagger file based on your Airtable data and import it into Automate as a Custom Connector.

    You can find the self-serve application here:

    Flyweight - Airtable to Swagger (flyweightcloud.github.io)

    Or run the code directly on your system here:

    flyweightcloud/airtable2swagger: A swagger builder for creating Airbase definitions directly from th…

    Reply


    Most helpful members this week

    Terms & Conditions