Data Connectors

References

https://docs.microsoft.com/en-us/learn/modules/introduction-power-platform/3-data-connectors

Microsoft Power Platform is made powerful by its ability to leverage data across many platforms. To do this, components of Microsoft Power Platform use connectors.

You can think of connectors as a bridge from your data source to your app or workflow which allows information to be conveyed back and forth.

Connectors allow you to extend your business solutions across platforms and add functionality for your users.

Data Sources

In order to understand the types of connectors and what you can do with them, you must first understand the types of data sources to which they connect. The two types of data sources are tabular and function-based.

Tabular data - A tabular data source is one that returns data in a structured table format. Power Apps can directly read and display these tables through galleries, forms, and other controls. Additionally, if the data source supports it, Power Apps can create, edit, and delete data from these data sources. Examples include Microsoft Dataverse, SharePoint, and SQL server.

Function-based data - A function-based data source is one that uses functions to interact with the data source. These functions can be used to return a table of data but offer more extensive action such as the ability to send an email, update permissions, or create a calendar event.

Examples include Office 365 Users, Project Online, and Azure Blob Storage.

Both of these data source types are commonly used to bring data and additional functionality to your solutions.

As you can see, connecting to data sources allows you to integrate disparate parts of your business solutions to build them out cohesively.

Connectors

Now that you understand more about data sources, you are ready to learn about connectors.

Connectors are the bridges from your data source to your app, workflow, or dashboard. Microsoft Power Platform has more than 600 connectors available to common data sources.

Connectors are divided into standard and premium. Some popular standard connectors are SharePoint, Outlook, and YouTube. Premium connectors require additional licensing for your app and/or users.

A few premium connectors are SQL Server, Survey Monkey and Mail Chimp. The connector reference in the summary and resources unit lists all connectors and whether they are considered standard or premium. You can also use AppSource to source and install apps and use the connectors to non-Microsoft services.

Connectors can provide input and output between the data source and Power Platform, which can accelerate the delivery of Microsoft Power Platform business solutions. For instance, using Dynamics 365 apps such as Customer Service, you can set up Power Automate to notify users when specific customer types are added.

Or you can use a SharePoint document library to store files that are fed into Power Apps to manage and distribute. Microsoft also provides connectors to their Azure services, providing advanced AI techniques to do tasks such as reading text off images or cognitive services like recognizing faces in images.

All Microsoft Power Platform business solutions can be used and implemented into Microsoft 365 apps such as Teams. This allows users to play Power Apps within Teams or run Power Automate from actions and events within Teams.

Triggers and Actions

Once you have established a data source and configured your connector, there are two types of operations you can use, triggers or actions.

Triggers are only used in Power Automate and prompt a flow to begin. Triggers can be time based, such as a flow which begins every day at 8:00 am, or they could be based off of an action like creating a new row in atable or receiving an email. You will always need a trigger to tell your workflow when to run.

Actions are used in Power Automate and Power Apps. Actions are prompted by the user or a trigger and allow interaction with your data source by some function. For example, an action would be sending an email in your workflow or app or writing a new line to a data source.

Now that you understand what connectors are and how to use them, let’s look at what to do when there isn’t a connector already built for your data source.

Custom Connectors

While Microsoft Power Platform offers more than 600 connectors, you also have the option to build a custom connector. This will allow you to extend your app by calling a public available API, or a custom API you are hosting in a cloud provider such as Azure.

API stands for Application Programming Interface and holds a series of functions available for developers. Connectors work by sending information back and forth across these APIs and gathering available functions into Power Apps or Power Automate.

Because these connectors are function-based, they will call specific functions in the underlying service of the API to return corresponding data.

An advantage of building custom connectors is that they can be using in different platforms, such as Power Apps, Power Automate and Azure Logic Apps.

Creating Custom Connectors

You can create custom connectors using 3 different approaches:

  • Using a blank custom connector.
  • From an OpenAPI definition.
  • From a Postman collection.

While the requirements for each approach will very, they all require a Power Apps per app or per user plan. Each link above points to the instructions for each approach.