Skip to main content

Notifications

Community site session details
Power Automate - General Discussion
Answered

Send email notification when a list column is updated

Like (0) ShareShare
ReportReport
Posted on 12 Dec 2021 19:34:18 by 60

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? 

  • vr72 Profile Picture
    7 on 26 Feb 2024 at 05:21:19
    Re: Send email notification when a list column is updated

    @Mira_Ghaly This is great! I've created a workflow using this logic and am very happy. I do wonder if there is another flow to cover 'Send email notification when a list column is created'. At the moment field X (person field) is my Has Column Changed trigger field, but sometimes I will add to my SharePoint List and know at the time who I will add and the 'updated' flow doesn't recognise it going from NULL to a value. It only recognises it going from a value to a value.

    Any help? Thanks 🙂

     

    vr72_0-1708924863951.png

     

  • Difrale Profile Picture
    38 on 19 Apr 2023 at 09:11:05
    Re: Send email notification when a list column is updated

    Take a look at your condition. It should be equal to 'true'. 

    'True', 'Yes' or 'yes' are not working. I first used a capital letter 'T' and that didn't work. 

    You can also check the output value in your column in the run history. This value has to be 'true' to send the email.

    Difrale_0-1681895369971.png

    Good luck

  • MattB5 Profile Picture
    9 on 14 Dec 2022 at 07:47:06
    Re: Send email notification when a list column is updated

    Thank you! You're a star!

  • MTaylor Profile Picture
    2 on 22 Nov 2022 at 13:32:37
    Re: Send email notification when a list column is updated

    I'm receiving the error below when I have the has the column been updated. If only use the column name then it send duplicate emails to everybody marked as completed. 

    MTaylor_0-1669123942585.png

     

  • Verified answer
    Mira Ghaly Profile Picture
    11,409 Super User 2025 Season 1 on 12 Dec 2021 at 21:13:10
    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/

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
David_MA Profile Picture

David_MA 8 Super User 2025 Season 1

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 7 Super User 2025 Season 1

Overall leaderboard
Loading started
Loading started