How-To | Create a BC OData Custom Connector in Power Automate (Video)

When using Power Automate, have you ever felt that the BC Connector together with the Microsoft API v2 for Business Central does not deliver a lot of tables? Or, have you ever felt that the tables that are provided don’t have many of the fields that you actually need? 🕵️‍♂️

What if you customized a table?… Have you ever been blocked from actually seeing those fields in Power Automate?

Well, suffer no more…

The default BC Connector is great, don’t get me wrong: it has quite a few features that makes BC integrate seamlessly with Power Automate. However, when it comes to actually accessing data, specially custom data, users are out-of-luck 💔, left only with the option of creating their own custom API… or so they thought.

In this video, I’ll be showing you how you can cover some of the default BC Connector shortcomings, by using a custom Power Automate connector to access Business Central OData Web Services.