How to use IF condition between Web and Excel

[Alfred_Gan (Fred)]

Dear All,

Am looking for a solution or if you could share a process that you think for best use case.

But here i have use get text from one of my web by using Get Text feature, and i had created the variable to “NoRecord”,

And i do not know what should i input IF condition expression editor,

Im trying to achieve a process like if there is no record, then write a remark “NO Record”, then continue reading the following numbers.

i have xaml file and excel data as use case example
IfThen use case.xlsx (15.4 KB)
If Then.xaml (9.4 KB)

Thanks.

[Gokul001 (Gokul Balaji)]

HI @Alfred_Gan

You can try with this expression in If activity

String.IsNullorEmpty(NoRecord)

[Alfred_Gan (Fred)]

Hi @Gokul001 ,

Am i using the correct feature to write back to excel by using write cell?

Im getting error as below

what is i only want to write to equally to today’s date column = remark?

[Gokul001 (Gokul Balaji)]

HI @Alfred_Gan

If you need to use Modern activity

1. Use Excel Process Scope activity

2. Use Excel file activity

3. Write cell activity

Excel.Sheet("Sheet name").Cell("A1")

Regards
gokul

[Gokul001 (Gokul Balaji)]

Hi @Alfred_Gan

Use can try with Assign activity quite simple to write status

LHS : row("Column name")
RHS : NoRecord

Outside the For each Row activity use Write range activity

Regards
Gokul

[Alfred_Gan (Fred)]

Hi @Gokul001

Thanks for sharing, it works as you shared.

But lastly, possible to teach robot on writing to remark column for today’s date?

[Gokul001 (Gokul Balaji)]

Great @Alfred_Gan

Kindly close this topic and mark as solved it will help for other user.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

You can try this logic

Use If condition and check for Current Date

Currentrow("Date").Tostring.Contains(Datetime.Now.Tostring) and String.IsNullorEmpty("Remark")

Regards
Gokul