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