Send an email alert to a static and dynamic user from the sharepoint list column

%3CLINGO-SUB%20id%3D%22lingo-sub-2162063%22%20slang%3D%22en-US%22%3ESend%20an%20email%20alert%20to%20a%20static%20and%20dynamic%20user%20from%20the%20sharepoint%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162063%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys%2C%20I%20am%20pretty%20new%20to%20sharepoint.%20I%20created%20a%20sharepointlist%20which%20stores%20data%20from%20the%20powerapps.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThe%20list%20contains%20multiple%20columns%20including%20the%20name%20and%20email%20of%20the%20one%20who%20modified%20the%20row%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I'm%20trying%20to%20achieve%20is%20for%20sharepoint%20to%20send%20an%20email%20to%20the%20person%20who%20modified%20(dynamic)%20the%20row%20and%20to%20myself%20since%20I%20am%20an%20admin.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20manage%20alerts%20and%20its%20working%20fine%20just%20the%20sending%20of%20email%20since%20its%20directly%20sending%20to%20myself.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2162063%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2162335%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20an%20email%20alert%20to%20a%20static%20and%20dynamic%20user%20from%20the%20sharepoint%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162335%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F977101%22%20target%3D%22_blank%22%3E%40WakeUpMrWest%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWelcome%20to%20both%20SharePoint%20and%20the%20TechCommunity.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20would%20help%20you%20out%20here%20is%20a%20Power%20Automate%20flow.%26nbsp%3B%20The%20alerts%20functionality%20that%20I%20suspect%20you're%20using%20is%20native%20to%20the%20product%20and%20is%20rather%20old.%26nbsp%3B%20It%20only%20presents%20a%20very%20basic%20set%20of%20options%20with%20very%20limited%20flex%20for%20customisation%20%2F%20dynamism.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPower%20Automate%20will%20allow%20you%20to%20connect%20to%20the%20specific%20site%20%2F%20list%20and%20specify%20a%20sequence%20of%20events%20that%20can%20be%20built%20into%20the%20alert.%26nbsp%3B%20I've%20mocked%20up%20a%20quick%20demo%20screenshot%20of%20this.%26nbsp%3B%20I've%20spun%20this%20up%20from%20a%20template%20Microsoft%20have%20provided%20called%20%22When%20an%20item%20in%20a%20SharePoint%20list%20is%20modified%20send%20an%20email%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PowerAutomate_ModifiedByEmail.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F257353i2514320AA4930565%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22PowerAutomate_ModifiedByEmail.PNG%22%20alt%3D%22PowerAutomate_ModifiedByEmail.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2162337%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20an%20email%20alert%20to%20a%20static%20and%20dynamic%20user%20from%20the%20sharepoint%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162337%22%20slang%3D%22en-US%22%3EYup%2C%20already%20tried%20that%20one%20but%20I%20want%20to%20see%20what%20was%20the%20last%20value%20before%20it%20got%20modified%2Fchanged%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2162354%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20an%20email%20alert%20to%20a%20static%20and%20dynamic%20user%20from%20the%20sharepoint%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162354%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F977101%22%20target%3D%22_blank%22%3E%40WakeUpMrWest%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20using%20version%20history%20on%20this%20list%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2162513%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20an%20email%20alert%20to%20a%20static%20and%20dynamic%20user%20from%20the%20sharepoint%20list%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162513%22%20slang%3D%22en-US%22%3EI%20don%E2%80%99t%20think%20so%2C%20I%E2%80%99ve%20never%20heard%20that%20yet.%20Can%20i%20integrate%20that%20to%20mg%20sharepointlist%3F%3C%2FLINGO-BODY%3E
New Contributor

Hello guys, I am pretty new to sharepoint. I created a sharepointlist which stores data from the powerapps.

The list contains multiple columns including the name and email of the one who modified the row 

 

What I'm trying to achieve is for sharepoint to send an email to the person who modified (dynamic) the row and to myself since I am an admin.

 

I manage alerts working and results are as expected but only issue is it's only sending to myself since I am the one who created the alert, but I also want it to be sent to the one who modified the row.

6 Replies

@WakeUpMrWest 

 

Welcome to both SharePoint and the TechCommunity.

 

What would help you out here is a Power Automate flow.  The alerts functionality that I suspect you're using is native to the product and is rather old.  It only presents a very basic set of options with very limited flex for customisation / dynamism.

 

Power Automate will allow you to connect to the specific site / list and specify a sequence of events that can be built into the alert.  I've mocked up a quick demo screenshot of this.  I've spun this up from a template Microsoft have provided called "When an item in a SharePoint list is modified send an email"

 

PowerAutomate_ModifiedByEmail.PNG

Yup, already tried that one but I want to see what was the last value before it got modified/changed

@WakeUpMrWest 

 

Are you using version history on this list?

I don’t think so, I’ve never heard that yet. Can i integrate that to mg sharepointlist?

@WakeUpMrWest 

 

If you want to send an email when list item is updated then you have to use the Power Automate flow.

 

Also, if you want to send an email notification if specific column is changed then you can use the recently released List rules  feature in SharePoint online.

Read more about list rules at: Rules in SharePoint Online/Microsoft Lists 


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.

@Steven Andrews 

 

I have enabled version history on my list. searched online if its possible to send an email to the one who modified but still no luck