"When a file is modified" - Can I get what was modified/changed?

(0) Share

Report

Posted on by cchung

Hello,

We have a spreadsheet on SharePoint that we are using to keep track of all our computers & IT equipment.

Every time an update or change is made on there, such as we get new laptops, our accountant needs to be notified so she can update it in her accounting software.

I am creating a flow that can automatically email the accountant when a change occurs.

I got a basic test flow working with OneDrive and "when a file is modified" -> "send an email v2", trying to change it to use SharePoint instead.

Question: Is there a way in the email I can specify what was changed or updated on the excel? So the account knows what she is looking for.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@cchung

I am not aware of any way to find out what cell or cells changed using Power Automate.

However, Excel does have a track changes feature - all you need to do is to turn it on.

Here is a link with more info on track changes.

Was this reply helpful? Yes No
LeanderS 19 on at

Like (0)

Report

@cchung Have you tried to use the SharePoint action Get changes for an item or a file (properties only)? You can use this as the second action to at least track the colum that has been changed within the file and then sent those changes within an E-Mail. I am not aware if it is also possible to find out the specific cell with it, but it should narrow down the changes.

Was this reply helpful? Yes No