Check data table has particular value or not

Help Studio
1

Hello,

My scenario is that bot is filtering tickets and storing them in data table. After that bot is further filtering that data table with 3 types of role name. Then only it will proceed. I am using the below expression to check this but it is not working -
dt.AsEnumerable().Any(Function(x)x(“ColumnName”).ToString = “Value1”) Or dt.AsEnumerable().Any(Function(x)x(“ColumnName”).ToString = “Value2”) Or dt.AsEnumerable().Any(Function(x)x(“ColumnName”).ToString = “Value3”)

Please help me in resolving this.

Thank you.

2

@mannu.1996.08
give a try on following:
grafik

dtData.AsEnumerable.Any(Function (x) {"Value1","Value2","Value3"}.Contains(x("Column1").toString.Trim))

testing the opposite case:
grafik

2 Likes
3

Hey use my activity for this :smiley:

4

sure. I will give a try on this .Thank you @ppr .

5

Sure. I will check this one. Thank you @ Mikolaj_Zielinski

6

i tried your expression . It is working . Thank you @ppr

7

as i tried with the normal data table expression provided above and it worked so i couldn’t try your activity this time. Thank you @Mikolaj_Zielinski .

8

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