ForAll(Sequence speed up?

(0) Share

Report

Posted on by Gochix

1,937 Moderator

Good day all.

Currently using a formula below for Collecting a new collection that contains Title,Zone,Week,Score.

Formula ends up having 52 weeks of each Title. Therefor it has to use Sum() formula to get a score for each title * 52 weeks.

I'm wondering if that's best practice possible to decrease wait time and efficiency?

52 weeks takes a good 1 minute to finish the process and sometimes crashes the app..

Any help will be appreciated.

ForAll(
 AreaTitles.AllItems, // gallery of all possible titles
 ForAll(
 Sequence(52),
 Collect(
 NewCharts,
 {
 Title: AreaTitle.Text, // gallery Title
 Zone: ZoneTitle.Text, // gallery zone
 Week: Value, // Value from Sequence
 Score: Round(
 Sum(
 LookUp(
 'Summary',
 Area = AreaTitle.Text && Week = Value,
 Score
 )
 ) / 7,
 1
 )
 }
 )
 )
);

Categories:

Building Power Apps