How to Export a Large Filtered SharePoint List into a CSV File Using Power Automate

In this video, I review step by step how to export a large, filtered SharePoint List into a CSV file using Power Automate, a total of 42,000 records in all. I'll be using the OData query filter and show how to identify the SharePoint columns name.
Visit the link below to see the step-by-step breakdown:
www.tw-waytek.com/how-to-impo...
Be sure to subscribe to get all the latest technology tips and to visit my website where you can find the documented version of my videos.
--------------------------------------------------------
CONNECT WITH ME:
My Website: www.tw-waytek.com
___________________________________

[@user-ft2ug4tn1s]

Thank you for your video! It helped me successfully export a long SP list.

[@tw-waytek]

Hello @user-ft2aug4tn1s,
I'm so glad you enjoyed the video and that it was able to help you out. Reach out any time if you ever have any questions.

[@nidhishah1353]

It looks like not doable!! i followed same step but got threshold error!!

[@tw-waytek]

Hello @nidhishah1353, thanks for reaching out, how many records and columns are you looking to export? Also, do you have any filters in your query?

[@nidhishah1353]

@@tw-waytek i have records like 6519. When i followed your video i could export only 5000, more than that it said Threshold limit reached. Columns i exported was 2 only, text columns.

[@tw-waytek]

@nidhishah1353, did you turn on Pagination and change the threshold limit to something like 10,000?

[@1987Geraint]

@@tw-waytek It looks like this works for an instant trigger, but the Scheduled trigger has a limit of 5,000 on the pagination threshold :(

[@tw-waytek]

Hello @1987Geraint, thanks for your insight, I'll see if can replicate the issue when running a scheduled trigger and post my findings.