Forum Discussion
Sharepoint List email notification when a field is modified
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.
You can't however modify the email notificaton text
Do you know of anyway to do this and customise the email notification?
- RobElliottJun 07, 2022Silver 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- Pn1995Jun 07, 2022Brass Contributor
Thanks
I've tried the PowerAutomate flow - however in the Condition I don't get all the fields listed under "Has Changed" - Maybe I doing something wrong - not sure- ganeshsanapJun 07, 2022MVP
Pn1995 For customized email template, use power automate flow approach as suggested by RobElliott.
Also, I just checked that I am able to get the changes to person or group (people) columns as well:
If your column name is "Owner", check for "Has Column Changed: Owner" under dynamic content.
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.