You’re offline. This is a read only version of the page.
603
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
)
)
Hi @Iantaylor2050 ,
Please try below formula and see if there is any improvement:
Share
Report
All responses (
Answers (
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,
