Invoke method Not Working

Help
, ,
1

Hi All,

I have an excel with 3 columns and i need to fetch the rows whichever i’ll give in the condition inside for each loop. I’m using Invoke Method to fetch the row details into new datatable but i’m getting null, i’ve used invoke method few times before but now it’s not working. Please refer input excel as well as xaml file.

Note : This problem can be achieved alternatively with the Select statement. InputNonPO.xlsx (8.6 KB)
SequenceSample.xaml (8.8 KB)

In addition to that it’s not working, if i use Add Data Row by passing row into DataRow but it works when i pass arrayrow.
Thanks.
Goutham Vijay

2

Hi Goutham,
can you use this
row(2).ToString.TrimStart.TrimEnd=“Mangalore”

1 Like
3

Read Range the Excel store in DatatableVariable1.

Use assign and use below code.

DatatableVariable2 = (from x in DatatableVariable1.asEnumerable() where convert.tostring(x(“Place”)).trim.tolower.contains(“mangalore”)
select x).copytodatatable

You can also use Filter datatable activity

1 Like
4

No this is not working…

5

I know this method…but i’m trying through invoke method…
Thanks.

8

Check the Workflow

SequenceSample (1).xaml (8.6 KB)

2 Likes
9

It’s working now…why can’t we create new datatable and assign it to invoke method?, any idea…

10

You are not creating the Required columns. there is discrepancy in column count and the Structure of the DataTable

11

Oh ok…i think the same say it works for an add data row, we should add column before.

Thanks.

12

Cheers,
Happy Automating :+1:

13

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