Notifications
Announcements
Hi - I have a table, applications and another table, custodians, I have it all working fine in the form, I can add one or more users to an applications etc. On the view though, I want to add the column showing who is the custodian, how do I do this?
Hi @Craigja ,
What is the current relationship between the two tables?
If i look in relationships I see a one to many between the apps table and the custodians table
If you are viewing the Applications table view you will not be able to add the custodians to the view because it is a "One to Many" so it does not have a single value to choose. You would be able to add the Application to the Custodian view (using Related when adding fields to the form) since the Custodian has a lookup field to the Application you can add any application field to the Custodian view.
OK, that makes sense - suppose i can do something like a PowerBI to display what I want
Hi,
You can only add current entity and parent entity (lookup entity) field in your entity view.
Is it not possible to create a dashboard or page or something else that shows this though?
How about creating a report and do grouping based on the parent entity. You can do this using out of the box report wizard or can create custom report.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 721 Most Valuable Professional
Michael E. Gernaey 320 Super User 2025 Season 2
Power Platform 1919 268
