I would like to know how to include the logical AND/OR operators in conditionals, previously on WinAutomation this could be achieved like this:
The AND "&&" operator can be used inside an "If" condition using the following format
First Operand: %TextVar_1 == "ABC" && TextVar_2 == "DEF"%
Operator: =
Second Operand: True
The OR "||" operator can be used in a similar way
First Operand: %TextVar_1 == "ABC" || TextVar_2 == "DEF"%
Operator: =
Second Operand: True
I have tried to express it in this way in Power Automate Desktop and it is not working.
In my case I am reading a single cell value from excel which is stored into the variable %ExcelData%, I would like to use an If conditional to review if the variable's value is either "Payer" or "Doc" I need it to do certain actions, but if it is blank I need it to go into a different set of actions.
I have already tried to express it in different ways but I haven't been able to achieve this logic, this is what I have tried so far:
First Operand: %ExcelData = "Payer" || ExcelData = "Doc"%
Operator: =
Second Operand: True
With the above conditional I get an Invalid Value message, you might have noticed I removed the double equal signs, I have tried with the double equal signs and it also says invalid value in this way.
First Operand: %ExcelData = 'payer'% || %ExcelData = 'doc'%
Operator: =
Second Operand: True
The above conditional is accepted by PAD but when I run it it doesn't seem to be working as intended as it is not realizing that the cell value is actually Payer.
