LookUp inside Gallery Items Property

(0) Share

Report

Posted on by MicaBassi

Hey, I need some help with a Gallery. This is the items property that I have for that gallery:

Filter('public.table1', condition = true && state_id <> 6 &&

LookUp(

'public.table3',

LookUp(

'public.table2',

last_id = id,

result_id

) = id,

number_result

) < 0.85

))

With this Items property, the gallery is not returning any results, but this is incorrect as I have confirmed against the real data in the datasource and items should appear. If I remove the nested LookUp, it works, so I think the issue is there.
The reason for a nested LookUp is because I need the value in "number_result" column, but to join from table1 to table3, I need to go through table 2. Then I need to filter my gallery for those in table1 where number_result is lower than 0.85.

Any clues on why the nested lookup doesn't work inside the gallery? Is there another way that I could solve this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @MicaBassi

try setting up a collection and filter based on that.

try this in visible of screen:

ClearCollect( CollectedTable2And3, AddColumns( 'public.table2', "number_result", LookUp('public.table3', id = result_id).number_result ) )

and this for filtering the gallery:

Filter( 'public.table1', condition = true && state_id <> 6 && LookUp(CollectedTable2And3, last_id = id).number_result < 0.85 )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
MicaBassi on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mmbr1606 , thanks for your suggestion! I tried this but the Collection doesn't load any rows. I think it might be because table2 has a huge amount of records (around 14000 rows) and takes a lot of time to go through it. I had to remove it because the performance of the app became awful 😞
Any other ideas? Maybe, is there a way that I can "add" number_result as a column in table1 virtually, like inside powerapps? and not modifying the actual datasource.

Thanks

Was this reply helpful? Yes No