You’re offline. This is a read only version of the page.
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!
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
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
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.
Best regards,
Mabel
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (