I Need help Building a flow that will add items from SharePoint List to an Excel Spreadsheet on a weekly basis. i am still new to Flow and as i understand there is a limit on how many records i can add per run. My Sharepoint list has over 10,000 records and i need all items to be added to Excel, so every week i want 10K records added on to spreadsheet even if they where not modified that week i want it to be a seperate record. is there a workaround to the limit?
You could use the CSV Table action then convert that CSV to a new Excel with something like this: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-To-New-Excel-Table/td-p/1826096
Or with a bit more complicated set up you could use the version b of this batch Excel template to create Excel rows: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706
SharePoint REST API batching - exploring batch payloads (andrewconnell.com)
Make batch requests with the REST APIs | Microsoft Learn
This talks about file operations, wonder if something similar is possible for Excel contents. Have you considered using Office scripts?