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

add a new row to the google sheet created an error

Hello,

 

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?

 

regards

3 REPLIES 3
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?

 

flow1.JPG

flow2.JPG

Microsoft
Microsoft

willy30870,

 

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:
https://support.google.com/docs/forum/AAAABuH1jm0lgsFQccOeqE/?hl=en&gpf=%23!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:
https://docs.microsoft.com/en-us/connectors/googlesheet/

 

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:

https://docs.microsoft.com/en-us/microsoft-365/community/powerplatformlicensingforcitizendeveloper

 

Let us know how this goes!

 

Patrick

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

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (4,639)