web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : t+BYCsAI2540FqnTi4qNWn
Power Apps - Microsoft Dataverse
Answered

add column from related table to view

Like (0) ShareShare
ReportReport
Posted on 18 Aug 2023 10:46:43 by 120

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?

Categories:
I have the same question (0)
  • Mahendar Pal Profile Picture
    191 on 18 Aug 2023 at 13:02:39
    Re: add column from related table to view

    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.

  • Craigja Profile Picture
    120 on 18 Aug 2023 at 12:58:14
    Re: add column from related table to view

    Is it not possible to create a dashboard or page or something else that shows this though?

  • Mahendar Pal Profile Picture
    191 on 18 Aug 2023 at 12:46:13
    Re: add column from related table to view

    Hi,

     

    You can only add current entity and parent entity (lookup entity) field in your entity view.

  • Craigja Profile Picture
    120 on 18 Aug 2023 at 12:45:50
    Re: add column from related table to view

    OK, that makes sense - suppose i can do something like a PowerBI to display what I want

  • Verified answer
    Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 18 Aug 2023 at 12:33:35
    Re: add column from related table to view

    Hi @Craigja ,

    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.

  • Craigja Profile Picture
    120 on 18 Aug 2023 at 12:28:50
    Re: add column from related table to view

     If i look in relationships I see a one to many between the apps table and the custodians table

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 18 Aug 2023 at 11:01:02
    Re: add column from related table to view

    Hi @Craigja ,

    What is the current relationship between the two tables?  

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 752 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 472

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 358 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Loading started
Loading complete