Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Execute flow condition...
Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by sebastianslz 119
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.
 
sebastianslz_0-1653588069320.png

 

I would like to know if anyone has an idea of how to perform this specific condition.
Categories:
Business Process Flows
  • Ellis Karim Profile Picture
    Ellis Karim 11,135 Super User 2025 Season 1 on at
    Re: Execute flow condition only if its status was false and then change to true

    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 Stack Exchange

     

    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.

  • sebastianslz Profile Picture
    sebastianslz 119 on at
    Re: Execute flow condition only if its status was false and then change to true

    @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?
  • Ellis Karim Profile Picture
    Ellis Karim 11,135 Super User 2025 Season 1 on at
    Re: Execute flow condition only if its status was false and then change to true

    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 Profile Picture
    sebastianslz 119 on at
    Re: Execute flow condition only if its status was false and then change to true
    @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?
  • Ellis Karim Profile Picture
    Ellis Karim 11,135 Super User 2025 Season 1 on at
    Re: Execute flow condition only if its status was false and then change to true

    Hi @sebastianslz ,

     

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

    Snag_4db1cd1.png

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans