cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Post Prodigy
Post Prodigy

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

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

6 REPLIES 6
Highlighted
Post Prodigy
Post Prodigy

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

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.

 

Highlighted
Frequent Visitor

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

@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.

Highlighted
Post Prodigy
Post Prodigy

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

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.

Highlighted
Frequent Visitor

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

@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.

Highlighted
Post Prodigy
Post Prodigy

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

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

Highlighted
New Member

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

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

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

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

Top Solution Authors
Top Kudoed Authors
Users online (8,657)