Notifications
Announcements
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?
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
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?
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 717 Most Valuable Professional
Michael E. Gernaey 329 Super User 2025 Season 2
Power Platform 1919 268