SOLVED

SharePoint Online - Email Current User after specific Column change

%3CLINGO-SUB%20id%3D%22lingo-sub-1497191%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20-%20Email%20Current%20User%20after%20specific%20Column%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497191%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20reasonably%20new%20to%20SharePoint%20Online.%20I%20haven't%20got%20into%20creating%20Flows%20yet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20send%20an%20email%20to%20the%20current%20user%20when%20the%20current%20user%20changes%20the%20value%20of%20a%20status%20column%20in%20the%20list%20(as%20a%20reminder%20to%20do%20some%20follow-up%20activities).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20find%20a%20few%20examples%20of%20how%20to%20create%20a%20flow%20to%20send%20an%20email%20upon%20a%20column%20change%2C%20but%20the%20email%20address%20is%20always%20hardcoded%2C%20or%20taken%20from%20a%20list%20column%20(e.g.%20%22AssignedTo%22.%20I%20want%20to%20email%20the%20person%20who%20made%20the%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeers%2C%3C%2FP%3E%3CP%3EDom%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1497191%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi there,

 

I'm reasonably new to SharePoint Online. I haven't got into creating Flows yet.

 

I'd like to send an email to the current user when the current user changes the value of a status column in the list (as a reminder to do some follow-up activities). 

 

I can find a few examples of how to create a flow to send an email upon a column change, but the email address is always hardcoded, or taken from a list column (e.g. "AssignedTo". I want to email the person who made the change.

 

Any help appreciated.

 

cheers,

Dom

1 Reply
best response confirmed by dom_donald (New Contributor)
Solution

@dom_donald 

 

You can use Modified by column for getting the user who changed the column value of a list item.