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 Pages / Power Apps Portal - En...
Power Pages
Unanswered

Power Apps Portal - Entity List Loading all data at first time which causing performance issue

(0) ShareShare
ReportReport
Posted on by 121

Hello Experts,

 

We have one screen where we have included one Entity list with Metadata Filter. but the whenever the user clicks on the Filter Data button then it is not filtering the data until the whole data loads in the Entity list. There is some custom JS code added to click the filter data button after all data loads in the Entity list but that is taking 1 min now because of 1 million records in CDS Table.
 
 
Please provide any workaround to do not load entity list for the first. it should be loaded when metadata filter is applied for that entity list.
 
Any possible solutions or workarounds on this is really helpful,
 
Regards,
Pranesh
Categories:
  • oliver.rodrigues Profile Picture
    9,482 Most Valuable Professional on at

    I haven't tried that myself, but here a quick thought (you will need a bit of liquid here):

     

    Option 01

    • whenever we apply a metadata filter, it adds the following to the URL: <portal url>/page/?mf=.....
    • if you have a custom web template, you can validate the url parameters before rendering the Entity List, so if you don't have the "mf=..." don't render the entity list, the Apply button should always perform a HTTP Post request (I think), so this will reload the page, and render the list the next time
    • but that might not be all.. if on the first load we are not rendering the entity list, this will probably cause the page to not even load the filters, so perhaps you need to render your filters manually via Liquid: https://docs.microsoft.com/en-us/powerapps/maker/portals/liquid/render-entity-list-current-page

    Option 02

    • What if you enter that page always with a pre-filter (via URL ?mf=XXX) for something that would never bring result? this would perform a quick search displaying no results
    • you would additional JS to clear the filter text box and perhaps show a better message to the end user instead of "no records found"

     

    those are just ideas, I haven't tried that myself 

  • praneshJ Profile Picture
    121 on at

    Hello @OliverRodrigues ,

    Thanks for your reply,

     

    I think the option 2 could be the easy way comparatively, but I am not sure that how to enter page always with a pre-filter (via URL ?mf=XXX), or how to catch the response,
    any reference to this would be really helpful.

     

    for option 1 (Render the entity list associated with the current page) also I am not sure where to write that xml code to render the entity list, I think it is in a web template, but don't know the certain way to achieve this, If you could provide any brief reference to this is really appreciable.

     

    Regards,

    Pranesh  

     

  • oliver.rodrigues Profile Picture
    9,482 Most Valuable Professional on at

    Hi @praneshJ 

    I was playing around here, and seems that the example I gave you earlier about the query string parameter, only happens for my Option 1 - when we render the filters manually, if we leave the filters OOB it seems it doesn't add anything to the URL

    I am playing here with the option 1, might be a bit of work, but nice for a blog post, I will keep you up to date with what I find out

  • oliver.rodrigues Profile Picture
    9,482 Most Valuable Professional on at

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Pages

#1
Mohsin Ali Profile Picture

Mohsin Ali 18

#2
11manish Profile Picture

11manish 16 Super User 2026 Season 2

#3
anirudhev Profile Picture

anirudhev 4

Last 30 days Overall leaderboard