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

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

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

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,020)