If Then Expression?

[jessicamclaugh]

Does anyone know if IF/THEN expressions are possible in flows? I have a form with a dropdown allowing people to pick a facility. If they pick a certain facility, I'd like my manager column in my list to populate with the associated manager. 

Example, If Location equals "TEST" then "Jane Doe"

I work in tableau, so these expressions are foreign to me. Thanks for any help!!

[wskinnermctc]

Here is a full list of expressions for power automate: 

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference 

There is an if() expression to use in power automate.

Your example would be something like:

if(equals({formresponse},'TEST'),'Jane Doe','None')

This is using the equals() expression inside of the if() expression.

However, for the form response in power automate, you might want to use something like a Condition which checks the output and then directs the flow. But it is up to you.

Control Condition

[martii20]

I wanted something similar in my flow, but I ended up using a VLOOKUP function to accomplish this. If you are collecting responses in an Excel file by adding a new row each time, this could work for you. 

I created a separate reference table with the list of facilities and managers:

Then I created a table that collects the responses and added a column that uses the lookup function to reference the first table. "Form ID" and "Facility" are collected in the Form and added to this table using "Add a row into a table" with Excel. The "VLOOKUP" column should automatically update with each new row. 

[jessicamclaugh]

I completely forgot about the Conditions option, thank you!

[jessicamclaugh]

Hmmm, I'm collecting the data in a list. I'm not sure if I can use vlookup as an option there, but I like the idea. I will check it out, thanks!