Hello!
I have DataTable, which get from this excel file.
And I have array of string with data {“aaa”,“ccc”,“eee”}
I want get datatable in which the column Role values will be from this array.
DataRows = “bbb” and “ddd” must be delete.
Buddy @Aleksey_M
here is your xaml buddy
its resolved, kindly check with excel with sheet that has row deleted with ddd and bbb
and array value added to the column Role…finally with no ddd and bbb example.zip (17.9 KB)
I have just created the DataTable in the workflow, but this does what you ask. You can adapt to your needs. It looks at the values and if they are contained in the array, they’ll be copied to another datatable.