Answered

Dataverse for Teams Environments - most efficient way to use capacity

(0) Share

Report

Posted on by Stevejm

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (2)

AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Stevejm 68 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Verified answer

Stevejm 68 on at

Like (0)

Report
Copy link

Link copied!

Aha, thanks very much Ahmed for your assistance

Was this reply helpful? Yes No