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.
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.
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?
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.
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!