Need Help - Importing excel files from MS Teams; how to select all sheets within the file

[AZ17]

Hi there!

I am trying to connect my excel sheets/file from MS Teams' environment. I can create the connection, load everything, select the file, etc. However, I can only chose one sheet in that file while I would like to select multiple of them. Each sheet has identical number of column with identical names (using template), the number of rows differ but that should not matter. 

The sheets represent months, I have tried to write an advanced editor formula, however, I could not make that work. 

Any clues how to go around this and get all the sheets from a file into one table? I cannot be the first one to face this problem haha. 

Thank you for all suggestions and help, have a great day!

Kind regards,

AZ

[lbendlin]

Take the transforms you applied to that sheet and make them into a separate function.  Then in the previous step (where it listed all sheets) add a custom column that applies the function to each sheet's content.  Then combine the results by expanding the added column.

[AZ17]

Thank you for your suggestion! I will give it a try, hopefully it will work. 

Have a great week. 

Kr,

AZ