Avoiding to many lookups in a grouped by gallery

(0) Share

Report

Posted on by R Bakker

725

Hi everyone

More a question of good practice. I have a Groupedby gallery

GroupBy(FinalInspections,"FIProductCode","FData"). So FIProductCode codes look like V122M or HHM213 and so on, however all the specifications or and upper an lower limits pertaining to that code are in a separate list. Therefore the titles for the child gallery look something like. "Piece count " & LookUp(ProductCode,PCCode=ThisItem.FIProductCode,PCMinCount &"-"& PCMaxCount) and so I have to do this for four different column headers. Is there a way I can do a single lookup?, keeping in mind this renders without a button press.

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
Hi @Corissandageri ,

Do you mean something like this ?

AddColumns( GroupBy( FinalInspections, "FIProductCode", "FData" ), "PieceCount" "Piece count " & LookUp( ProductCode, PCCode = FIProductCode, PCMinCount & "-" & PCMaxCount ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

Hi Warren
I have Piece count upper and lower, Weight upper and lower and Defects percent no greater than. At the moment I am doing three separate lookup's based on the Product Code. As the gallery holds a lot of data, I want to make it as performant as possible.

AnalyserEdit.png

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

Hi @Corissandageri ,

Please provide more information on the other fields you want involved.

Was this reply helpful? Yes No