Multiple IF expression to create Item name

[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"

or

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?

I

[Soundharya]

[cnapan]

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?

[Soundharya]

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',''))

[cnapan]

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.

[Soundharya]

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

[cnapan]

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',''))