How to assign multiple values in a single variable with an OR statement.

(0) Share

Report

Posted on by mxdataengineer

I want to create a variable which stores multiple hard codded values.

If this value exists in an OR statement, it will proceed into the next task.

The syntax for hard codded values is %'value'%. So do I write the variable like this?

%'value'% OR %'value'% OR %'value'%

Categories:

Power Automate Desktop

I have the same question (0)

All responses (10)

Answers (0)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

From where you re getting the Value of the variable?

if you want to check the variable contains the value or noy You need to Use if activity

then Check with If activity. as shown below.

Please ignore the error sine yourvariable is the variable which you need to check.

For more clarification please explain your scenario.

Hope this helps,

Usha.

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@mxdataengineer,

Please find the below attached suggestion from MS for variable manipulation:

Link - https://learn.microsoft.com/en-us/power-automate/desktop-flows/variable-manipulation#logical-operators

The sample code tailored to your specific use case entails the following:
It enters the loop if 'newvar' holds the value '2' or 'value'.

Code:
SET NewVar TO 2
IF (NewVar = 'value' OR NewVar = 2) = $'''True''' THEN
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Deenu\\Accounts_Details_one.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
END

-----------------------------------------------------------------------------------------------------------------------------

Thanks,
Deenu

Was this reply helpful? Yes No
mxdataengineer 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey both, what am I suppose to add if the 'YourVariable' variable does not exists?

Q - From where you re getting the Value of the variable?
A - It is a hard coded value I assign myself.

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @mxdataengineer

Use set variable activity and assign your value to the variable.

Hope this helps

Usha

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@mxdataengineer,
Please adhere to the method outlined by @UshaJyothi20 as mentioned earlier.

Thanks,
Deenu

Was this reply helpful? Yes No
mxdataengineer 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey there @UshaJyothi20 @Deenuji

I had created the new Variable and assigned the value similar to 'YourVariable' earlier (since new Variables created cannot be blank). The flows runs but it doesn't complete the task as intended.

In the If activity, I set First Operand as %NewVar% (assigning the new variable itself).

Was this reply helpful? Yes No
cwischnewski 162 on at

Like
a
(0)

Report
Copy link

Link copied!
It isn't clear what you are wanting to do. Someone above provided a great link to use. The percent notation gives you the ability to do a lot. A variable only ever has one value, but the conditional If can use percent notation to build a complex criteria inside of percent signs. If you had two variable that might have various values throughout the flow and you want to see if either contains some string, for instance, build that out.

SET MyFirstVariable TO $'''%''%''' SET MySecondVariable TO $'''This value has something''' IF (IsEmpty(MyFirstVariable) OR Contains(MySecondVariable, MyFirstVariable, True)) = True THEN SET MySecondVariable TO $'''%MySecondVariable% And then some more.''' END

This block will set the two variables, then check if the first one is empty it will do that block, but if it isn't, it will check if the second variable contains the first. One thing to note is that %True% is the boolean value.

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@mxdataengineer It seems you haven't add any value in the If condition. Please find the below reference flow for your use case.
Flow:

Code:
Outlook.Launch Instance=> OutlookInstance
SET NewVar TO $'''Deenu@gmail.com'''
IF NewVar = $'''Deenu@gmail.com''' THEN
Outlook.RetrieveEmailMessages.RetrieveEmails Instance: OutlookInstance Account: $'''Deenu@gmail.com''' MailFolder: $'''Inbox''' EmailsToRetrieve: Outlook.RetrieveMessagesMode.Unread MarkAsRead: True ReadBodyAsHtml: False Messages=> RetrievedEmails
END

Hope this helps. Else please share your exact use case, I will try to help you more accurate.

Thanks,
Deenu

Was this reply helpful? Yes No
mxdataengineer 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey all,

I made some progress today as I got the flow to work (successful) earlier using the If and Input Variables,

For some reason the additional variable I added show otherwise, the entire flow run but it did not complete the task as intended. Could you please suggest how I could get this flow to run?

Main - Added 2 new variables with the same variable name NewVar, assigned 2 Input variable to NewVar
Example - The If statement is to determine if NewVar contains the assigned value NewInput and NewInput2
Subject Contains - NewVar only. If NewVar is True, the flow will continue to run.

Was this reply helpful? Yes No
cwischnewski 162 on at

Like
a
(0)

Report
Copy link

Link copied!

You don't seem to understand how variables work. A variable only ever has a single value. When you assign NewVar in step 2 to NewInput, that is what NewVar is. Then when you assign NewVar in step 3 to NewInput2, that is now the value, it is no longer equal to NewInput unless that just happens to be the same.

You have 5 total variables in this flow. NewInput and NewInput2 get assigned initially by the default or calling process. But they are variables and you can check their value in a condition and assign them new values throughout the flow.

Was this reply helpful? Yes No