I'm using fetchxml and liquid code to display a list of records in a table. (Unable to use an entity list as there are multiple N:N relationships present, that make it hard to filter records). Currently, the fetchxml query returns over 5k records which can cause performance issues. Is there a way to fetch only a selected number of records at once and then retrieving more on pagination click event?
Hi, we can use top in FetchXML that allows you to retrieve less than 5k records, this is done at the top of the fetch:
The FetchXML also contains a limitation from the RetrieveMultiple message, which will only retrieve 5,000 records. I don't think we can bring more results than that in Portals (haven't done it myself)
I would recommend trying to filter this list to less than 5k records, a tip for paging here would actually keep using entity list so in Liquid you can leverage from the paging feature, and any complex relationship you can query via Liquid while looping your entity list results - not sure about performance though
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Below blog might be help you to retrieve few records:
If you like this post, give a Thumbs up. Where it solved your query, Mark as a Solution so it can help other people!
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.