CODEWITHSUNDEEP
office365power-automateoffice365-apps
user15500092
user15500092

Reputation:

Execute flow condition only if its status was false and then change to true

I have a problem with a flow in which I would like an email to be sent if the following condition is met:

If the "Estado" column of type Boolean previously had a value of false and then changed to true.

I have consulted different documentation on this subject but I do not find clarity in the matter, it is here that I want only this part of the flow or this condition to be executed if the "Estado" is false and then changed to true. This is the example of what I have done so far in my flow.

enter image description here

I would like to know if anyone has an idea of how to perform this specific condition.

Upvotes: 0

Views: 470

Answers (1)

greer92
greer92

Reputation: 1

The best way I've found to do this so far is clearly elaborated here by Manuel Gomes:

https://powerautomate.microsoft.com/en-in/blog/run-a-flow-when-a-sharepoint-column-is-modified/

You need to use the "When a file or item is modified" trigger coupled with the "Get changes for an item or a file [properties only]" in your flow.

The "When modified" trigger will point to the sharepoint list you are monitoring.

In the "Get changes" trigger, add TriggerWindowStartField to the Since field, and TriggerWindowEndToken to the Until field.

After these two triggers are set up, in the Condition trigger, you can then insert HasColumnChanged: [column you want to monitor] and set up your conditions accordingly.

Has Column Changed selection

Note: Versioning needs to be enabled on your sharepoint list (it is by default on Online Sharepoint lists)

Sample flow

Upvotes: 0

Related Questions