cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Convert Excel matrix to Sharepoint list/table

Hi!

 

I'm trying to convert a Excel martix with a budget to a table in a Sharepoint list.

Is this possible? Can any one point me at the right direction? Right now I have managed to get all the rows from the Excel-sheet table into an array but I cant find a way to transform them to a list with one item per Activity and perod (as in the list example below).

 

Would be super happy for some guidence!

// Tomas

 

I've got (in Exel on a SP site)image.png

 

 

 

 

 

 

 

 

I would like:

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Convert Excel matrix to Sharepoint list/table

Hi @Spångberg,

 

I have made a test on my side to create an excel table and save the excel file in sharepoint library as below:

Capture.PNG And I have created a sharepoint list as below:

Capture.PNG

 

You could refer to screenshot below to Create the flow:

Capture.PNG

Capture.PNG

Capture.PNG

Capture.PNG

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

And items would be created in sharepoint list as below:

Capture.PNG

 

 

Best regards,

Alice

View solution in original post

5 REPLIES 5
Highlighted
Community Support
Community Support

Re: Convert Excel matrix to Sharepoint list/table

Hi @Spångberg,

 

I have made a test on my side to create an excel table and save the excel file in sharepoint library as below:

Capture.PNG And I have created a sharepoint list as below:

Capture.PNG

 

You could refer to screenshot below to Create the flow:

Capture.PNG

Capture.PNG

Capture.PNG

Capture.PNG

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

And items would be created in sharepoint list as below:

Capture.PNG

 

 

Best regards,

Alice

View solution in original post

Highlighted
Advocate II
Advocate II

Re: Convert Excel matrix to Sharepoint list/table

Hi Alice!

 

Thanks for the suggestion. This works if i have a fixed set of "periods" but I need a way to fetch the period names (and number of periods) from the column names and add them dynamicly to the Flow, any ideas?

 

Regards!

// Tomas

Highlighted
Community Support
Community Support

Re: Convert Excel matrix to Sharepoint list/table

Hi @Spångberg

 

There is no any way to fetch the column names in microsoft flow currently.And I afraid that there is no any way to achieve the requirement in microsoft flow currently.

 

If you would like the function to fetch the column names to be supported in microsoft flow, please submit an idea to flow idea forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Alice

Highlighted
Advocate II
Advocate II

Re: Convert Excel matrix to Sharepoint list/table

OK, thanks for clearyfing it.

What if I did put the column names in the first row, would it be possible then?

 

Like this:

Capture.PNG

Highlighted
Community Support
Community Support

Re: Convert Excel matrix to Sharepoint list/table

Hi @Spångberg,

 

If you put the column names in the first row, you could add a "Get row" action of Excel connector to get the first row.

And then you could use the dynamic content from the "Get row" action in the following steps.

 

Best regards,

Alice

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (4,686)