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

Announcements

News and Announcements icon
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,687 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 431

#2
WarrenBelz Profile Picture

WarrenBelz 360 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 280 Super User 2026 Season 1

Last 30 days Overall leaderboard