You’re offline. This is a read only version of the page.
Announcements
Hi
I'm using powerapps for teams flow feature to create a flow to import a SharePoint list into a dataverse table however it only brings in the first 100 rows. So after doing some searching on this site I found that the 'Get Items' action in flow needed to have pagination enabled and then I could enter a number of records to import. The list has approxiamtley 24,000 rows and I entered 25,000
However when I re-ran the flow, the number of rows imported into the table increased only to 200. How do I get the whole 25,000 rows - what am I missing?
It doesn't seem to make any difference whether I use the 'create flow' in powerapps for teams or when I use the online automate, the result is the same
any pointers would be appreciated
Hi @SCooke ,
Please refer to this post on how to get more than 5000 items from a SharePoint list. If you have 24000 items, I suggest you use the SharePoint API option and apply filters as it will be significantly faster. The link above also talks about how to do that.
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up
Connect on LinkedIn
Share
Report
All responses (
Answers (
5,171
