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:
<fetch top="10">
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
https://docs.microsoft.com/en-us/powerapps/maker/portals/liquid/render-entity-list-current-page
------------
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.
