Skip to main content

Notifications

Community site session details
Power Apps - Microsoft Dataverse
Answered

Table with many-to-many relationship

Like (0) ShareShare
ReportReport
Posted on 16 Jan 2023 13:11:49 by 32

Hi, I would like to know if Dataverse allows you to have a view or to visualize the table from the relatioship many-to-many between two tables. For example, If I would like to have a resume of the association of two tables, can I visualize it on a table which contains the data from the two tables?

  • Ethan_Power Profile Picture
    115 on 14 Dec 2023 at 22:33:14
    Re: Table with many-to-many relationship

    The only way I know to access the hidden many-to-many relationship table is through a Dataflow. You might be able to copy the contents to a new table in order to view the contents. I wonder if you could create another dataflow to feed the new table data back into the source data -- assuming you want to make edits. It's risky, but it might be worth the effort?

  • Verified answer
    Guido Preite Profile Picture
    1,488 Super User 2024 Season 1 on 16 Jan 2023 at 16:46:17
    Re: Table with many-to-many relationship

    when you create a N:N relationship Dataverse create automatically a table with only the two primary keys of the connected tables, afaik there isn't a OOB way to display the content of these tables or content from both tables at the same time

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

Understanding Microsoft Agents - Introductory Session

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

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,081 Most Valuable Professional

Leaderboard

Featured topics

Loading started
Loading started
Loading complete