There are three primary steps:
Create a connection (provide credentials to data sources).
Create a connection set (identify environments for connections you created in the previous step).
Create a data integration project using a template (create or use predefined mappings for one or more entities).
Once you create an integration project, you get the option to run the project manually and also set up a schedule-based refresh for the future. The rest of this article expands on these three steps.
How to create a connection
Before you can create a data integration project, you must provision a connection for each system that you intend to work with in the Microsoft Power Apps portal. Think of these connections as your points of integration.
To create a connection
Go to Power Apps.
Under Data, select Connections and then select New connection.
You can either select a connection from the list of connections or search for your connection.
Create connection
Once you select your connection, select Create. Then you will be prompted for credentials.
After you provide your credentials, the connection will be listed under your connections.
Connection list
Note
Please make sure that the account you specify for each connection has access to entities for the corresponding applications. Additionally, the account for each connection can be in a different tenant.
