News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Update one excel file ...

Power Automate - Using Flows

Answered

Update one excel file stored in Onedrive based on another Excel file stored in Onedrive.

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi,

I have two Excel files stored in Onedrive. Backlogs and Tracker. The Backlogs file will have a new row added in periodically, and I need only those new rows to be updated in the Tracker file, everytime a new row is added to Backlogs.

I am new to Power Automate, and unable to find a suitable flow. I have attached replica of files stored in my local system.

Regards,

Tejas

Backlog alerts li...

Tracker.xlsx

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report

Re: Update one excel file stored in Onedrive based on another Excel file stored in Onedrive.

Hi @Anonymous ,

There is no such "When a row is added in Excel table" trigger for Excel Online. A workaround is using a Schedule trigger to run the flow every day to get new entries of the latest day in the table.

Power Automate - How To Filter Excel Date Column Values? - YouTube

In addition, I would recommend you use more efficient data sources, such as SharePoint. There are more supported triggers and actions to use for kinds of scenarios.

Best regards,

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans