cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Spångberg
Level: Powered On

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
Community Support Team
Community Support Team

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
Community Support Team
Community Support Team

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

Spångberg
Level: Powered On

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

Community Support Team
Community Support Team

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
Spångberg
Level: Powered On

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

Community Support Team
Community Support Team

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,892)