Answered

Using Lookup in Gallery

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Vaish123 136 on at

Like (0)

Report

ThisItem.GroupToPopulation.Population

try this one

Was this reply helpful? Yes No
cabutbul 63 on at

Like (0)

Report

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

Still got an error.
"Incompatible types for Comparison..."

Was this reply helpful? Yes No
Vaish123 136 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Vaish123 136 on at

Like (0)

Report

If you want to insert, use combo box and give below query in item property :
Choices([@GeneralSpecGroups].GroupToPopulation)

Was this reply helpful? Yes No
cabutbul 63 on at

Like (0)

Report

Trying this also.
Still got an error

Was this reply helpful? Yes No
cabutbul 63 on at

Like (0)

Report

I don't want to insert, just to display the text in the GroupToPopulation column which is Lookup type

Was this reply helpful? Yes No
Verified answer

Vaish123 136 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
cabutbul 63 on at

Like (0)

Report

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

Was this reply helpful? Yes No