Power Platform Community Forum Thread Details

I am building an app on Dataverse for teams. One of my tables has a OOB self-referential many-to-many relationship.

The query Gallery.Selected.TableNames searches only in one direction - ThisItem is pointing to many others.

I would need to query the other direction - many others pointing to this ThisItem.

In a model driven app you see both directions

In power automate the expand query for one direction is RelationshipName for one and RelationshipName_referenced for the other direction.

Can this be accomplished in Canvas as well? Thanks in advance

Categories:

How to query a self referential many to many relationship?