Unanswered

When excel worksheet A is updated, another backup excel worksheet B also will be update

(0) Share

Report

Posted on by mfikri1609

Hi, Good Morning/Afternoon/Evening,

I'm new in the building flow in power automate web, I want to request help if is possible to trigger a flow whenever a new data is insert in Excel worksheet A, the Excel worksheet B also will be update with the new data as it act as backup. Excel B will continue adding row as Excel A keep getting new data. My Concern is someone might changes/delete data in Excel A, so I want to keep Excel B as backup of original.

Categories:

Building flows

I have the same question (1)

All responses (2)

Answers (1)

Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @mfikri1609 ,
unfortunately there's no Excel trigger for your purpose. You can only trigger Excel changes by using the "For a selected row".
Please refer to the following article:
https://manueltgomes.com/reference/power-automate-trigger-reference/for-a-selected-row-trigger/

Instead of using Excel to store data, would you consider to create a SharePoint list? In that case you can for sure automatically trigger item changes.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
mfikri1609 38 on at

Like (0)

Report

Because the data is from Microsoft Form, so it will save the feedbacks into excel.

Was this reply helpful? Yes No