Update a sharepoint column based on a step in the flow

%3CLINGO-SUB%20id%3D%22lingo-sub-859672%22%20slang%3D%22en-US%22%3EUpdate%20a%20sharepoint%20column%20based%20on%20a%20step%20in%20the%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-859672%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Microsoft%20form%20where%20FLOW1%20creates%20a%20sharepoint%20item.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20the%20SharePoint%20list%2C%20FLOW2%20sends%20an%20email%20to%20the%20person%20who%20submitted%20the%20item.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20update%20a%20CHOICE%20field%20in%20the%20Sharepoint%20list%20based%20on%20whether%20the%20email%20succeeded%20or%20failed.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20flow%20failed%20to%20send%20email%2C%20Value%201%3C%2FP%3E%3CP%3EIF%20flow%20sent%20email%2C%20value%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20a%20way%20to%20do%20this%3F%20Would%20it%20be%20part%20of%20FLOW2%2C%20or%20a%20subsequent%20FLOW%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-859672%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-860524%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20a%20sharepoint%20column%20based%20on%20a%20step%20in%20the%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860524%22%20slang%3D%22en-US%22%3EThere%20are%20error%20conditions%20you%20can%20have%20return%20if%20an%20action%20fails%20but%20when%20it%20comes%20to%20email%20it%20will%20only%20tell%20you%20if%20the%20message%20was%20queued%20for%20delivery.%20You%20cannot%20tell%20if%20the%20message%20went%20to%20the%20recipient.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-863607%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20a%20sharepoint%20column%20based%20on%20a%20step%20in%20the%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863607%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410524%22%20target%3D%22_blank%22%3E%40Barbara_Selden%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20do%20all%20the%20steps%20in%20one%20single%20flow.%20Here%20you%20have%20an%20example%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FGeneral-Flow-Discussion%2FWhen-a-Form-is-submitted-send-and-email-and-then-based-on%2Ftd-p%2F76099%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FGeneral-Flow-Discussion%2FWhen-a-Form-is-submitted-send-and-email-and-then-based-on%2Ftd-p%2F76099%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F274398%22%20target%3D%22_blank%22%3E%40ChrisWebb%3C%2FA%3E%26nbsp%3Bsaid%2C%20you%20can%20only%20check%20whether%20the%20email%20action%20executed%20correctly%20or%20not.%20Depending%20on%20the%20case%2C%20you%20can%20update%20the%20choice%20field%20in%20the%20SharePoint%20List%20Item.%20You%20can%20find%20more%20information%20on%20error%20handling%20in%20flow%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Ferror-handling%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Ferror-handling%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20it%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a Microsoft form where FLOW1 creates a sharepoint item.

 

From the SharePoint list, FLOW2 sends an email to the person who submitted the item.

 

I want to update a CHOICE field in the Sharepoint list based on whether the email succeeded or failed. 

If flow failed to send email, Value 1

IF flow sent email, value 2

 

is there a way to do this? Would it be part of FLOW2, or a subsequent FLOW?

2 Replies
Highlighted
There are error conditions you can have return if an action fails but when it comes to email it will only tell you if the message was queued for delivery. You cannot tell if the message went to the recipient.
Highlighted

Hi @Barbara_Selden 

 

You could do all the steps in one single flow. Here you have an example: https://powerusers.microsoft.com/t5/General-Flow-Discussion/When-a-Form-is-submitted-send-and-email-...

 

As @ChrisWebb said, you can only check whether the email action executed correctly or not. Depending on the case, you can update the choice field in the SharePoint List Item. You can find more information on error handling in flow here: https://flow.microsoft.com/en-us/blog/error-handling/

 

Hope it helps!