Unanswered

If Then Expression?

(0) Share

Report

Posted on by 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!!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

wskinnermctc 6,519 Moderator on at

Like (0)

Report

Re: If Then Expression?

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

Was this reply helpful? Yes No
martii20 27 on at

Like (0)

Report

Re: If Then Expression?

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.

Was this reply helpful? Yes No
jessicamclaugh 24 on at

Like (0)

Report

Re: If Then Expression?

I completely forgot about the Conditions option, thank you!

Was this reply helpful? Yes No
jessicamclaugh 24 on at

Like (0)

Report

Re: If Then Expression?

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!

Was this reply helpful? Yes No