Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

add a new row to the google sheet created an error



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?



Helper I
Helper I

I again,


I have trying to erase all empty line but when new row, she is added from line 36573....

Has anyone already had this problem or have an idea to solve it?







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:!topic%2Fdocs%2FlgsFQccOe...


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?

Helpful resources

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (30,261)