Power automate: Fetch 50,000+ Records with this Easy Solution

In this tutorial, we’ll show you how to fetch 50,000+ records in Power Automate with an easy solution. Learn how to optimize your Power Automate experience and work smarter, not harder. Don’t forget to like, share and subscribe for more content on Microsoft Power Automate!
#powerautomate #tutorial #microsoft #sharepoint

[@manjunathpatil6785]

@Corporate programming Thank you for the solution it's really easy to understand. I have one additional requirement here after getting more than 5000 items from one list using get items I want to create all items in another list is there any way ... please guide

[@corporateprogramming]

Thank you! Yes by the help of apply to each and use create item action in loop.

[@manjunathpatil6785]

@@corporateprogramming Thank you for the response i tried this way but it is giving timeout error for apply to each and taking lot of time and am having more than 8000 items which i need to create from one list to another list. Is there any other work around please suggest appreciate your help and time one this.

[@rohitmetya5002]

​@@manjunathpatil6785hey how have you done this task??can you please give some insights

[@sateesha3688]

how to fetch same 5000+ records from excel online connector. I am trying to follow same from list rows from table, but it is not allowing filter query of gt (greater than). It supports only few filter functions like eq, startswith, endswith

[@corporateprogramming]

Please connect- [e-mail].
If possible share sample data

[@blrumph92]

Did you set the pagination to 5000 on the first get items or any of the the other actions?

[@BMAN2579]

same question for me as well

[@corporateprogramming]

No without pagination.

[@klebermedeiros8742]

Cool. I need to join every outputs from Get Items 2. Who Can I do this?

[@corporateprogramming]

After joining the out what you would like to achieve, please provide more details.

[@niravbamrotiya6981]

how to export a list consisting 10000 items into an excel ?? please help

[@corporateprogramming]

Same workflow can do this job. To write rows in excel - follow steps: Send email to distinct users from excel | Remove duplicate emails using power automate | Flow
ua-cam.com/video/dSkreEXD8Ks/v-deo.html

[@paragkeshardas8139]

IF i dnot have any ID coulmn than what to do?

[@corporateprogramming]

share your use case with sample data: [e-mail]

[@rugvedphuge7517]

How to add more than 20000 records in the sharepoint list please guide

[@corporateprogramming]

By the help of same solution