Power Platform Community Forum Thread Details

Hi all,

My flow transfers data from Excel to SharePoint and enters it into a google sheet. The data in the Excel is updated daily. The flow currently has 3 problems.

A) Extremely slow

B) Inaccurate because it is not variable.

I am looking for better functions or ideas to improve the flow.

This is product data. New rows are added from time to time, some are removed, daily the inventory of products changes and the product texts are also updated regularly.

Process:
1) Create Excel list (time defined automation).
2) Start PA Flow
3) PA: Retrieve tables and cells.
4) PA: Then delete based on ID with a loop starting from row 2. (To ensure that all data is new).
5) PA: Retrieve Excel
6) Transfer all values individually to Google Sheets

To A)
The whole process takes about 1.5 hours. Deleting takes a long time because all rows are addressed individually.
Is it possible to define a range in Power Automate to delete the entire range (except the table headings)? I have not found anything equivalent to last column/row in Excel.

To B)
Since I haven't found a function like last column, I have to enter exactly how many rows I want to retrieve. But since the excel is variable, I also want the function to adjust to the number of rows present. There are currently 431 rows. As far as I know, you have to define the number of rows from 255 /256 with the pagination.

Do you have any other ideas on how to make the Excel-Google Sheets synchro?