Unanswered

Loading Speed of data on Power Apps

(0) Share

Report

Posted on by Community Power Pla...

Is it possible some how to optimize this code:

Collect(
Days,
AddColumns(
Sequence1,
"Date1",
Date(varYear, varMonth, Sequence1[@Value]),
"Employees",
Filter(
colHolidays,
DateValue('First Day') <= Date(Year(DatePick_1.SelectedDate), Month(DatePick_1.SelectedDate), Sequence1[@Value])
&& DateValue('Last Day')>= Date(Year(DatePick_1.SelectedDate), Month(DatePick_1.SelectedDate), Sequence1[@Value])
)
)
)

I use this for holiday app. The problem is that my loading speed for the calendar is around 0.8-1.5s. Is it possible to make it better?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

There is probably some optimisation is there, but 0.8 to 1.5 seconds is quick by Power Apps standards. I am also unsure what you are doing with Sequence1 as you are then filtering a collection and the syntax seems a bit reversed.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I add days of the month with sequence collection:

ClearCollect(Sequence1, Sequence(Day(DateAdd(DateAdd(DatePick.SelectedDate,1,TimeUnit.Months),-Day(DatePick.SelectedDate),TimeUnit.Days)))),

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

Like (0)

Report

@Anonymous ,

I would need to build a model to try to test all of that and doubt that I would get it running any quicker with the various variations I might come up with.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Okay, thanks for your effort. If you come up with any Idea what I could try, let me know.

Was this reply helpful? Yes No