SOLVED

Triggering a workflow based on any changes to a field/column

%3CLINGO-SUB%20id%3D%22lingo-sub-1766047%22%20slang%3D%22en-US%22%3ETriggering%20a%20workflow%20based%20on%20any%20changes%20to%20a%20field%2Fcolumn%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766047%22%20slang%3D%22en-US%22%3E%3CP%3EAre%20you%20able%20to%20specify%20a%20trigger%20to%20look%20at%20if%20a%20specific%20field%2Fcolumn%20changes%20value%20(to%20something%20different)%3F%26nbsp%3B%20We%20currently%20have%20a%20trigger%20when%20a%20specific%20column%20equals%20a%20certain%20value%2C%20but%20are%20unable%20to%20target%20any%20changes%20to%20a%20field%2Fcolumn%20to%20trigger%20the%20workflow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1766047%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-1767294%22%20slang%3D%22en-US%22%3ERe%3A%20Triggering%20a%20workflow%20based%20on%20any%20changes%20to%20a%20field%2Fcolumn%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767294%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826895%22%20target%3D%22_blank%22%3E%40notbobsmith%3C%2FA%3E%26nbsp%3Bhave%20a%20look%20at%20the%20blog%20post%20by%20Laura%20Rogers%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwonderlaura.com%2F2020%2F08%2F25%2Fflow-when-a-sharepoint-column-is-updated%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwonderlaura.com%2F2020%2F08%2F25%2Fflow-when-a-sharepoint-column-is-updated%2F%3C%2FA%3E%26nbsp%3Bbut%20don't%20just%20copy%20her%20expression%20as%20it%20puts%20in%20an%20incorrect%20couple%20of%20apostrophes%2C%20the%20expression%20should%20be%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3Esub(int(triggerOutputs()%3F%5B%3C%2FSPAN%3E%3CSPAN%3E'body%2F%7BVersionNumber%7D'%3C%2FSPAN%3E%3CSPAN%3E%5D)%2C1)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EYou%20must%20make%20sure%20that%20versioning%20is%20switched%20on%20for%20your%20list.%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User.%3CBR%20%2F%3EIf%20I've%20answered%20your%20question%20or%20solved%20your%20problem%2C%20please%20mark%20this%20question%20as%20answered.%20This%20helps%20others%20who%20have%20the%20same%20question%20find%20a%20solution%20quickly%20via%20the%20forum%20search.%20If%20you%20liked%20my%20response%2C%20please%20consider%20giving%20it%20a%20thumbs%20up.%20Thanks.%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1768615%22%20slang%3D%22en-US%22%3ERe%3A%20Triggering%20a%20workflow%20based%20on%20any%20changes%20to%20a%20field%2Fcolumn%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1768615%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BThank%20you%20for%20sharing!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Are you able to specify a trigger to look at if a specific field/column changes value (to something different)?  We currently have a trigger when a specific column equals a certain value, but are unable to target any changes to a field/column to trigger the workflow.

 

Thanks!

3 Replies
best response confirmed by notbobsmith (New Contributor)
Solution

@notbobsmith have a look at the blog post by Laura Rogers at https://wonderlaura.com/2020/08/25/flow-when-a-sharepoint-column-is-updated/ but don't just copy her expression as it puts in an incorrect couple of apostrophes, the expression should be 

sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
 
You must make sure that versioning is switched on for your list.
 
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

@RobElliott- Brilliant!  I was just able to test it out and confirm.  Thanks for the great answer and quick response!