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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Account column not sho...
Power Apps
Answered

Account column not showing in Canvas app Table

(0) ShareShare
ReportReport
Posted on by

My Dataverse custom table has Account column (Related to standard Account table) and I want to show that data in Canvas App Table control.

hyonta_0-1718908742394.png

This column data type is customer.

hyonta_0-1718910558745.png


But Canvas App Table control doesn't show this Account column.

Do you have any solution?

hyonta_1-1718908996438.png

 

Any opinion very helpful.

Thanks.

I have the same question (0)
  • Verified answer
    Ami K Profile Picture
    15,679 Super User 2024 Season 1 on at

    @hyonta - your screenshot indicates you have added the Customer data type, rather than a standard LookUp to the Accounts table. 

     

    The Customer data type is a special column type because unlike other LookUps, it is a polymorphic LookUp.

     

    It is not possible to add this data type into the modern Table control. Even when this control goes live, I doubt it would be possible because this data type could refer to more than one table.

     

    You can however display the column in the classic Gallery control using the IsType and AsType functions to identify the right Table you need. 

     

    For example, add a Label control into your Gallery and on the Text property, enter:

     

    If(
     IsType(
     ThisItem.Account,
     Accounts
     ),
     AsType(
     ThisItem.Account,
     Accounts
     ).'Account Name',
     AsType(
     ThisItem.Account,
     Contacts
     ).'Full Name'
    )

     

  • hyonta Profile Picture
    on at

    Hi @Amik ,

    Thank you very much. You are lifesaver.

    I created another LookUp column related Account Table then I was able to show the data.
    Thank you very much once again.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard