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

[sebastianslz]

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.

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

[ekarim2020]

Hi @sebastianslz ,

You can use an expression to set boolean values of true or false:

 

For more information, please see Power Automate: When true is not true - Manuel T. Gomes (manueltgomes.com)

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[sebastianslz]

@ekarim2020 I think I was not very clear in explaining my question, I go back and present the scenario,

I would like the condition to be executed only when the "Estado" previously had as a value "false" and then it was changed to "true"

Is there something else you require that I can explain and thus better understand my question?

[ekarim2020]

Hi @sebastianslz ,

Thanks for the clarification.

You will need a way to determine if the value of the field has changed.

If you are using a SharePoint List we can use the Get Column Changes action to determine if a column has changed, and with a boolean field we can then easily determine its previous value. See Power Automate SharePoint Get Column Changes - April Dunnam - SharePoint Siren

Does your data source (looks like SQL?) enable you to determine which field has changed?

If not, you will need a way to store and track the value of Estado in order to determine if the value has changed, such as stroing Estado in a SharePoint list and comparing the current value with what is stored in the list to see if it has changed.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[sebastianslz]

@ekarim2020 

It is correct, my data source is SQL, but I really do not know if there is any way to determine if the field has changed, could you explain in more detail what solution I can implement in this case taking into account as a SQL data source, or if I should add an additional column to my table in SQL ? Something I can do?

[ekarim2020]

Hi @sebastianslz ,

Unfortunately I don't work with SQL, but take a look at if this, if this will help:

t sql - How do I find out whenever a value changes in a certain column? - Database Administrators St...

You may be able to determine at the source SQL databse if the Estado column has changed.

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.