Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : caT6q9oOQfXJo4hxERP3Pf
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Dataverse for Teams En...
Power Apps - Microsoft Dataverse
Answered

Dataverse for Teams Environments - most efficient way to use capacity

Like (0) ShareShare
ReportReport
Posted on 6 Aug 2022 06:12:20 by Stevejm 68

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:
Tables
Entities
Microsoft Dataverse
  • Verified answer
    Stevejm Profile Picture
    Stevejm 68 on 08 Aug 2022 at 12:25:58
    Re: Dataverse for Teams Environments - most efficient way to use capacity

    Aha, thanks very much Ahmed for your assistance

  • Verified answer
    AhmedSalih Profile Picture
    AhmedSalih 6,678 Super User 2025 Season 1 on 08 Aug 2022 at 12:11:46
    Re: Dataverse for Teams Environments - most efficient way to use capacity

    @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

  • Stevejm Profile Picture
    Stevejm 68 on 08 Aug 2022 at 07:43:44
    Re: Dataverse for Teams Environments - most efficient way to use capacity

    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.

     

     

     

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 Super User 2025 Season 1 on 07 Aug 2022 at 23:09:50
    Re: Dataverse for Teams Environments - most efficient way to use capacity

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans