How to update the coloums after process

in this use case i getting the mail address from transation item and i have to check if the email address status is open if so run the process else move to next

how to find its open or close once after the process done i have to update the status coloum as a new below column

Report.xlsx (9.8 KB)

1 Like

Hi @Tharusha_Fernando,

you can try this below query to check the status

listVar = ( From row In dataTable.AsEnumerable() Where row.Item(“Email”).ToString.Equals(“mailId’s”) Select row.Item(“Status”)).ToList(0)

Now use If condition like this if listVar.ToString.Equals(“Open”)


hi @Pradeep_Shiv what type of variable is used

1 Like


1 Like

hi @Pradeep_Shiv still not working

1 Like

What’s the error?

Hi @Tharusha_Fernando,

Try this QueryToCheckStatus.xaml (8.4 KB)

Hi @Tharusha_Fernando
You can try this too

sample (895.1 KB)

I think this is according to your requirement

Nived N
Happy Automation

1 Like

thank you @Pradeep_Shiv @NIVED_NAMBIAR

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.