Skip to main content
Community site session details
Power Apps - Building Power Apps
Answered

Using Lookup in Gallery

Like (0) ShareShare
ReportReport
Posted on 5 Feb 2024 14:39:04 by 63

Hi

I have two lists in SHAREPOINT, one named GeneralSpecGroups and the other named GeneralSpecPopulation.
In the GeneralSpecGroups list I have a column called Group Name and a Lookup column called GroupToPopulation that is connected to the GeneralSpecPopulation list to the Population column.
I want to display the GroupToPopulation column in powerapps within a gallery whose database is GeneralSpecGroups.
How can i do it?

 

I tried this, but got an error:

 

LookUp(
   GeneralSpecPopulation,
   ID = ThisItem.GroupToPopulation.ID
).Population
Categories:
  • Verified answer
    Vaishu123 Profile Picture
    133 on 06 Feb 2024 at 12:15:55
    Re: Using Lookup in Gallery

    Its perfectly working for me....
    I created both list and columns as mentioned by you. 
    Inserted a gallery and connected with GeneralSpecGroups
    Inserted a Text label field and added below code in Text property  

    ThisItem.'GroupToPopulation '.Value


    1. Try to reconnect the datasource in gallery

    2. Make sure the datatype of SharePoint columns and gallery items correct. 
    3. Try to create new Gallery if its not working incase there is no issues in data types. 

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete