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:

Using Apps Using Formulas

All responses (3)

Answers (0)

WarrenBelz 146,609 Most Valuable Professional on at

Like (0)

Report

Re: Avoiding to many lookups in a grouped by gallery

Hi @Corissandageri ,

Please provide more information on the other fields you want involved.
R Bakker 725 on at

Like (0)

Report

Re: Avoiding to many lookups in a grouped by gallery

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
WarrenBelz 146,609 Most Valuable Professional on at

Like (0)

Report
Re: Avoiding to many lookups in a grouped by gallery

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