Answered

Using Lookup in Gallery

Like (0) Share

Report

Posted on 5 Feb 2024 14:39:04 by cabutbul

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:

General Questions

All responses (8)

Answers (1)

cabutbul 63 on 06 Feb 2024 at 13:17:35

Like (0)

Report

Re: Using Lookup in Gallery

Working.
There was something with my lists.
I deleted them and created new.
Thx
Verified answer

Vaishu123 133 on 06 Feb 2024 at 12:15:55

Like (1)

Report

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.
cabutbul 63 on 06 Feb 2024 at 11:59:00

Like (0)

Report

Re: Using Lookup in Gallery

I don't want to insert, just to display the text in the GroupToPopulation column which is Lookup type
cabutbul 63 on 06 Feb 2024 at 11:55:18

Like (0)

Report

Re: Using Lookup in Gallery

Trying this also.
Still got an error
Vaishu123 133 on 06 Feb 2024 at 11:35:47

Like (0)

Report

Re: Using Lookup in Gallery

If you want to insert, use combo box and give below query in item property :
Choices([@GeneralSpecGroups].GroupToPopulation)
Vaishu123 133 on 06 Feb 2024 at 11:32:55

Like (0)

Report

Re: Using Lookup in Gallery

ThisItem.'GroupToPopulation '.Value
You dont not need to filter it again using Lookup function. In SharePoint itself you already connected with Lookup function.

Directly you can able to visible the items.
cabutbul 63 on 06 Feb 2024 at 06:30:27

Like (0)

Report

Re: Using Lookup in Gallery

LookUp(
GeneralSpecPopulation,
ID = ThisItem.GroupToPopulation.Population
).Population

Still got an error.
"Incompatible types for Comparison..."
Vaishu123 133 on 05 Feb 2024 at 14:53:36

Like (0)

Report

Re: Using Lookup in Gallery

ThisItem.GroupToPopulation.Population

try this one