Pass on Data from one flowchart to another flowchart

[AlbertM (Albert)]

Hi,

I am currently trying to pass on the data value from one flowchart to another flowchart and need to retrieve the value in another flowchart but unable to do it.

this is my build so far
Open up excel file, store range B22:AN93 as Data1 , then for each row in Data1, invoke workflow ““01B_Execute_Report.xaml””

my question is how to retrieve the value of column 2 and column 3 of that particular row ?

I have tried ‘in_Data1.columns(4).ToString’ or ‘in_Data1_Rows(2).ToString’ without avail.

Much appreciated. !

[PD2 (Priya)]

Hi @AlbertM,

To get the 2nd and 3rd column from a row, you would use the “Row” variable you have in your for each loop:

row(2).ToString() 
or
row("Column2Name").ToString()

Same goes for row3

row(3).ToString() 
or
row("Column3Name").ToString()

Regards,
PD

[AlbertM (Albert)]

Hi PD,

thanks for your quick reply - I got this error, I am trying to retrieve the value in a different process.

Thank you