Problem:
- At most 500 records can be returned at a time, whether filtered or not.
- OneDrive, Dropbox, and Google Sheets can only read from the first 500 records.
- CDS can read from all records, but can only return 500 records on a Filter.
- It is not possible to Collect all records of an unfiltered datasource.
Suggestion 1:
Could you create a function to only pre-load and reload entity data to a temporary collection? It would do the same as this, but it could pull in everything without the 500 record limit:
Refresh(datasource);
ClearCollect(temp_datasource,datasource)
It would only import all records or none; so if you wanted to filter, you would have to do it after the temporary collection has been created. Furthermore, to reduce drag on the network, you could restrict this specific function to queue up or a quota like 100 runs per second.
Rationale: If we can collect the entire contents of a datasource to a temporary collection, we can operate on the temporary collection instead. This would allow for all aggregate functions and other non-delegable functions to work on the temporary collection. Then from time to time, we can reload the datasource to have the most updated data in the temporary collection.
Suggestion 2:
Could you create a function that would pull in 500 records at a time until all are pulled in? It would work like my solution, but it would be automated with fewer lines of code.
I am suggesting these functions as temporary solutions to not having all functions delegable.
Please consider this idea.
JoeF-MSFT
on:
Add Russian language support in Power Automate -AI...
aka-akadijk
on:
Enabling nonce in Portal
on:
Power Automate Desktop flow execution failure when...
chass
on:
Need to edit the Microsoft docs content about addi...
OOlashyn
on:
Portal - Access to Local Login Settings