Send email notification when a list column is updated

Like (0) Share

Report

Posted on 12 Dec 2021 19:34:18 by svignesh

I am trying to use Power Automate to send an email notification to people selected in the Assigned to column in a SharePoint list. The list already has around 500+ items and I want send notification whenever the assigned to is modified.

Can this be achieved in Power Automate?

In the Power Automate that I have, I am checking if the Assigned to column is not empty and I am sending email to "Assigned To". But this will keep sending email to Assigned to person, whenever the item is modified and the assigned to remains the same.

I am thinking to add one more single line of text column and update that to email address from "Assigned to" column so that I can check if "Single line of Text != Assigned to" and then send email. This would also require me to populate the single line of text column to have same value as Assigned to.

Is there any other way to achieve this?

All responses (5)

Answers (1)

Verified answer

Mira Ghaly 11,409 Super User 2025 Season 1 on 12 Dec 2021 at 21:13:10

Like (2)

Report

Re: Send email notification when a list column is updated

@svignesh

Please follow this video here:

https://www.youtube.com/watch?v=xvmi21KomK0

And this article to be able to achieve your flow to be triggered on column change:

https://powerautomate.microsoft.com/en-us/blog/run-a-flow-when-a-sharepoint-column-is-modified/