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 / Using Lookup Fields in...
Power Apps
Answered

Using Lookup Fields in a Gallery - Within a Component

(0) ShareShare
ReportReport
Posted on by 158

This is a bit different than my original thread, so I've created a new topic.

Old Thread:
https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-use-a-gallery-in-a-component/m-p/471925#M141571

 

I'm able to reference all the fields of the entity I have set as the "Items" property of my gallery component - except the lookup fields.

None of them are showing up in these drop downs you get:

Screen Shot 2020-02-17 at 8.14.10 PM.png

Categories:
I have the same question (0)
  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Connor55 ,

    Do you want to display LookUp field value from your CDS Entity within this Gallery Component directly?

     

    If you want to display the LookUp field value from your CDS Entity within this Gallery Component directly, I afraid that there is no way to achieve your needs in PowerApps.

     

    Actually, the data field you could display within the Gallery Component is based on the table structure you defined within the Items property of the embedded Gallery within this Component. But only simple data type fields are supported in the Items property of the  embedded Gallery, the complex data type fields (e.g. LookUp type, Option Set type, Two Options type, ... etc) are not supported.

     

    As an alternative solution, you could consider define a simple data type field within the Items property of the embedded Gallery within this Component:

    Table({
     ProductName: "SampleText", 
     ProductionArea: "SampleArea", 
     Price: 100, 
     LookUpFieldValue: "SampleLookUpValue" // Add this new data field to display LookUp column value
     })

    4.JPG

     

    Then within your app screen, insert above Gallery component. Then set the Items property to following:

    AddColumns(TaskLists, "NormalContactFullName", 'Normal Contact'.'Full Name')

    Note: The 'Normal Contact' is a LookUp type field in my TaskLists Entity.  Pull the 'Full Name' property under the 'Normal Contact' field into a new column name "NormalContactFullName", then you could bind the LookUpFieldValue property specified in above Gallery component to the "NormalContactFullName" column.

    On your side, you may need to type following formula:

    AddColumns('CDS Entity', "LookUpColumnValue", 'LookUp Field'.DisplayColumn)

    Replace the DisplayColumn with actual column name under the "LookUp Field", DisplayColummn represents the column value you want to display within the Gallery component

     

    After that, the LookUpFiledValue could display within the Gallery component as below:

    5.JPG

     

    Best regards,

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 387

#2
timl Profile Picture

timl 340 Super User 2026 Season 1

#3
Vish WR Profile Picture

Vish WR 301

Last 30 days Overall leaderboard