Unanswered

Subgrid with two relations to the same table

(0) Share

Report

Posted on by schmucker

I have a Offers table where there is a m:1 relation to a Target table called Primary target.

In the same Offer table I also have another relation called Alternative target also m:1 to the same Target table.
This means that a offer can relate to two different targets one primary target and one alternative target.

My goal is that on my main form for Targets I have to show a subgrid that shows both the primary and alternative offers for the given Target, but all in one and the same grid view on the form.

It's not a problem to show them in two different subgrids but I'd really like to merge it into one.

Is it possible and how?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @schmucker ,

Could you just add a choice column on the Offer table called Offer Type that would contain the values of Primary, Secondary and then you could relate to the Target table with this. This way on the Target table you could add the sub-grid of the Offers and show the Offer Type column to show both the Primary and Secondary offers.

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @schmucker,

You could use an embedded Canvas App to show a gallery and filter where Primary Target or Secondary target equals the current record.

---
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