SOLVED

send email to a specific users as soon as for a given item created/modified the status is Done.

%3CLINGO-SUB%20id%3D%22lingo-sub-125014%22%20slang%3D%22en-US%22%3Esend%20email%20to%20a%20specific%20users%20as%20soon%20as%20for%20a%20given%20item%20created%2Fmodified%20the%20status%20is%20Done.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-125014%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20list%20with%20title%20and%20choice%20column%20called%20status%20with%20values(inProgress%2C%20Done%2C%20OnHold)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20send%20email%20to%20a%20specific%20users%20as%20soon%20as%20for%20a%20given%20item%20created%2Fmodified%20the%20status%20is%20Done.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20i%20achieve%20that%20with%20a%20flow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-125014%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-128463%22%20slang%3D%22en-US%22%3ERe%3A%20send%20email%20to%20a%20specific%20users%20as%20soon%20as%20for%20a%20given%20item%20created%2Fmodified%20the%20status%20is%20Done.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-128463%22%20slang%3D%22en-US%22%3E%3CP%3Ethanks%20it%20worked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20the%20blank%20template%20is%20the%20best%20option%26nbsp%3B%20and%20choosing%20a%20template%20later%20from%20search%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-125891%22%20slang%3D%22en-US%22%3ERe%3A%20send%20email%20to%20a%20specific%20users%20as%20soon%20as%20for%20a%20given%20item%20created%2Fmodified%20the%20status%20is%20Done.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-125891%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20provide%20more%20details%20on%20exactly%20what%20you%20have%20done%20%3A)%3C%2Fimg%3E%20This%20will%20allow%20us%20to%20better%20understand%20and%20help%2Fadvice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3E1.%20In%20Flow%20portal%2C%20chose%20Create%20from%20blank%3B%3C%2FP%3E%3CP%3E2.%20Chose%20Search%20hundreds%20of%20connectors%20and%20triggers%3B%3C%2FP%3E%3CP%3E3.%20When%20the%20connectors%20and%20triggers%20are%20shown%2C%20chose%20SharePoint%3B%3C%2FP%3E%3CP%3E4.%20When%20the%20SharePoint%20triggers%20are%20shown%2C%20chose%20SharePoint%20-%20When%20an%20item%20is%20created%20or%20modified%3B%3C%2FP%3E%3CP%3E5.%20In%20the%20flow%20step%3A%20When%20an%20item%20is%20created%20or%20modified%20-%20entered%20the%20site%20address%2C%20chose%20or%20entered%20the%20list%20name%3B%3C%2FP%3E%3CP%3E6.%20Chose%20New%20Step%3A%20Add%20a%20condition%3B%3C%2FP%3E%3CP%3E7.%20In%20the%20Condition%2C%20set%20the%20first%20Choose%20a%20value%20field%20to%20...%3F%3F%3F...%3B%3C%2FP%3E%3CP%3E8.%20In%20the%20Condition%2C%20set%20the%20last%20Choose%20a%20value%20field%20to%20...%3F%3F%3F...%3B%3C%2FP%3E%3CP%3E9.%20In%20the%20If%20yes%20branch%20....%3C%2FP%3E%3CP%3Eand%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-125078%22%20slang%3D%22en-US%22%3ERe%3A%20send%20email%20to%20a%20specific%20users%20as%20soon%20as%20for%20a%20given%20item%20created%2Fmodified%20the%20status%20is%20Done.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-125078%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20specified%20the%20url%20or%20the%20site%20and%20list%20name%20first%20when%20i%20was%20using%20the%20blank%20template.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eselected%20for%20any%20item%20change%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethen%20i%20have%20added%20condition%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20in%20value%20equals%20value%20%2C%20typed%20Category%20and%20next%20value%20as%20abc%20-%20in%20the%20yes%20condition%20i%20have%20used%20outlook%20to%20send%20email%20to%20users%20list.%20i%20have%20saved%20and%20run%20it%20and%20it%20says%20it%20run%20without%20errors.%20But%20i%20want%20it%20to%20run%20when%20in%20the%20testlist%20if%20i%20change%20or%20add%20new%20data%20with%20status%20as%20abc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-125033%22%20slang%3D%22en-US%22%3ERe%3A%20send%20email%20to%20a%20specific%20users%20as%20soon%20as%20for%20a%20given%20item%20created%2Fmodified%20the%20status%20is%20Done.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-125033%22%20slang%3D%22en-US%22%3EIn%20Flow%20you%20can%20add%20conditions%20and%20check%20a%20value%20coming%20from%20a%20previos%20action%20so%20you%20can%20decide%20which%20branch%20in%20the%20Flow%20has%20to%20be%20executed%3C%2FLINGO-BODY%3E
Regular Contributor

I have created a list with title and choice column called status with values(inProgress, Done, OnHold)

 

I want to send email to a specific users as soon as for a given item created/modified the status is Done.

 

How do i achieve that with a flow.

4 Replies
In Flow you can add conditions and check a value coming from a previos action so you can decide which branch in the Flow has to be executed

I have specified the url or the site and list name first when i was using the blank template.

 

selected for any item change

 

then i have added condition

 

and in value equals value , typed Category and next value as abc - in the yes condition i have used outlook to send email to users list. i have saved and run it and it says it run without errors. But i want it to run when in the testlist if i change or add new data with status as abc.

best response confirmed by null null (Regular Contributor)
Solution

Please provide more details on exactly what you have done :) This will allow us to better understand and help/advice.

 

Example:

1. In Flow portal, chose Create from blank;

2. Chose Search hundreds of connectors and triggers;

3. When the connectors and triggers are shown, chose SharePoint;

4. When the SharePoint triggers are shown, chose SharePoint - When an item is created or modified;

5. In the flow step: When an item is created or modified - entered the site address, chose or entered the list name;

6. Chose New Step: Add a condition;

7. In the Condition, set the first Choose a value field to ...???...;

8. In the Condition, set the last Choose a value field to ...???...;

9. In the If yes branch ....

and so on.

 

 

 

thanks it worked.

 

I think the blank template is the best option  and choosing a template later from search .