cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amorris2
Frequent Visitor

Convert Excel File from outlook to Excel Table in sharepoint using Flow

I'm trying to use flow to take an excel file from a delivered email, convert the file to an excel table and upload the new table to sharepoint. Below is the current flow that I have.  The current flow puts a regular excel file into sharepoint, but I need this file converted to a table.

Part 1Part 1Part 2Part 2

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @amorris2,

 

Currently, there is no action could create table directly in the newly created excel file, so you need to manually open the file to create a table.

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
v-lin-msft
Post Prodigy
Post Prodigy

Hi @amorris2,

 

What do you mean by the table? Is it a SharePoint list?

If so, after you have converted the file received from email to an excel file, you could to add each row of the table in excel to the item in the SharePoint list by action create items of connector SharePoint.Annotation 2019-06-21 102646.png

If not, could you please tell me the specific table you refer to?

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

@v-lin-msft,

Right now I just have the file going to sharepoint as a regular excel file, it is not a sharepoint list.  Basically my end game is to be able to use power query off of that data, and also to use the data for some power BI Dashboards.  If creating a sharepoint list (I also would need help with creating this flow too) is my best option, then I can do that as well.  I just know when I try to load the current file into power BI, it says it has to be in a table format.

Hi @amorris2,

 

So your question is when the file was imported into PowerBI something went wrong, right?

You can check whether there is a complete table in the excel file that you need to import. Since the excel file created in this way does not create a table, you need to create a table manually.

This is done by selecting all the data in excel, including column names, and then clicking the "Insert Table".

Annotation 2019-06-24 095833.png

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-lin-msft,


Correct.  I'm getting a report out of a different BI system and the file is not in a table format.  I'm trying to automate the process without having to open the file, select data source, and then create table.  I want this to be done using Flow and have it also uploaded to my Sharepoint site using flow as well.

Hi @amorris2,

 

Currently, there is no action could create table directly in the newly created excel file, so you need to manually open the file to create a table.

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I'm having the same issue, wanted to follow up whether anyone was able to find a solution to this

djmitz6
Frequent Visitor

If you have Excel Online (Business) you can actually create an office script that will convert a range to a table.

 

After you update your file on Sharepoint you need to add a Excel Online (Business) "Run script" step.

 

To write the script you need to go into Excel Online and click on the Automate tab. Once there click "All Scripts" then in the right pane click "New Script". Enter the below code or modify as needed.

 

function main(workbook: ExcelScript.Workbook) {
  //Sets the Active Worksheet to the first worksheet in the workbook
  let selectedSheet = workbook.getWorksheets()[0];
  //Get used range of previously mentioned worksheet 
  let usedRange = selectedSheet.getUsedRange()
  // Add a new table
  let newTable = workbook.addTable(usedRange, true);
  return newTable.getId();
}

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,049)