Unanswered

When to do pagination in PowerApps portals webpage

(0) Share

Report

Posted on by IrfanMukhtiar

Hi all,

I am working on a powerApps Portals webpage, for that I had created a page template and page template is consist of webTemplate.

In webTemplate, I had use fetchxml to retrieve data from CRM, all records are being shown in a nice way

all reteieved records are being shown, but I want to pagination in a sense, first show 10 records. when scroll down, at end of page, other 10 record appear and continue.

How can I do this? Do I need to use pagination in fetchXML? or grab the all data do some other techniques to do such pagination.
anybody please respond

Categories:

Power Apps portals

All responses (3)

Answers (0)

Sort by

ragavanrajan 7,044 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @IrfanMukhtiar

You can create a plugin for this and apply the following code

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/org-service/page-large-result-sets-with-fetchxml

Basically, "The paging cookie" is a performance feature that will allow you to retrieve large dataset.

On the other hand, we can try Lazy loading with JavaScript which is a client-side solution. But I haven't tried so far.

Hope it shed some light for you on where to start.

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.
IrfanMukhtiar 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ragavanrajan
I had implemented your recommended solution that was using page cookies.

first I write below lines and get the below error
"morerecords": {{ contactimageurl.results.more_records }},
"paging-cookie": "{{ contactimageurl.results.paging_cookie }}",
"paging-cookie-encoded": "{{ contactimageurl.results.paging_cookie | escape | url_escape }}",
"page": {{ request.params['page'] | default: 0 }},

Error: these all lines appear on webpage as it is, I also used use brackets after "
{% endfetchxml %}

then I write fourlines as below
Now I am not receiving any error but I am not aware of how to get the second page when scroll at end of page?

can you please help me regarding this?

I had google it, there I find csharp code, there he was doing like page++, here we can increment into this
"page="{{ request.params['page'] | default:1"?????
but I want to do increment in page scroll event, can I write page scroll event into web Template?

Thanks
oliver.rodrigues 9,482 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, if you use a List instead of FetchXML, you can use pagination in Liquid: Render the list associated with the current page - Power Apps | Microsoft Docs