Home

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
Barbara_Selden
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
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.

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!

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies