Answered

Synchronize Excel to GoogleSheet

(0) Share

Report

Posted on by Community Power Pla...

I've set up a Power Automate flow to transfer data from the "Sheet1" tab in an Excel file stored in SharePoint to the "Sheet2" tab in Google Sheets. The flow is scheduled to run monthly and involves the following steps:

Verify the Google Sheet, retaining the headers, and clearing all existing rows.
Transfer the data from the Excel file to the designated tab in Google Sheets.

However, I'm encountering an issue during the flow execution. The error message indicates that the flow operation is reaching an action limit designed to protect the connector service. I'm currently exploring ways to optimize the flow, considering actions such as batch deletion and rate limiting, to address this limitation and ensure smooth execution.

Can any one help me on this.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

v-jefferni on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The error indicates that there are too many entries in the Google Sheets table to delete.

You can manually create a table in Google Sheets, with all required column as table header but blank content. This file will be used as a template. Every month, when the flow runs, it needs to copy the file, rename it as a new file with the blank table, copy all rows in Excel table and insert to Google sheet.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni,i have table in the Google Sheets with the headers,Despite increasing the limit to 5000 in the settings, I'm encountering a failure in the Power Automate flow while attempting to delete rows from an existing table in Google Sheets. The error message indicates that the operation is hitting an action limit designed to protect the connector service.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

If you have large data in the table of Google sheets, even though the flow runs successfully, it will have bad performance. You can see that the Apply to each has already run for 3 hours.

Google Sheets - Connectors | Microsoft Learn

The best approach is like what I said. You can have a blank table as the template, no need to delete in the flow and will reduce actions in your flow.

Best regards,

Was this reply helpful? Yes No