import excel table and create multiple SP lists from the tabs

(0) Share

Report

Posted on by mjackson122

I am able to create a flow that imports a excel file with a table and then creates a list in SharePoint based off of one of the tabs. But my goal is to have one flow that creates several SharePoint lists based on 5 tabs in my one Excel file. All of the tabs contain the same columns its just different information. I also have a master tab which populates the other 5 tabs in my excel file don't know if that helps or not.

All responses (1)

Answers (0)

Rodrigo Hentz on at

Like (0)

Report

Re: import excel table and create multiple SP lists from the tabs

Hi @mjackson122 how are you?

@mjackson122 in fact, what you need is to set a name for each table that you want to query using Power Automate.

Sample:

At Power Automate, load the table using the Excel connector and after that create the items on SharePoint using a apply for each

Please let me know if you have any doubts or concerns about the solution provided.

Regards

Rodrigo Hentz
Microsoft Support Engineer