Unanswered

how to test blank cell in if condition

(0) Share

Report

Posted on by bensat2

I have a if conition as shown below

you can see i have used .trimmed in the second operand else my result returns as below i,e it shows not matched. But if the cell in the excel sheet is blank then i get error message sayinh that .trimmed is not a property. I use then String('Currentitem2['End User Bill"]). My ouput will be like this

You can see if dont use trimmed then end user shows not matched if i use String(%Currentitem2['End User Bill"],trimmed%) i get the error i mentioned earlier. My excel sheet may have values or blanks, and also when there are values unless i use .Trimmed it shows it is not matching.

I have used a if and solved but it means duplicating code in the True part and the false part, can we have this solved within the if Dialog box.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@bensat2

Follow below approach:

1. First check both cell values have not empty value
2. Then try to compare the both cell values
First If condition:
Second If condition:
Code:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Boot\\Invoicecheck.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData LOOP FOREACH CurrentItem IN ExcelData IF (IsNotEmpty(CurrentItem['Excel Value']) AND IsNotEmpty(CurrentItem['ERIF Value'])) = True THEN IF (CurrentItem['Excel Value'].Trimmed = CurrentItem['ERIF Value'].Trimmed) = True THEN Display.ShowMessageDialog.ShowMessage Title: $'''Info''' Message: $'''Matching''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed END END END

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 🚀

Was this reply helpful? Yes No
bensat2 75 on at

Like
a
(0)

Report
Copy link

Link copied!

let me try

Was this reply helpful? Yes No
bensat2 75 on at

Like
a
(0)

Report
Copy link

Link copied!

The erif is a web portal not an excel sheet. your solution is the same as my If conditon i used. It is not simplifying in any way.

Was this reply helpful? Yes No
bensat2 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Deenuji i iused if excel value isntempty then use %currentitem2.Trimmed% else string(%currentitem2%). I was looking at if we could some way in the same if dialog box test for both a value or a blank.

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

Like
a
(0)

Report
Copy link

Link copied!

@bensat2

You can utilize the following if condition to assess both the value and emptiness. However, please be aware that attempting to trim the value of your current item might result in an error if the current item column is empty.

In case if you want to trim the value then you may follow the previous suggested solution where first check both column hasn't empty values then compare with trim function.

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 🚀

Was this reply helpful? Yes No
bensat2 75 on at

Like
a
(1)

Report
Copy link

Link copied!

yes you are right when the trimmed is present it throws error when there is a blank in the excel

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @bensat2

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 🚀

Was this reply helpful? Yes No