I've created a flow that adds a row to a table in Excel when a Microsoft Form is submitted. I've got it working quite well, until I changed the destination sheet to a copy of our live Excel sheet that operates as a database (gross, I know). There are 387 rows in the live sheet and when I try to add a new one via the flow, it times out.
I have tested this by creating a copy of the table in a new sheet, erasing all the rows (but changing nothing else; all the calculations are kept), and then running the script, pointing at the new sheet. The data is added without any issues, but when I point it back at the 'live' table, it fails, so I know it's got something to do with the number of rows in the table.
There are quite a few calculations in the sheet, some fairly complex, but I've also tried turning calculations off and it still didn't work. The calculations are why I can't use Sharepoint Lists.
I keep seeing references to 'pagination' when I tried looking it up, but I can't find that setting in Power Automate. It's usually in reference to importing loads of rows, so I don't know if it even applies here.
If anyone knows how to fix this issue, I would be extremely grateful! Thank you!
