Help with sending email after sharepoint columns are updated

[Tbruns]

Here is what I am needing to create and I would appreciate anyone's assistance. How can I create a Flow to do the below?

Step 1: A new item is created

            and "Yes" is populated in Column 1 

            Send an email

Step 2: then Column 1 is updated to "Meets"

             and Column 2 equals 123 or 456 - send email

             or if Column 2 does not equal 123 or 456 but DOES equal 678 - send email

Step 3: when Column 3 is updated to "approved or  Denied" - send email  

[Pstork1]

1. Create the Flow to run when an item is created or modified
2. Use condition statements to move to one of three paths through the flow depending on the conditions of the various columns.

[Tbruns]

Can you show me an example as I have not used conditions in Flow yet. Thank you!

[ScottShearer]

@Tbruns 

I agree with the guidance provided by @Pstork1 but would like to add that you probably want to add a column that says when email has been sent and/or the state of your workflow.  The purpose of this additional column is to guard against multiple emails being sent when an item is updated multiple times.

[Pstork1]

Not a complete solution but the following should get you started.

[Tbruns]

Each time I try to add a condition it puts it in a "Apply to each" which you do not have on your screen shot. What am I doing wrong?

[Tbruns]

Can anyone assist with my question regarding "Apply to All"?

[Pstork1]

The Apply to all will be automatically inserted if the column you are access is allowed to have multiple selections. It has to apply the logic to each selection. The columns I used in my screenshot were single line of text.  What kind of column are you trying to key off of?

[Tbruns]

They are choice columns

[Pstork1]

You are probably using just the column name.  Since its a choice column it has multiple entries and those entries are complex objects. You need to make sure that you are submitting just one value.  Are you using choicecolumnname.selected.value?  or choicecolumnname.selectedtext?

[Tbruns]

I have no idea how to find that out. Sorry I am fairly new to Flow.

[Pstork1]

That means the thing you are testing in the condition isn't just a text field.  Its something that has more than one part, like a collection, an array or a complex object. Are you trying to test a choice field or some other complex item?

[Tbruns]

Am I doing this correctly?