Power Platform Community Forum Thread Details

Hello.

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.

Excamle

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?

Best Regards

Mike

Categories:

Building flows