Reporting on multiple changes to a list

(1) Share

Report

Posted on by EH-25061946-0

We have a SharePoint list that we want to receive alerts on when certain columns are updated.

The issue I've ran into is that when it works, it only reports on the first change it sees. Rather that report on multiple. Which most of the time its 2-3+ updates.

Is there a way to add this function? Any help would be greatly appreciated!

This is what we want.

Column1
Column2
Column3
Column4

We only want to be emailed when Column 2-3 change we want a single email letting us know the new values.

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Are you saying that you want an alert when column 1, 2, 3, AND 4 are updated, or when column 1, 2, 3 OR 4 are updated? Either way, it can be done. You would do this:

Use the trigger When a file or item is modified

When it triggers, use the Get changes for an item or file (properties only)

Set since to Trigger Window Start

Set until to Trigger Window End

Add a condition to check if the fields have changed

Use AND or OR depending on your answer to my first question

Put your e-mail action on the yes side of the condition

There is a way to actually get what was changed, but it has been so long since I had to do that, I've forgotten how. Hopefully someone else knows how and can tell you that part. If I recall, it required calls to the graph API and was not something easy to accomplish.

Your flow will look like this:

Was this reply helpful? Yes No
EH-25061946-0 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@David_MA I only want to be updated when Column 2 and/or 3 has changed.

It needs to work for multiple changes. I can get it to work if only 1 changes is being made. But when multiple changes are made it only emails the first change it sees.

Was this reply helpful? Yes No
Suggested answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I cannot guarantee this will work, but this shows how to get the old and new value, and also shows the steps outlined above to first check if the fields changed to begin with: Power Automate - How to get previous value of updated SharePoint List Item - DEV Community

Was this reply helpful? Yes No
David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You will need to show your workflow. If you did what I outlined, it will work with multiple changes. The screen shot of the condition requires that two fields need to change to do the actions on the yes side. Seeing your flow will also help clarify what you mean by it e-mails on the first change it sees.

If you need this: I only want to be updated when Column 2 and/or 3 has changed.

Just change AND in the condition to OR. This will include when Column 2 AND Column 3 have changed because they will be included in the OR.

Was this reply helpful? Yes No
EH-25061946-0 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@David_MA We had a Or condition with the fields we wanted to be alerted on and it still didn't work.

Was this reply helpful? Yes No
David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You'll need to show your flow or maybe someone else can provide more information without seeing what you're doing.

Was this reply helpful? Yes No
EH-25061946-0 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@David_MA I don't really have anything built right now.

I'm just curious if what I asked is possible.

Was this reply helpful? Yes No
David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, what you want to do is definitely possible.

Was this reply helpful? Yes No