How do I concatenate an excel file Tabs, using loop flow variable

I have a file an Excel on one SharePoint contains many tabs, and each tab have the same Column.
I need to concatenate all tabs in another SharePoint List different site & it is List not excel.
How can i use Loop for this thing? would you please share screenshot about flow?


Here’s a quick first idea how to solve your requirement:

  1. Read in all tabs (one by one)
  2. Use the Concatenate Node Concatenate – KNIME Community Hub to bring all tables into one

Some ideas.

Look at this examples to read your excel file from sharepoint

Read all sheets

And write as list



Thanks, i found the solution here

Yes i did that before,
but i finally find that loop here

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.