I have 10 excel workbooks (can be stored on onedrive, teams etc..). They contain member statistics for different cities within a region. Each region has a separate excel sheet. In each sheet there is one column for each city.
So the columns and number of columns differs from one sheet to another.
Sheet A columns:
Stockholm, Västerås, Eskilstuna
Sheet B columns:
Avesta, Borlänge, Mora, Sälen, Orsa
I would like to create a flow that iterates trough all columns of one of these sheets and picks the column name and the column-value and stores that in a SharePoint list instead.
Columns in SharePont list could be
City, Number of members
Is there a way to get an excel-row in flow and then iterate its columns and get one column name/value at the time and do something with it?