More than one Dataverse Table in a Form View

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

I have a canvas app that I am converting to a model driven app, it has separate tables for Event, Volunteers, and Materials. Is there a way to have the data from the Volunteers and Materials tables show on the Events form view?

The tables have a relationship on Event Id.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

AhmedSalih 6,680 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hello, @gfeldhake , yes, you can use the SubGrid Control in the Form.

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
GF-02121351-0 239 on at

Like (0)

Report
Copy link

Link copied!

Thank you, how do I get the sub grid to filter by the selected Event ID? Right now, it is showing all volunteers regardless of the selected event.

Was this reply helpful? Yes No
gulshankhurana 1,397 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @gfeldhake

When you add the subgrid control, there is a tick-box option to "Show related records" only. If you tick that option when you add the subgrid, you'll get only the records related to the parent Event.

I hope this information helps.

Kind regards
Gulshan
Please give it a thumbs up 👍🏻 if you appreciate my efforts.
If my answer helped you resolve your issue then please also mark it as a solution ✅ so that it helps others experiencing the same problem.

Was this reply helpful? Yes No