Answered

Trigger Workflow only on one Sharepoint list column entry

(0) Share

Report

Posted on by mc_chick

Hello, i need to configure a workflow which is triggered only by the change of one column in a sharepoint list. It should give a notification.

It works for now with "trigger condition" @equals(triggerOutputs()?['body/COLUMN/value'],'VALUE')- but now there is another problem - if we change the column, the workflow starts - and if we change some later another column in the same list entry, the workflow also starts (because the trigger condition is also true) ...

How can we avoid this? Workaround for now is an action which changes the column value after the notification to a "notified" value ... is there another option which i dont know?

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

fchopo 8,003 Moderator on at

Like (0)

Report

Hi @mc_chick

No, currently that's the only possible way to handle workflow triggers for specific column values.

Best,

Ferran

Was this reply helpful? Yes No
mc_chick 82 on at

Like (1)

Report

I found another possible solution - without a change in the column after the first change triggered my workflow.

After the Trigger (with triggercondition) i use the action "Get changes on an item or a file (property only)" - and check the changes between the last versions of the list entry. After this comes a condition with a check "column XYZ has changed" ... if true > Pushmail ... if false > do nothing ... done 🙂

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Correct, but in this case, it counts as another execution of the workflow (and the advantage of trigger conditions is that workflow is not triggered -> not counted).

Hope it helps to clarify.

Ferran

Was this reply helpful? Yes No
mc_chick 82 on at

Like (0)

Report

Sure 🙂 but sometimes its needed to "stay" with a changed column value (maybe "to be defined") in the list entry - instead of changing it to another status like "to be defined (already notified)" ... 😉

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi, read through the posts for the Trigger Workflow only on one SharePoint list column entry. This is exactly what I need to learn how to do. Can someone provide me the exact instructions on what to do to make this work? I'm not a developer but I do understand how to set up workflows in other programs. I'm not savvy enough in 365 Power Automate yet. Hope to get there one day.

Any help would be appreciated. Thank you.

Was this reply helpful? Yes No
craig_01 153 on at

Like (0)

Report

Hi All, i am also having a similar issue. I have a SP List that has a list of Jobs, with a Priority Date column, when a job has a Priority date assigned i get an email alert.. However if another column within the same list is updated, i am getting this workflow also triggering.. How do i prevent this, i am learning my way with Power Automate.

Thanks

Was this reply helpful? Yes No
mc_chick 82 on at

Like (0)

Report

You can try my solution: after the Trigger (with triggercondition) use the action "Get changes on an item or a file (property only)" - and check the changes between the last versions of the list entry. After this put a condition with a check "column XYZ has changed" ... if true > Pushmail ... if false > do nothing ...

Was this reply helpful? Yes No
craig_01 153 on at

Like (0)

Report

@mc_chick sorry, can you clarify, im not understanding.. I already have a "get changes on an item or a file (Property Only)".... and a condition.. Do i need to add another, or is this a trigger within "settings"

Thanks

Was this reply helpful? Yes No
mc_chick 82 on at

Like (1)

Report

i see - you are on the right way - your condition is wrong - it can be only true or false - and so it is always not 0 😉

use
and then on YES put the needed action - and on NO > nothing (or another action...)

Was this reply helpful? Yes No
craig_01 153 on at

Like (1)

Report

Thanks, i reckon that has sorted it 🙂

Was this reply helpful? Yes No