Send mail to Multiple People while updating list item for a specific Dropdown value

%3CLINGO-SUB%20id%3D%22lingo-sub-1443184%22%20slang%3D%22en-US%22%3ESend%20mail%20to%20Multiple%20People%20while%20updating%20list%20item%20for%20a%20specific%20Dropdown%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1443184%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20Online%20List%20with%20Columns%20below%3C%2FP%3E%3CP%3E1)%20%3CSTRONG%3ETask%20Status%3C%2FSTRONG%3E(Lookup%20Column)%20and%202)%20%3CSTRONG%3EAssigned%20To%3C%2FSTRONG%3E(People%20column%20-%20Multiple%20Selection)%3C%2FP%3E%3CP%3E-%20Task%20status%20is%20Dropdown%20having%20values%3CEM%3E%20a)%20Open%2C%20b)WIP%2C%20c)%20Closed%3C%2FEM%3E%3C%2FP%3E%3CP%3E-%20Assigned%20To%20can%20have%20%3CEM%3E3%20people%20or%20more%3C%2FEM%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20a%20existing%20list%20item%20is%20modified%20with%20Task%20Status%20as%20%3CSTRONG%3EClosed%3C%2FSTRONG%3E%2C%20separate%20Mail(s)%20with%20Attachment%20should%20be%20sent%20to%20all%20people%20in%20that%20list%20item%20%3CSTRONG%3EAssigned%20To%3C%2FSTRONG%3E%20column.%20Kindly%20help%20with%20a%20best%20approach%20asap.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1443184%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1443343%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20mail%20to%20Multiple%20People%20while%20updating%20list%20item%20for%20a%20specific%20Dropdown%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1443343%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572972%22%20target%3D%22_blank%22%3E%40Arun_J_Yadav%3C%2FA%3EUsing%20MS%20Flow%20and%20Out%20of%20Box%20Form%20you%20can%20do%20it%20easily.%20You%20might%20already%20know%20most%20of%20the%20steps%20adding%20it%20for%20complete%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStart%20with%20you%20list%20but%20also%20add%20one%20extra%20column%20to%20prevent%20re-sending%20of%20the%20emails%20and%20set%20the%20status%20accordingly%20once%20you%20send%20email%20after%20status%20becomes%20closed.%20I%20have%20created%20a%20column%20named%20EmailSent%20and%20by%20default%20value%20is%20%22no%22%20and%20set%20to%20%22yes%22%20one%20you%20send%20the%20email.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20go%20to%20the%20flow%20add%20the%20action%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1591374444056.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F196751iD58FFFD2FCA9636E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1591374444056.png%22%20alt%3D%22Vikram_Samal_0-1591374444056.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20Apply%20for%20each%20for%20the%20Assigned%20To%20column%20so%20that%20it%20will%20send%20individual%20emails%20and%20use%20send%20notification%20v3%20to%20send%20emails%20with%20attachments.%20Finally%20update%20the%20status%20Email%20sent%20to%20yes%20outside%20the%20for%20each.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3CBR%20%2F%3EVik%3CBR%20%2F%3EIf%20this%20post%20helps%2C%20then%20please%20consider%20%3CSTRONG%3Egiving%20a%20like%20and%20Accept%20it%20as%20the%20solution%3C%2FSTRONG%3E%20to%20help%20the%20other%20members%20find%20it%20more%20quickly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448499%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20mail%20to%20Multiple%20People%20while%20updating%20list%20item%20for%20a%20specific%20Dropdown%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448499%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394813%22%20target%3D%22_blank%22%3E%40Vikram_Samal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWelcome%20your%20valuable%20inputs!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20suggested%2C%20i%20have%20made%20the%20same%20configurations%20with%20Power%20Automate.%20As%20you%20can%20see%20in%20the%20Flow's%20Runtime%20screenshot%20below%20am%20getting%20FALSE%20in%20the%20Condition%20due%20to%20which%20Email%20sending%20is%20skipped.%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%22RunTime%20Flow.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197288iF960D85E8B51E464%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22RunTime%20Flow.JPG%22%20alt%3D%22RunTime%20Flow.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20Flow's%20settings%20you%20could%20see%20in%20next%20screenshot%20below.%20Kindly%20advise%20where%20do%20I%20make%20mistake%20here%20to%20fix%20it%3F%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%22Flow%20Settings.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197289i636B41A8FCFDA54F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Flow%20Settings.JPG%22%20alt%3D%22Flow%20Settings.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You%2C%3C%2FP%3E%3CP%3EArun%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448924%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20mail%20to%20Multiple%20People%20while%20updating%20list%20item%20for%20a%20specific%20Dropdown%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448924%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572972%22%20target%3D%22_blank%22%3E%40Arun_J_Yadav%3C%2FA%3EI%20will%20suggest%20put%20only%20one%20condition%20and%20make%20sure%20that%20works%20and%20then%20add%20the%20second%20condition.%20Finally%20it's%20always%20a%20good%20idea%20to%20expand%20what%20the%20value%20coming%20for%20the%20test%20item%20so%20that%20you%20can%20understand%20why%20the%20logical%20expression%20are%20failing.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1591636011867.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197316iCF5FEE6C017116FE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1591636011867.png%22%20alt%3D%22Vikram_Samal_0-1591636011867.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFinally%20make%20sure%20you%20used%20the%20Staus%20Value%20column%20for%20comparison%20rather%20then%20the%20actual%20column%20name%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_1-1591636103318.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197317i87E044B05B2F793C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_1-1591636103318.png%22%20alt%3D%22Vikram_Samal_1-1591636103318.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3CBR%20%2F%3EVik%3CBR%20%2F%3EIf%20this%20post%20helps%2C%20then%3CSTRONG%3E%20please%20consider%20Accept%20it%20as%20the%20solution%3C%2FSTRONG%3E%20to%20help%20the%20other%20members%20find%20it%20more%20quickly.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Dear Team,

 

I have a SharePoint Online List with Columns below

1) Task Status(Lookup Column) and 2) Assigned To(People column - Multiple Selection)

- Task status is Dropdown having values a) Open, b)WIP, c) Closed

- Assigned To can have 3 people or more 

 

When a existing list item is modified with Task Status as Closed, separate Mail(s) with Attachment should be sent to all people in that list item Assigned To column. Kindly help with a best approach asap.

 

Thank You!

 

 

3 Replies

@Arun_J_YadavUsing MS Flow and Out of Box Form you can do it easily. You might already know most of the steps adding it for complete solution.

 

Start with you list but also add one extra column to prevent re-sending of the emails and set the status accordingly once you send email after status becomes closed. I have created a column named EmailSent and by default value is "no" and set to "yes" one you send the email.

 

Now go to the flow add the action like this:

Vikram_Samal_0-1591374444056.png

 

Note: Apply for each for the Assigned To column so that it will send individual emails and use send notification v3 to send emails with attachments. Finally update the status Email sent to yes outside the for each.

 

Thanks,
Vik
If this post helps, then please consider giving a like and Accept it as the solution to help the other members find it more quickly.

 

Hi @Vikram_Samal 

 

Welcome your valuable inputs!!

 

As you suggested, i have made the same configurations with Power Automate. As you can see in the Flow's Runtime screenshot below am getting FALSE in the Condition due to which Email sending is skipped.

 

RunTime Flow.JPG

 

 

My Flow's settings you could see in next screenshot below. Kindly advise where do I make mistake here to fix it?

 

Flow Settings.JPG

 

 

Thank You,

Arun

@Arun_J_YadavI will suggest put only one condition and make sure that works and then add the second condition. Finally it's always a good idea to expand what the value coming for the test item so that you can understand why the logical expression are failing.

Vikram_Samal_0-1591636011867.png

Finally make sure you used the Staus Value column for comparison rather then the actual column name

Vikram_Samal_1-1591636103318.png

 

Thanks,
Vik
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.