How to write if sequence if specific cell exists?

Help Studio
, ,
1

Hi, I am new to uiPath. I am trying to write an if statement that if a value in an excel box exists, to show message “Customer has been billed”. The value is a date in the excel file that proves the customer was billed. For some customers, there is no value, hence I would write an if statement that “Customer has not been billed”

2

This is the link to the excel file https://docs.google.com/spreadsheets/d/1R3oQzv3ITf4fXR-uXpgWHZtk81gh_led/edit?usp=sharing&ouid=104054591438406330937&rtpof=true&sd=true

This is the link to my uiPath Studio project. The beginning is where I need help https://drive.google.com/file/d/1m4JzDH-NLwYbWUkASTzewXwk03n2169k/view?usp=sharing

3

Hi @Jimmy_Singh

  1. Read the Input excel file. store it in the DT variable.

    image
    image1283×443 24.8 KB

  2. Use For each row in DT and if activity
    image

This the code need to modified

image
image967×546 13 KB

Regards
Gokul

1 Like
4

Hey Gokul. I am getting the error Error: ERROR Validation Error Compiler error(s) encountered processing expression “CurrentRow(“Billed”).ToString=”“”.
‘CurrentRow’ is not declared. It may be inaccessible due to its protection level.

5

Hi

You are almost done

Mention the condition like this in if activity

NOT String.IsNullOrEmpty(CurrentRow(“Billed”).ToString.Trim)

If true it means there is a value and it goes to THEN Block where you can write as

Or it goes to ELSE block

And this error came because your for each row activity will have a variable in it
Either as row or CurrentRow

If it’s row then the condition will be like this
NOT String.IsNullOrEmpty(row(“Billed”).ToString.Trim)

If it’s CurrentRow then this
NOT String.IsNullOrEmpty(CurrentRow(“Billed”).ToString.Trim)

As simple as that

Cheers @Jimmy_Singh

1 Like
6

Thank You for your detailed response.Now I am not receiving an error after entering: NOT String.IsNullOrEmpty(CurrentRow(“Billed”).ToString.Trim) but I am not receiving a message box when I run the file.

7

I got the first row to work for M1:M2 but when I do M3:M3 in the read range, I don’t get a message box

8
  • You can use the For each row in Data Table variable “row”

Regards
Gokul