Answered

Get Related records from the same table as a Subgrid

(0) Share

Report

Posted on by rameshmukka

1,115

I have a Stocks table and Sites table in my model driven solution. Also the Site column in Stocks table is lookup column to Sites table. My requirement is when I open a X record from my Stocks table and it has value "Bedford" for Site Column, I would like to show the related records from the same Stocks table with Site Column value "Bedford".

As you can see below, the subgrid is showing me all the records (from the Stocks table) from the view which I set as default for subgrid. But I would like to show only the ones with Site Column value coming from the form above. Please help in this regard. Happy to clarify any questions regarding my post.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @RameshMukka,

To show "sibling" Stock records, what you can do is create a Quick View Form for the Site table. Add a single subgrid to the quick view form, ensure Related records is checked, then select Stocks as the table.

On your Stock form, insert a Quick View Control. Select Site as your Lookup field, Site as Related table, then pick the Quick View Form you just created.

---
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
rameshmukka 1,115 on at

Like (0)

Report

@ChrisPiasecki How can I thank you enough for the solution? Thank you so much once again.

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

Like (0)

Report

No problem happy to help! 🙂

Was this reply helpful? Yes No
md7 232 on at

Like (0)

Report

Hi there, Sorry to jump on this topic.

I've managed to do what you've said but I'm wondering if it's possible to filter out the stock (in this case) that I'm viewing from the list in the quick view. At the moment, the stock i am viewing appears in the list in the quick view as well.

Thanks.

Was this reply helpful? Yes No