Unanswered

can see related records in 1:N table, not in N:1

(1) Share

Report

Posted on by blaisecorneloup

Hi everyone,

I defined a 1:N relation between 2 tables in dataverse. When I'm looking for associated records in the "1" table, I can see them. But when I try to do the same operation in the "N" table, nothing is showing up. I tried to add a subgrid in the form of my "N" table, but the related table does not appear. Where Am I wrong ? Thanks for your help.

Regards

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @blaisecorneloup,

That's expected that you won't see the related records from the N side of the relationship, as there is only one record it can be related to. The Lookup field would show the 1 side of the relationship from the N perspective.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
blaisecorneloup 73 on at

Like (0)

Report

Thank you @ChrisPiasecki. How can I get around this ?

Was this reply helpful? Yes No
Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @blaisecorneloup,

You cant get around this, this is out of box behavior with relationships. In the related tab you will only see tables that have a N:1 relationship with the table, not the other way around.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
blaisecorneloup 73 on at

Like (1)

Report

Ok, I'm gonna try to deal with it. 1 last question please, why there is no 1:1 relation ?

Was this reply helpful? Yes No