Home

Approval flow stuck in loop based on modified SharePoint item

%3CLINGO-SUB%20id%3D%22lingo-sub-325194%22%20slang%3D%22en-US%22%3EApproval%20flow%20stuck%20in%20loop%20based%20on%20modified%20SharePoint%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325194%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20issue%20is%20that%20I%20have%20a%20flow%20that%20%3CSTRONG%3Estarts%3C%2FSTRONG%3Eif%20an%20item%20is%20created%20or%20modified%20(modified%20is%20necessary%20in%20this%20case).%26nbsp%3B%20When%20an%20item%20hits%20the%20list%20from%20a%20form%2C%20an%20admin%20must%20go%20into%20the%20list%20and%20update%20the%20approver.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EStep%202%3C%2FSTRONG%3E%3A%20I%20added%20in%20a%20condition%20saying%20if%20Approved%20is%20equal%20to%20Yes%3A%20If%20yes%20%5Bnothing%5D%3B%20If%20no%20%5Bstart%20approval%5D.%26nbsp%3B%20The%20approval%20has%20fields%20from%20the%20list%20such%20as%3A%20approver%20email%2C%20employee%20display%20name%2C%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EStep%203%3C%2FSTRONG%3E%3A%20After%20the%20approval%2C%20it%20goes%20into%20a%20condition%20saying%20if%20Response%20is%20equal%20to%20Approve%3A%20If%20yes%20%5BUpdate%20item%20(on%20list)%20with%20%22Yes%22%20in%20Approved%20column%5D%3B%20If%20no%20%5Bnothing%5D.%26nbsp%3B%20Also%20post%20said%20message%20to%20Teams.%3C%2FP%3E%3CP%3EAll%20of%20this%20is%20successful%20except%20when%20someone%20approves%20the%20item%2C%20the%20list%20is%20essentially%20%22modified%22%20and%20then%20loops%20back%20to%20a%20new%20email%20for%20an%20approval%20task.%26nbsp%3B%20My%20question%20is%2C%20if%20I%20have%20the%20condition%20immediately%20before%20the%20approval%20saying%20If%20Approved%20%3D%20Yes%2C%20it%20should%20no%20longer%20run%20because%20If%20yes%2C%20do%20nothing.%26nbsp%3B%20I've%20included%20screenshots%20of%20my%20flow%20for%20easy%20understanding.%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%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F70861i34DAFC5E60D94CCF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Microsoft%20Flow%201.png%22%20title%3D%22Microsoft%20Flow%201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F70859iEA7107F6674ECC85%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Microsoft%20Flow%202.png%22%20title%3D%22Microsoft%20Flow%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-325194%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
e_bardun
New Contributor

My issue is that I have a flow that starts if an item is created or modified (modified is necessary in this case).  When an item hits the list from a form, an admin must go into the list and update the approver. 

 

Step 2: I added in a condition saying if Approved is equal to Yes: If yes [nothing]; If no [start approval].  The approval has fields from the list such as: approver email, employee display name, etc. 

 

Step 3: After the approval, it goes into a condition saying if Response is equal to Approve: If yes [Update item (on list) with "Yes" in Approved column]; If no [nothing].  Also post said message to Teams.

All of this is successful except when someone approves the item, the list is essentially "modified" and then loops back to a new email for an approval task.  My question is, if I have the condition immediately before the approval saying If Approved = Yes, it should no longer run because If yes, do nothing.  I've included screenshots of my flow for easy understanding.

 

Microsoft Flow 1.png

Microsoft Flow 2.png

Related Conversations