How to update the coloums after process

Help Studio
, ,
1

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 close.in a new below column

Capture
Capture1126Ă—338 19.1 KB
Report.xlsx (9.8 KB)

1 Like
2

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”)

Cheers
@Tharusha_Fernando

3

hi @Pradeep_Shiv what type of variable is used

1 Like
4

listofString

1 Like
5

Capture
hi @Pradeep_Shiv still not working

1 Like
6

What’s the error?

7

Hi @Tharusha_Fernando,

Try this QueryToCheckStatus.xaml (8.4 KB)

9

Hi @Tharusha_Fernando
You can try this too

sample workflow.zip (895.1 KB)

I think this is according to your requirement

Regards
Nived N
Happy Automation

1 Like
10

thank you @Pradeep_Shiv @NIVED_NAMBIAR

1 Like
11

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