Blog
Dataverse - how to access tables from another environment
February 23. 2021
From a canvas app, we can connect to Dataverse databases that are hosted in different environments. This post describes how to accomplish this.
Environments are containers for apps and Dataverse databases. Each environment can host a single Dataverse database, and it provides a place to store apps.
Let's suppose we build a canvas app, and we want to access tables from Dataverse databases that span multiple Environments from within the same tenant. How can we accomplish this?
The answer is relatively straightforward, but the option is slightly hidden away.
Let's suppose we build a canvas app, and we want to access tables from Dataverse databases that span multiple Environments from within the same tenant. How can we accomplish this?
The answer is relatively straightforward, but the option is slightly hidden away.
By default, the data panel shows tables that belong to the current environment
To add a table from a different environment, we click the elipses button next to 'Entity' heading. This opens a panel with a 'Change environment' menu item. We can click this to select a different environment, and to choose a table that belongs to the other environment.
As the screenshot beneath shows, it's possible to add the accounts table from two different environments, and we can build an app that consolidate data from multiple environments, or to copy data between tables in different environments.
Conclusion
- Categories:
- dataverse
Related posts
- Error - Diagnosing the error "Network error when using the Patch function" when saving data with a form
- Dataverse - How to work around the error "multiple levels of many-to-one relationship expansion aren't supported"
- Dataverse - The easiest way to modify Dataverse data outside of Dataverse and Power Apps
- Dataverse - How to use a checkbox control a set a yes/no field in Dataverse
- Dataverse - How to create Entity Relationship diagrams
- Dataverse - How you can more quickly bulk update data using the SQL language
- Dataverse - How to fix the bug in the 'Business Rules' editor that prevents numeric values from saving
- Dataverse - What are the benefits, and how to create formula columns
- Dataverse - How to sort the available choice items from a choice column
- Error - Unable to modify Dataverse tables with error message, Language id should not be null
- Dataverse - How to retrieve FetchXML or SQL for Dataverse views
- Data - Why is Dataverse so fast?
- Dataverse - How to create and use Dataverse views in Canvas Apps
- Dataverse - How to filter Dataverse choice columns
- Dataverse - How to switch to the classic designer when the option is not available
- Licensing - What are Dataverse Restricted tables?
- Media - How to save and work with microphone recordings
- Dataverse - How to Patch the 5 most complex data types