I have a flow which copies the name of the files added to onedrive in a google sheet spreadsheet.
But for some time the new rows are put at the bottom of the sheet from row 36572. While the rows between 200 and 36572 are empty without any data.
Do you have a solution or an idea to solve this problem?
There isn't an obvious reason for this, it could even be a Google Sheets issue over a Power Automate issue.
To highlight one example for you:
This isn't your precise issue but it does describe a similar issue that is Google Sheets specific. It's worth testing if you have this problem when you take Power Automate out of the picture altogether.
The Google Sheets connectors also have threshold limits:
Are you processing thousands of items basically at one time? If so, I recommend putting in some kind of Delay step to give this time to process. This advice could really apply to a number of Write scenarios, if you try to process too much at once you run the risk of affecting the operation.
One more comment, what is your licensing status? If you're on a trial level plan, you have access to fewer resources than if you were on a Premium plan. You may find the experience is different based on your license type.
For more on that:
Let us know how this goes!
I process a maximum of 200 files per day and I have a personal account to use power automate.
The strange thing is that everything is working fine, it's just that everything is staggered by over 30,000 lines...
do you know how the flow detects the last line written in the google sheet?