If excel column contains red color cell

Help Studio
1

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.

2

@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
3

Hope this link may help you, @oshan

2 Likes
4

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 [‘].”,

5

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

6

thanks

7

Yes , it has the column

image
image905×201 3.27 KB

8

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

9

yes its checked

image
image437×569 11.1 KB

10

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

11

yes, i checked that too. no space
image

12

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

13

:slight_smile:

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

image
image889×603 16.2 KB

1 Like
14

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

1 Like
15

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

image
image1844×824 17.9 KB

1 Like