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
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.
Not a complete solution but the following should get you started.
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?
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?
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?
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!