WF Read multiple Spreadsheets

Hi all,

could you please check my WF, maybe/hopefully there is just sth small missing, I’m not that familiar with loops so far:

WF_Read_multiple_files.knwf (29.1 KB)

DemoData_2022.xls (49 KB)

I managed to read all the spreadsheet names, and have an correct iteration and the correct spreadsheet name, but always with the data from the first spreadsheet, I would like to have the data from each Spreadsheet there, and not only from the first

Any ideas what I did wrong?

Thank you very much!

@Maya229 it might be this problem. You could try and force the use of sheet name via Flow Variable: