Display data from another table, where the relationship is many-to-one for data powering the form.

(0) Share

Report

Posted on by DigitalMT-02

I have a simple dataverse table (tbl_Vendor) withs vendor information.

I have a screen that has:

- A galley form (galVendor) for vendor selection

- A Vendor Info display form (dispVendor)

I recently added another table (tbl_Comment) to hold comments concerning the vendors in tbl_Vendor.

This table (tbl_Comment) has a relationship with the vendor table (tbl_Vendor) through the addition of a lookup column (lu_Vendor) in the Comment table that allows you to select a vendor record.

I want to add a new form (frmComment) to the screen, that will display any existing comment for the vendor selected in the gallery. But I cannot figure out how to setup the form (frmComment) to display all comments for that selected vendor.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello, @DigitalMT-02, form control can only display one record of a table. If you want to display all comments from the comment table, I suggest you use either a gallery or a table control. The items property of the control should be GalleryName.Selected.lu_Vendor << know that you don't need a Filter function to retrieve the related child records when you do have relationship in place.

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

if you are using a model driven app the best way is to use your vendor form and add a sub grid control that is using the related comments. Or create a new form on vendor table and do the same thing.

Was this reply helpful? Yes No