You’re offline. This is a read only version of the page.
Hi,
I'm new to Dataverse for Teams so any guidance would be much appreciated. We are looking to move from our existing Sharepoint/Power Apps to using D4T. Some of our data tables are large, so to maximise the capacity allowed across our 5 Teams D4T environments, I was wondering whether we could set up relationships between entities in different environments and, if so, how to implement it as per below example as when setting relationships the only tables available appear to be those within the same environment?
Environment D4T One, Entity "Customers" has a 1-N relationship set up with Entity "Orders" in Environment D4T Two
@Stevejm, that is correct, you can use multiple data sources within PowerApps (Canvas).
But you can't build direct relationship from within Dataverse. Just make sure you have your Primary Keys and Foreign Keys in place. For instance, your Parent Table in Environment A and your Child Table in Environment B, use Lookup to Retrieve related records of the Child Table in B = Filter(ChildTable,
ForeignKey=ParentTablePrimaryKey)
Regards,
Ahmed
If my reply helped you, please give a đź‘Ť. And if it has solved your issue, please consider a đź‘Ť & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com
Hi Ahmed,
Thanks for the response but I'm still confused as in the FAQs for Dataverse for Teams https://docs.microsoft.com/en-us/power-apps/teams/data-platform-faqs it states the below?
Can I use tables from other environments?
Applications can include data from environments that the maker has access to within the current tenant.
Hello @Stevejm, You can't have relationships between entities in separate environments.
Regards,
Ahmed
If my reply helped you, please give a đź‘Ť. And if it has solved your issue, please consider a đź‘Ť & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com
#1
stampcoin
17
#2
mmbr1606
13
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
