Get all the row value of the data table

Buddy @James90

–use a if condition and use a condition you want to validate the date in the fourth column
–if the condition gets passed it will go to THEN part of if condition where you can get the whole row as a value with your variable Datarow lke this
Datarow = row
where row is the variable obtained from for each row loop as it iterates through each row in the datatable you have passed buddy
Cheers @James90

1 Like

@James90

I already provided this solution at starting only. Please Check it.

                      ForEach row in DataTableName
                      Int index = DataTableName.Rows.IndexOf(row) + 2
                      If row(4).Tostring = "Text"
                      Then:
                       DataRow dr = DataTableName(index)
1 Like

were you able to get now buddy @James90

1 Like

@Palaniyappan
@lakshman
I am not getting the output that i want is not coming, can you please share with small demo if you have time.

1 Like

@James90

If possible could you please share your xaml and excel file. Will check once.

1 Like

if possible can we have a view on your xaml buddy @James90

1 Like

@Palaniyappan
@lakshman
Here is my workflow.Flowchart.xaml (14.9 KB) shared.xlsx (9.3 KB)

buddy send with project.json file and send them all together as a zipped folder buddy @James90
unable to view certain activities
Cheers

1 Like

@Palaniyappan
Getting some error in sending zip file, Here is project.json. project.json (780 Bytes)

1 Like

still buddy @James90
image

1 Like

@Palaniyappan
Thats Gsuite scope activity