Forum Discussion
Need Help - Importing excel files from MS Teams; how to select all sheets within the file
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 f...
lbendlin
Super User
Super UserTake 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.
Thank you for your suggestion! I will give it a try, hopefully it will work.
Have a great week.
Kr,
AZ