cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Copy the whole sheet data from Excel (Business) to Google Sheet

I have an Excel Online with daily data with "date" field (DD/MM/YYYY)

I want to copy every data from time to time to Google Sheet.

 

Currently I created a Google Sheet, and put "Date" as Row ID in advance in every row.

Then use "List rows present in a table" to get all rows in Excel Online.

After that "Apply to each" => "Update Google Sheet row" and set the "Row ID" target as  the "date" field.

 

Any better way to keep copying the data to Google Sheet?

As I understand the "List rows present in a table" has 256 rows limitation and I cannot use after 256 rows.

 

Thanks!

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Copy the whole sheet data from Excel (Business) to Google Sheet

HI @Anonymous ,

 

Row Id is generated automatically once you create a connection to an Excel table or Google sheet, you will notice your table will have a “_PowerAppsId_” column, we then could use this ID to find the specific row.

 

From your description, it seems that you are trying to use the Date field as Row Id, which is not correct.

 

If you would like to update google sheet row with value from the Excel table, please check the following configuration for a reference.

 

Please take a try with it on your side.

1.PNG2.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: Copy the whole sheet data from Excel (Business) to Google Sheet

Thanks @v-yamao-msft ,

 

May I know this method is one-time use or can use repeatly?

I want to get the Data from Excel and update the Google Sheet Constantly.

 

Is there any way to simplify it, no need to add Row ID in Google Sheet in prior?

 

Thanks!

Henry

Highlighted
Community Support
Community Support

Re: Copy the whole sheet data from Excel (Business) to Google Sheet

Hi @Anonymous ,

 

Thanks for updating.

 

It could be repeated if you change the trigger to a Recurrence which will trigger the flow daily/weekly based on your needs.

 

For testing, I used a Button trigger which triggers the flow when the button is clicked.

 

Row Id is automatically added to your Google sheet, which could be used to find the specific row.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,338)