I guess in get transaction data you gave a condition of transactionnumber=1 …that should be removed…and it is not ideal to read in end process why not read all files and then pass each file
Cheers
In get transaction the transaction number is 0.
I have tried for each file file in init state but it is only taking one excel and after processing that it get stopped not going to the next excel.
thats why i used condition in End state like this.
Note 
The end process is replaced with new state(In that condition is given) because we cannot create branches to other states.
- Dont use for each file…
instead use directory.GetFiles("FolderPath") and store this into a variable list of strings say listvar
-
in get transactiondata use if condition with
in_Transactionnumber < listvar.count -
on then side assign
out_TransactionItem = listvar(in_Transactionnumber)and on else side assignout_TransactionItem = Nothing -
in the process xaml you can use in_transactionitem to get the file…and it will loop each file
cheers
Hi @Gokul_Murali - The Re-framework process stops saying Process finished due to no more transaction data if there is an exception at Get Transaction data state. Can you run your flow in debug mode and check
it is showing for the second excel only even though data is there after processing the 1st excel.
The thing is that it is displaying the read data in the initial state but when it moves to the get transaction state it is showing no data to process
do you have any sample to share @Anil_G
@Gokul_Murali - Can you please the variable that you defined to read the data in init All Applications state is a global variable. If possible can you print the output of the variable in the Get Transaction Data and check