If excel column contains red color cell

Hi friends
thanks for your great help always.

I have an excel with 2 columns. i want to send an email only when the 2 nd column contains any red colored cell / or text as “error” .

how can i achieve it.

@oshan I guess you can try these Simple Steps:

  1. Use Read Range Activity and Get the Datatable Output say DT.

  2. Use this Expression in an If Activity :
    DT.Select("[Column 2] = ‘error’").ToArray.Count >0
    In the Then Block
    You can send an Email

Where Column 2 Should be your Column Name.

Check if it Works.

2 Likes

Hope this link may help you, @oshan

2 Likes

Hi, I used the below.
ResultDt.Select(“Result like ‘%エラー%’”).ToArray.Count >0

but getting this error. DO you have any idea
message": “If: Cannot find column [‘].”,

@oshan Do you have a Column with the name Result ?

thanks

Yes , it has the column

@oshan Have you Checked Add Headers in Read Range Activity ?

yes its checked

@oshan In that Case Check if the “Result” has Extra Spaces with it.

yes, i checked that too. no space
image

@oshan That is Strange :sweat_smile: , Can you Send the Screenshot of the Workflow as to look at how you have built the design.

:slight_smile:

dont know the root cause. so i changed as below using filter . its working now.

1 Like

@oshan Great :smiley:. Just for Confirmation, Can you show what was Condition that you have provided in the Filter Wizard.

1 Like

here エラー in valueis “Error” in japanese.

1 Like