Connect to other environments using the Microsoft Dataverse connector (preview)
[This topic is prerelease documentation and is subject to change.]
You can automate apps, data, and processes across Power Platform environments through supported actions and triggers in the Microsoft Dataverse connector.
Important
- This is a preview feature.
- Preview features aren’t meant for production use and may have restricted functionality. These features are available before an official release so that customers can get early access and provide feedback.
Previously, the Microsoft Dataverse connector supported the flow's current environment. The Dynamic 365 (deprecated) and Microsoft Dataverse (legacy) connectors were the available ways to connect to Dataverse in other environments from cloud flows. With the addition of the Environment parameter, the Microsoft Dataverse connector's triggers and action have the same flexibility of connecting to either the flow's current environment or choosing another.
During the preview of this capability, separate actions and triggers with names ending in selected environment (preview) are available to add to both new and existing flows. After the preview, Dataverse connector actions in existing flows will be automatically updated to include the Environment parameter. There's no action needed from flow owners or changes to existing flow behavior as part of this update.
Important
The updated actions with the Environment parameter are rolling out as a public preview to all Power Platform regions by the end of October 2023.
The following diagram shows a Power Automate cloud flow being triggered when a row changes in the Contoso Support environment. It takes actions in other Contoso Services and Contoso Field Service environments to list rows, add a row, and perform an action in the example Contoso Corporation's Microsoft Entra tenant.
Add actions that connect to other environments
Sign in to Power Automate.
Create a new cloud flow such as an instant flow with the Manually trigger a flow trigger.
Alternatively, you can open an existing flow.
In the flow designer, select the plus sign (+) to add a new action.
Search for dataverse, and then select See more on the Microsoft Dataverse connector to see all available actions.
Add one of actions that ends in selected environment (preview), such as List rows from selected environment (preview).
Use the Environment parameter in the action card to choose the environment to connect to. The connection you use for the action must have permissions to perform the operation in the other environment.
To connect to Dataverse in the same environment as the flow, select (Current) in the Environment parameter.
Actions and triggers that can connect to other environments
The following Microsoft Dataverse connector actions support connecting to other environments. In the flow designer, the preview actions with the environment parameter have names ending in selected environment (preview) for each of the following actions.
- Add a new row
- Update a row
- Delete a row
- List rows
- Get a row by ID
- Perform a bound action
- Perform an unbound action
- Relate rows
- Unrelate rows
- Upload a file or image
- Download a file or image
The actions to search rows and perform a changeset request don't have preview actions with the Environment parameter yet.
The following triggers support connecting to other environments but haven't been released yet:
The following triggers won't support the Environment parameter since they're only applicable to the same environment the flow is located in.
- When a flow step is run from a business process flow
- When a row is selected
Features supported by the Environment parameter in the preview actions and triggers
- Connect to other environments in the same tenant as the connection used with the action or trigger.
- Connect to environments in other tenants when using a connection to another tenant.
- To restrict connections to other tenants from the Microsoft Dataverse connector and other connectors, you can configure Power Platform tenant isolation policies. To learn more, go to Cross-tenant inbound and outbound restrictions.
- Specify the environment dynamically.
- Service principal connections can be used to connect to other environments.
Add actions that connect to other environments dynamically
To set the Environment parameter dynamically instead of selecting a specific environment, select Enter custom value at the end of the Environment parameter selector and provide the root URL of a Power Platform environment in the format https://<yourenvironmentid>.crm.dynamics.com/
. The URL can be provided as a string, expression, environment variable, or as dynamic content from the trigger or other actions in the flow.
To get the root URL of an environment, you can open the details page of the environment from the Power Platform admin center, or use the output of the List user environments action in the Power Automate Management connector.
For actions like Add a row that depend on the specific table schema from one environment, the schema won't be automatically retrieved when specifying the environment dynamically. The request must be manually created using the LogicalCollectionName
of the table and the body for the request in JSON format, similar to a Dataverse Web API request. For example, accounts and { "name": "Contoso Marketing" }.
Best practices
- For best performance, deploy flows using the Microsoft Dataverse connector to the same Power Platform environment as the data and apps they are connecting to.
- The Microsoft Dataverse connector in Power Automate is optimized to directly connect to Dataverse through a native integration when the Environment parameter is set to
(Current)
. - When connecting to other environments, it connects through the Power Platform connectors platform.
- The Microsoft Dataverse connector in Power Automate is optimized to directly connect to Dataverse through a native integration when the Environment parameter is set to
- Review recommended admin and governance practices around your Power Platform environment strategy when planning solutions that connect to other environments, including staging flows in separate development, test, and production environments for specific business groups and applications.
Limitations
- Using instant flows with the Dataverse connection set to Provided by run-only user isn't supported yet.
- The triggers When a row is added, modified or deleted and When an action is performed don't support the Environment parameter yet.
- The actions to Search rows and Perform a changeset request don't have preview actions with the Environment parameter yet.