Check partial content

[RPA3]

Hello!
I have DT:

I need: IF in column1 has “hello” - take number from column 2
FOR EACH ROW
IF (“hello”)
{What do where??} I need get 2,3,4 rows

[msan (Michel SAN)]

ForEach datarow in DT.AsEnumerable().AsQueryable().Where(Function(x) x(“Column1”).ToString.Contains(“hello”))

[GBK]

pls use the For Each Row activity and pass the datatable as input
inside foreach row activity add if activity and add condition like if(item(“column1”).ToString.Contains(“hello”)
True section
you can write item(“COLUMNNAME”).ToString to get the column info

[RPA3]

@GBK

ctivity and add cond

What if I haven’t columnName? I write: DT.AsEnumerable().AsQueryable().Where(Function(x) x(0).ToString.Contains(“hello”))
And catch error:
For Each: An ActivityContext can only be accessed within the scope of the function it was passed into.
Object name: ‘System.Activities.CodeActivityContext’.

[RPA3]

It’s get only " hello"
Not “afjeoqif hello” - but I need it too

[msan (Michel SAN)]

Use ForEach activity on

DT.AsEnumerable().AsQueryable().Where(Function(x) x(0).ToString.Contains("hello")

(type is DataRow)

[RPA3]

I did it, and catch:
For Each: An ActivityContext can only be accessed within the scope of the function it was passed into.
Object name: ‘System.Activities.CodeActivityContext’.

[msan (Michel SAN)]

Build DataTable as DT

Workflow
with an example of output on the fly of the column1 content
with a ForEach loop outputting the content of each filtered column2

Details of the log activity

Details of the ForEach activity

Output