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?
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
You can add compose action and below expression
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.
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',''))
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.