How to correctly set the condition for filtering a column

Help Robot
, ,
1

I filtered the table and now I need to set a condition, if column “Document type” contains the value “RM”, then we update the table.
I used activity For each and added a condition if
row(“Document type”).ToString.Contains(“RM”)
but the robot gives an error, please tell me what the error is

process2
process21765×855 85.3 KB

2

Hi @yulya

You need to use For each row of datatable instead of For each item!

Regards

3

@yulya

You are using For Each activity in the flowchart. This activity is for perform serious of actions on each element of an enumeration. The Argument Type Should support IEnumerable.

UiPath providing a dedicated activity ‘For Each Row in DataTable’

and of course you can filter it whatever you want by using LINQ query/expression. Ex: (select, where etc)

For Each and For each row in Table
For Each and For each row in Table573×618 13.6 KB

Hope this will help you. Thank you.

4

Yes, thank you!

5

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