Auto email when item status is changed in SharePoint list

[JimboSey]

Hi, 

I am relatively new to Power Automate, and I would like to implement the following as a simple Flow.

I have a SharePoint list (populated from a PowerApp form), the List I have a column for 'Status' which is a choice column, the default value of this column is ''Consultation', as when the form in the App is submitted that is the the initial status. 

Using Flow what I would like to do is say, when the choice is changed from 'Consultation' to any other the other choice in the column (there's several), then automatically email the person in the 'Created By' column for that particular item. 

I have done a Flow before, that sends an email when an item is changed, but never done one to specifically send the email when the item is changed only when its previous value was a specific choice, in my case 'Consultation'.

Thanks

JS

[SudeepGhatakNZ]

@JimboSey ,

Try the Get changes for an item or a file (properties only) action. This blog will help!

 Flow with SharePoint When a Column is Updated (iwmentor.com)

[David_MA]

You can use a trigger condition such as:

@not(equals(triggerOutputs()?['body/Status/Value'],'Consultation'))

You will most likely want to add a field to your list that can be populated when the flow runs, otherwise any time the item is edited and the Status is not Consultation, it will send the e-mail again.

For example, you could add a yes/no field named Email Sent with the default value of No. Then you could add a second Trigger condition with this expression:

@equals(triggerOutputs()?['body/EmailSent'],false)

This is an example from one of my flows:

However, this really would not meet your requirement of only running when the prior value of the Status is Consultation, but maybe this is what you are really looking for.

To do what you want you will most likely need to add a second status column which has the same initial default value. Then you'll need another flow that runs every time the item is modified to populate the second status column with the original status column value. Your trigger conditions would then be where Status is not equal to Consultation and Second Status is equal to Consultation. I haven't done anything like this, but I think it would work.