Announcements
I have a table1 in excel when a new row added in that the same row need to be added in table2 automatically using office script.
I would suggest doing this via a powerautomate flow rather.
can u explain me the outline of process in power automate ?
Hi, the starting point depends a lot on where the data is coming from in the first table. So you need to work out the best trigger but lets say for example that you want to copy the table1 data across once an hour you could start with a schedule which gets the rows of table1 and table2, use a filter on an index value to identify new items and then create a new row for each of the new items. If the table is being updated manually you could look at using the trigger For a selected row (I am not familiar with it).
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 389
Vish WR 331
David_MA 298 Super User 2026 Season 1
