Power Platform Community Forum Thread Details

I am loading 10 SharePoint records into the Powerapps gallery, however the loading is very slow and takes about 2 minutes which is not expected. I am using below code in Items property of the gallery. Is there any fault with my formula?

Please take a note that I have around 90 columns in my SharePoint list and I understand this is the reason for slowness.

Any alternative ways by which loading can be improved further?

If(
Len(HomeSearch.Text) <= 0,
Sort(
Filter(
'Event Details_1',
('End Date and Time' > Now() || 'Recurring End Date 1' > Now() || 'Recurring End Date 2' > Now() || 'Recurring End Date 3' > Now() || 'Recurring End Date 4' > Now() || 'Recurring End Date 5' > Now() || 'Recurring End Date 6' > Now() || 'Recurring End Date 7' > Now() || 'Recurring End Date 8' > Now() || 'Recurring End Date 9' > Now() || 'Recurring End Date 10' > Now())&&'Event Status'="Active"
),
'Start Date and Time',
Descending
),
Sort(
Search(
Filter(
'Event Details_1',
('End Date and Time' > Now() || 'Recurring End Date 1' > Now() || 'Recurring End Date 2' > Now() || 'Recurring End Date 3' > Now() || 'Recurring End Date 4' > Now() || 'Recurring End Date 5' > Now() || 'Recurring End Date 6' > Now() || 'Recurring End Date 7' > Now() || 'Recurring End Date 8' > Now() || 'Recurring End Date 9' > Now() || 'Recurring End Date 10' > Now())&&'Event Status'="Active"
),
HomeSearch.Text,
"Title"
),
'Start Date and Time',
Descending
)
)

Categories:

Building Power Apps

Hi @Iantaylor2050 ,

Please try below formula and see if there is any improvement:

With(
 {L1F: Filter('Event Details_1','Event Status'="Active")},
 With(
 {L2F:Filter(L1F,('End Date and Time' > Now() || 'Recurring End Date 1' > Now() || 'Recurring End Date 2' > Now() || 'Recurring End Date 3' > Now() || 'Recurring End Date 4' > Now() || 'Recurring End Date 5' > Now() || 'Recurring End Date 6' > Now() || 'Recurring End Date 7' > Now() || 'Recurring End Date 8' > Now() || 'Recurring End Date 9' > Now() || 'Recurring End Date 10' > Now()))},
 If(
 IsBlank(HomeSearch.Text),
 Sort(
 L2F,
 'Start Date and Time',
 Descending
 ),
 Sort(
 Search(
 L2F,
 HomeSearch.Text,
 "Title"
 ),
 'Start Date and Time',
 Descending
 )
 )
 )
)

Best regards,