web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapps gallery with...
Power Apps
Answered

Powerapps gallery with 15 columns and 10 records loading too slow - Datasource has 90 columns

(0) ShareShare
ReportReport
Posted on by 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
)
)

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,041

#2
11manish Profile Picture

11manish 676

#3
Valantis Profile Picture

Valantis 655

Last 30 days Overall leaderboard