SOLVED

Send an email when Name is added to a certain column in Sharepoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-3070336%22%20slang%3D%22en-US%22%3ESend%20an%20email%20when%20Name%20is%20added%20to%20a%20certain%20column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3070336%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20it%20possible%20to%20create%20a%20flow%2C%20that%20will%20send%20an%20email%20to%20the%20person%20when%20the%20%22Assigned%20to%22%20column%20(that%20is%20created%20as%20%22person%22)%20gets%20populated%20with%20a%20Name%3F%3C%2FP%3E%3CP%3EExample%3A%20list%20item%201%2C%20when%20created%20Assigned%20to%20is%20blank%2C%20after%20revision%20is%20assigned%20to%20one%20of%20my%20colleagues%20to%20John's%20name%20is%20added%20to%20the%20Assigned%20to.%20I%20tried%20using%26nbsp%3B%40%20but%20it%20does%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%3F%20thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3070336%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3070811%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20an%20email%20when%20Name%20is%20added%20to%20a%20certain%20column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3070811%22%20slang%3D%22en-US%22%3EIn%20Power%20Automate%20create%20a%20new%20%22Automated%20Cloud%20Flow%22%3CBR%20%2F%3EChoose%20the%20trigger%20%22When%20an%20Item%20or%20File%20is%20Modified%22%20%3CBR%20%2F%3EAdd%20a%20Get%20Item%20or%20Get%20File%20Properties%20step%20(gets%20all%20of%20the%20metadata%20values%20on%20the%20item)%3CBR%20%2F%3EAdd%20a%20condition%20to%20see%20if%20the%20'Assigned%20To'%20column%20has%20a%20value%3CBR%20%2F%3E-%20YES%20-%20send%20email%3CBR%20%2F%3E-%20NO%20-%20end%20the%20Flow%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3091587%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20an%20email%20when%20Name%20is%20added%20to%20a%20certain%20column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3091587%22%20slang%3D%22en-US%22%3EHi%2C%20Thank%20you%20for%20your%20feedback%2C%20but%20that%20does%20not%20work%2C%20because%20it%20means%20that%20any%20change%20in%20that%20item%20where%20a%20person%20has%20been%20assigned%20is%20going%20to%20trigger%20that%20email%2C%20even%20when%20closing%20the%20job.%3CBR%20%2F%3EI%20tried%20using%20the%20Dynamic%20content%20%22has%20Column%20changed%3A%20AssignedTo%22%20but%20the%20outcome%20is%20the%20same%20as%20just%20%22AssignedTo%22%20not%20equal%20to%20Null.%3CBR%20%2F%3EI%20tried%20using%20ANDs%20and%20ORs%20but%20cannot%20make%20it%20work%20either.%3CBR%20%2F%3EAll%20i%20want%20is%20an%20email%20when%20the%20%22AssignedTo%22%20column%20changes%20and%20not%20when%20any%20other%20column%20changes%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Contributor

Hi! 

is it possible to create a flow, that will send an email to the person when the "Assigned to" column (that is created as "person") gets populated with a Name?

Example: list item 1, when created Assigned to is blank, after revision is assigned to one of my colleagues to John's name is added to the Assigned to. I tried using @ but it does not work.

 

Any thoughts? thank you

3 Replies
In Power Automate create a new "Automated Cloud Flow"
Choose the trigger "When an Item or File is Modified"
Add a Get Item or Get File Properties step (gets all of the metadata values on the item)
Add a condition to see if the 'Assigned To' column has a value
- YES - send email
- NO - end the Flow
Hi, Thank you for your feedback, but that does not work, because it means that any change in that item where a person has been assigned is going to trigger that email, even when closing the job.
I tried using the Dynamic content "has Column changed: AssignedTo" but the outcome is the same as just "AssignedTo" not equal to Null.
I tried using ANDs and ORs but cannot make it work either.
All i want is an email when the "AssignedTo" column changes and not when any other column changes
best response confirmed by MVCuser (Contributor)
Solution
This video might help. I think it is similar to what you are wanting to do
https://www.youtube.com/watch?v=gVRcFeogfKE
I hope this helps :)