If condition with OR in second operand

[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

[Deenuji]

@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 🙏

[VishnuReddy1997]

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

[bensat2]

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

[Deenuji]

@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 🙏

[Nived_Nambiar]

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! 🙌

[Agnius]

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? 

[bensat2]

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.

[VishnuReddy1997]

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

[bensat2]

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

[Deenuji]

@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 🙏

[bensat2]

i used two if conditions and solved the same

[Nived_Nambiar]

Hi @bensat2 

Not sure 

Looking at screenshot of if condition, does that work ?

I think Or operators requires boolean values to be compared 

I feel correct format would be 

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! 🙌

[VishnuReddy1997]

Hi @bensat2 ,

Please find the solution. Just check whether the below one works. Just created a sample flow take it as reference.

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

Thanks & Regards

Vishnu Reddy

[Agnius]

If you have two sheets, you cannot have a single %CurrentItem% that targets values from both of them, unless you first merged the data tables from the two sheets into one. You most likely are using an incorrect variable there, and you probably need two loops to target two different tables.

Other than that, the correct syntax to use is what @Nived_Nambiar suggested (apart from the %CurrentItem% being the same for both tables, which is likely not correct), where you compare the value from the web page with the values from each sheet in Excel and put in %True% in the second operand. 

@VishnuReddy1997 included two loops to resolve the issue with it being two separate sheets, so that's actually likely the best solution suggested here.

[Nived_Nambiar]

Thanks @Agnius  for the pointing out the mistake in if condition logic if i have written , i forget about that usecase is to compare two sheets 🙂

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! 🙌