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 / Get dataverse table Co...
Power Apps
Unanswered

Get dataverse table Column value in powerapps dropdown

(0) ShareShare
ReportReport
Posted on by 6

i m stuck in solution where i am unable to get the data from dataverse table Column which is a lookup of contact entity into the dropdown.

i m trying this DataverseTableName.ColumnName which should technically work, but its not working.

 


 

error.PNG
I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @Syed_Ahmad ,

     

    What type of field is your "Request Submitter".  Not sure if this is something like an Owner field in Dataverse where it could be a team or a user.  It might not be able to reference through the value because it could be a Team or a SystemUser value.

     

    Example, just doing this on the Account entity against the Owner, I had to do the following to display the full name when selecting the record from the gallery (and I know in my case this is owned by a User...

    Gallery1.Selected.'Owning User'.'Full Name' 

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    Hello, @Syed_Ahmad, you have to use the function Choices()

     

    Choices(TableName.'Request Sumitter').fullName

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

  • Syed_Ahmad Profile Picture
    6 on at

    :Hi @AhmedSalih 

    Choices(TableName.'Request Submitter').fullName this function will give lookup values. In my case, I want 'Request Submitter' Column data. I tried this TableName.'Request Submitter'.FullName this is not working.

  • Syed_Ahmad Profile Picture
    6 on at

    Hi @dpoggemann 

    It's a Lookup field, Lookup with Contact Entity.

  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @Syed_Ahmad ,

     

    I created a dropdown box and populated with Contacts.'Full Name' and this provided me all of the contact names to choose from, which I would expect is what yo are trying to do?

     

    If you want to reference for a specific record then something like this will work (if you have a gallery and you want to view the value):

    Gallery1.Selected.'Request Submitter'.'Full Name'

     

    Maybe I am missing what you are trying to do.  I did notice that you have FullName vs. 'Full Name' in your examples...

  • AhmedSalih Profile Picture
    6,680 Moderator on at

    @Syed_Ahmad, If you are using Dataverse for Teams, this is a known issue in Combo Box for Teams.

    Select the Combo Box control and then click the edit icon on the right pane of your screen, then select this new added field.

    AhmedSalih_0-1662471032792.png

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 273

#3
Kalathiya Profile Picture

Kalathiya 232 Super User 2026 Season 1

Last 30 days Overall leaderboard