Unanswered

If condition with OR in second operand

(0) Share

Report

Posted on by bensat2

i have 2 types of excel sheet, in 1 the column header is "Package Name" and in the second type the same date but column header is 'service/ Pacakage Name" , i wrote the second operand as "%Currentitem =['Package Name'] OR Currentitem = ['Service/ Package Name']. butthe flow in the desktop is giving error that the property for the current item not found. Is there anydifferent way of achieving this

Categories:

Power Automate Desktop

I have the same question (0)

All responses (15)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@bensat2
Try the below syntax using foreach loop:

Direct check without for each loop:
Full flow screenshot:

Full code:

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Deenu\\Excel1.xlsx''' Visible: True ReadOnly: False Instance=> ExceloneInstance Excel.ReadFromExcel.ReadAllCells Instance: ExceloneInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelOneData Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Deenu\\Excel2.xlsx''' Visible: True ReadOnly: False Instance=> ExceltwoInstance Excel.ReadFromExcel.ReadAllCells Instance: ExceltwoInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelTwoData LOOP FOREACH CurrentItem IN ExcelOneData SET fistcolumnname TO CurrentItem.ColumnNames[0] IF (CurrentItem.ColumnNames[0] = 'Package Name' OR CurrentItem.ColumnNames[0] = 'Service/ Package Name') = $'''TRUE''' THEN # Implement your logic Display.ShowMessageDialog.ShowMessage Title: $'''info''' Message: $'''test info''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed END END IF (ExcelOneData.Columns[0] = 'Package Name' OR ExcelTwoData.Columns[0] = 'Service/ Package Name') = $'''TRUE''' THEN END

How to copy and paste the above code into your Power automate desktop?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏

Was this reply helpful? Yes No
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bensat2 ,

As per my understanding what you have elaborated I have created a solution.
Please find the solution.

Code:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\OneDrive\\Desktop\\Power Automate Desktop\\Practice\\VLOOKUP\\Excel 2.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: ExcelInstance Name: $'''Sheet1'''
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: False RangeValue=> Sheet1_Data
Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: ExcelInstance Name: $'''Sheet2'''
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: False RangeValue=> Sheet2_Data
LOOP FOREACH CurrentItem_Sheet1 IN Sheet1_Data
LOOP FOREACH CurrentItem_Sheet2 IN Sheet2_Data
IF (CurrentItem_Sheet1 = 'Package Name' OR CurrentItem_Sheet2 = 'Service/ Package Name') = $'''True''' THEN
Display.ShowMessageDialog.ShowMessage Message: $'''Both are Equal''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed2
END
END
END

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
bensat2 75 on at

Like
a
(0)

Report
Copy link

Link copied!

i wanted the or condition in the seond operand of the if condition, both solutions given talks about the or in first operand

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@bensat2

Could you please elaborate your requirement?

What is first operand value or variable?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bensat2

If i am right > do you want to do a lookup b/w two sheets based on header values ?

like row['Package Name'] equals row['Service/ Package Name']

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What exactly are you trying to do with the two sheets? Are you trying to compare the two? What is in %CurrentItem%?

Assuming you are likely doing a For each loop on one of the two sheets, %CurrentItem% will contain a data row from one of the sheets, and not both of them. You might need to have one more loop or a Find or replace in data table to find the corresponding value from the other sheet.

The syntax you are using is clearly incorrect, but it can likely be fixed if you elaborated a bit on what you are trying to achieve. Can you maybe share some screenshots of your flow so far?

Was this reply helpful? Yes No
bensat2 75 on at

Like
a
(0)

Report
Copy link

Link copied!

No, I have two sheets and a particular column in one sheet is called package name and in the other the same column is called "Service / package Name". i want to write a if condition as shown below.
I have solved this using another if condition problem is this has icreased my code by another 12 lines
if the condition shown in the image works this will solve my problem.

Was this reply helpful? Yes No
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bensat2 ,

What your getting from "Get Details of Web Page. Can you provide for example what it is extracting. So I can replicate the issue.
And also in that action what drop down option your selecting in Get.

Regards,
Vishnu Reddy
Vishnu Reddy

Was this reply helpful? Yes No
bensat2 75 on at

Like
a
(0)

Report
Copy link

Link copied!

The web page property contains a value whcih is in the package name or Service / Package Name column, if the excel value and the web page value match then some actions are done

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@bensat2
I am uncertain whether we can include two conditions with "or" in the second operand within Power Automate Desktop (PAD).

If it's feasible, could you please share a screenshot of your flow with all sensitive data hidden? This will allow us to assess the setup and offer suggestions for achieving your objective more effectively.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏

Was this reply helpful? Yes No