Unanswered

Multiple IF expression to create Item name

(0) Share

Report

Posted on by cnapan

Hi, I need a little help with basic, I hope, expression in Power automate.

I have 3 columns in my Sharepoint list, named Column1, Column2 and Column3. What I would like is to auto populate a value for 1st column, based on the values in 2nd and 3rd column.

For example. If Column2 has value "Cat" and Column3 value "Dog" I would like to have in Columns1 value "CatDog"

If Column2 column has vale "Cat" and Column3 value "Fish" I would like to have in Column1 "CatFish"

I know it can be done with condition in Power automate steps, but I guess it is also possible with IF expression, I just need a sample of that multiple syntax. Can you help?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

soundharya 249 on at

Like (0)

Report

Was this reply helpful? Yes No
cnapan 24 on at

Like (0)

Report

Well, thank you @Soundharya , but what if I have more combination in Column2 or Column3, except cat, dog and frish, there is also a pig, horse, elephant. Can I somehow a write
if(Equals(triggerBody()['Column1'],'cat' and ['Column2']'), 'dog', 'catdog' '')
or something similar but more complex to achieve my goal?

Was this reply helpful? Yes No
soundharya 249 on at

Like (0)

Report

You can add compose action and below expression
if(and(contains(variables('Name'), 'cat'),contains(variables('Name1'), 'fish')),'catfish',if(and(contains(variables('Name'), 'cat'),contains(variables('Name1'), 'dog')),'catdog',''))

Was this reply helpful? Yes No
cnapan 24 on at

Like (0)

Report

Thank you, @Soundharya that would work, but can you show me all steps of the flow how this supposed to be constructed? I do not know, where to place the initialized variables. Thank you.

Was this reply helpful? Yes No
soundharya 249 on at

Like (0)

Report

To show you example i have used variables, instead of variables you can use your columns or fields directly here

Was this reply helpful? Yes No
cnapan 24 on at

Like (0)

Report

I did replace variables with column name, then getting syntax error 😞 Why?
if(and(contains(['Animal1'], 'cat'),contains(['Animal2'], 'dog')),'catdog',if(and(contains(['Animal3'], 'fish'),contains(['Animal1'], 'cat')),'fishcat',''))

Was this reply helpful? Yes No