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

(0) Share

Report

Posted on by praneshJ

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.

@OliverRodrigues,

@OOlashyn ,

@justinburch

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:

Power Apps portals

I have the same question (0)

All responses (4)

Answers (0)

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
praneshJ 121 on at

Like (1)

Report

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

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

@praneshJ

Option 2 for the win: https://oliverrodrigues365.com/2021/03/02/power-apps-portals-loading-large-data-in-entity-lists/

Was this reply helpful? Yes No