Unanswered

Loading Speed of data on Power Apps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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