Send Email when SP List Item Column Changes

(1) Share

Report

Posted on by AndrewK93

I have a list of accounts for third-party systems, and I need an email to trigger when a column changes for a list item. Specifically, there is a field called 'AccountRemoved,' and I want an email to be sent when this checkbox is marked as TRUE. Despite following various guides, the flow still triggers when any other checkbox changes, which does not provide clarity.
Could someone guide me in the right direction in case I've overlooked something?

These are the forums i have used in the past to create this and followed them and theirs seems to work but mine doesnt

Power Automate SharePoint Get Column Changes - April Dunnam - SharePoint Siren

Run a flow when a SharePoint column is modified - Microsoft Power Platform Blog

Categories:

Using flows

All responses (3)

Answers (0)

Sort by

Suggested answer

scalca 254 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

That's a Power Automate question

nevertheless, the flow gets triggered by any modification because that's what it says
"When an item or a file is modified"

there is a solution for this called Trigger Conditions

Go to the trigger

click on settings

there you'll find Trigger conditions

click add to add a new expression

there you can add an expression which needs to be true in order to trigger the flow itself

in your case

@equals(triggerOutputs()?['d.AccountRemoved'], true)

you have to check the column and give the exact name as well as check the return type

here official link

https://learn.microsoft.com/en-us/power-automate/triggers-introduction?tabs=classic-designer#customize-a-trigger-by-adding-conditions

Use expressions in conditions in Power Automate - Power Automate | Microsoft Learn
Suggested answer

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

hi

Correct, it will always trigger no matter what, simply your Get Changes check will stop it from going further.

As Scalca said, you need a Trigger Condition, which it still behind the scenes does work, but you dont see a trigger actually happen)
AndrewK93 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for this; it seems to be on the right track. However, I have confirmed the name of the column within SharePoint. I attempted to run the flow after making the modification, but the test flow keeps timing out.

I have also tried to run @equals(triggerOutputs()?['body/AccountRemoved'], true)

Any ideas?