Announcements
I have created a pcf dataset component for canvas app. I have integrated account entity with my sample dataset but it only returns me 25 records.
But I need all records together. Is it possible and how?
Thanks.
Hi @Anonymous ,
You could use the dataset.paging: https://docs.microsoft.com/en-us/powerapps/developer/component-framework/reference/paging?WT.mc_id=BA-MVP-5004107
There you can set a higher page size
dataset.paging.setPageSize(5000);
and navigate to the next pages:
dataset.paging.loadNextPage()
After that you need to call the dataset.refresh()
Hope this helps!
Kind regards,
Diana
@DianaBirkelbach Thanks for your reply. After integrating your suggested code it goes hanged out the app. Could you please suggest any configuration settings instead of code.
I've took the Tutorial Canvas App Dataset component (https://docs.microsoft.com/en-us/powerapps/developer/component-framework/tutorial-create-canvas-dataset-component?WT.mc_id=BA-MVP-5004107) , and added in the init one line of code changing the page size (in my case to 300, but you should be able to use 5000). After that I could see all my records.
public init( context: ComponentFramework.Context<IInputs>, notifyOutputChanged: () => void, state: ComponentFramework.Dictionary, container: HTMLDivElement, 😞 void { //... this.context.parameters.records.paging.setPageSize(300); }
Changing this in the updateView will trigger another call to updataView. Maybe that broke your app.
Hi @DianaBirkelbach ,
Thanks for your sharing. I have a question here about the 5000 limits, if our dataverse table has more than 5000 records, e.g. 10000 records, how can we get all 10000 records in our PCF dataset without pagination? Is there an workaround for this case?
Best Regards,
Kris
@Dai_Xin I'm afraid you will have to use pagination.
Hi @Dai_Xin , I agree with @a33ik , you need pagination if you need 10.000 records.
On the other side, I wonder if you really need to "download" all 10.000 records? Because you probably would have performance issues anyway,
Maybe it's enough to make an aggregation fetch, and retrieve the counter/sum aggregation instead.Or try to use filters....It depends on what you have to do, of course...
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 914
11manish 617
Valantis 598
