Unanswered

Table with many-to-many relationship

(0) Share

Report

Posted on by Veronica22

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (1)

All responses (2)

Answers (1)

Verified answer

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Ethan_Power 115 on at

Like (0)

Report

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?

Was this reply helpful? Yes No