web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dataverse for Teams su...
Power Apps
Answered

Dataverse for Teams support for many-to-many relationships

(0) ShareShare
ReportReport
Posted on by 7

Hello everyone

I apologize but I don't really find anything around to solve my problem.

I'm building a Power App for Microsoft Teams, using the build environment directly in Teams, I know there are some limitations, but I don't understand how many-to-many relationships work in dataverse for Teams.
I've never built any powerapps before, I started directly in Teams, most of the app is ok, but there is something that I don't underastand, and all the documentation out there is for "regular" power apps.

I created two custom tables that I tried to relate with a many-to-many relationship, but the result is not what I expected and I don't know if I'm missing something or if something is wrong in the build environment...

first question: I expected a relationship table would have been created, but no sign of it. is it correct? or should Isee it in my table list?

second question: I expected a new field in both tables that references the other table related items, but non sign of it. Again, is it correct? Honestly I don't think so, but I'm not sure.
So basically I'd like to know if working in Teams is different in some way in this particular context.
Thank you.

I have the same question (0)
  • Verified answer
    Hamish Sheild Profile Picture
    3,005 Most Valuable Professional on at

    Hi @robymes ,

     

    Many-to-many relationships work in Dataverse for Teams the same way as they do for regular Dataverse. 

     

    Q1. When you create a many-to-many relationship there is an intersect table created in the background but Microsoft have tried to simplify things so it is hidden and you can't access it directly.  Take a look at this article as it might help you work with N:N relationships in a Canvas Power App with Teams.

     

    Q2. This is correct, new fields do not get created on either table with a N:N relationship 

     

    If you want to see an intersect table that defines the N:N relationship you can create one manually.  You do this by creating a 3rd table and relating the other 2 tables to it with a N:1 relationship.  For example, you have tables A, B and C and you want C to be your intersect table and A & B to have a N:N relationship.  Create N:1 relationships between C and A, and also C and B such that entity C has two lookup fields that are A & B.  The additional advantage about the manual N:N relationship is that you can store additional attributes on entity C which describe the relationship.  A good example of this are tables to represent Hotel (A), Guest (B) and Booking (C) where the Booking table describes a relationship between the Hotel and the Guest (of which there could be many!)

     

    I hope this helps

     

  • robymes Profile Picture
    7 on at

    Thank you very much!

    Cristal clear and detailed
    I think I will go with manual solution, better to manage

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard