Forum Discussion

Pn1995's avatar
Pn1995
Brass Contributor
Jun 07, 2022

Sharepoint List email notification when a field is modified

Hi

We have a Sharepoint list that has a "owner" field that is a PeoplePicker.

 

When a new enter is added to the list this "owner" field is empty and only added at a latter date

 

When the Owner field is populate or changed we want a email tot go out to that user

 

We don't want a email going out if any other field is changed - anyone know if this possible?

 

Thanks

5 Replies

  • Pn1995 For your requirements, you can use Rules in SharePoint Online/Microsoft Lists. Create a new rule by selecting "A column changes" option & configure it like below:

     

    Where "Name" is a person or group column. For more information about rules feature in lists, check this article: Rules in SharePoint Online/Microsoft Lists 

     

    Alternately, you can use power automate flow using "When item is created or modified" trigger & check if Owner field changed or not using "Get changes for list item" action & send an email to owner email address.


    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    • Pn1995's avatar
      Pn1995
      Brass Contributor
      Thanks - i didn't know about rules

      You can't however modify the email notificaton text

      Do you know of anyway to do this and customise the email notification?
      • RobElliott's avatar
        RobElliott
        Silver Contributor

        Pn1995 to do this you would need to have a flow in Power Automate as suggested by ganeshsanap . For example we usually add our company logo and other information into a flow and rarely, if ever, use alerts.

         

        Rob
        Los Gallardos
        Microsoft Power Automate Community Super User

Resources