cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RaoulDobal
Level: Powered On

Create Excel file through flow with data from List

I would like to create or update an excel file with data from a sharepoint list.

 

I have identical data different vendors need regularily but of course in different excel files, structured slightly differently. 

 

In order to simplify the process, I thought having a SharePoint list filled with the necessary information, press a button and the content is filled into excel files according to the predefined templates and then sent off as an email attachment. 

 

Do you see any way to do this via flow? The option of doing everything in excel does somehow not strike my fancy.

 

Thank you for your time

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Create Excel file through flow with data from List

Hi @RaoulDobal,

 

Please create a excel table in your Onedrive for business, the table should contain all the columns you want to send.

 

I have made a test on my side and have create a excel table in Onedrive for business as below:

Capture.PNG

 

I have created a sharepoint list as below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG 

 

 

A email would be sent with attachment as below:

Capture.PNG

 

Best regards,

Alice

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Create Excel file through flow with data from List

Hi @RaoulDobal,

 

Please create a excel table in your Onedrive for business, the table should contain all the columns you want to send.

 

I have made a test on my side and have create a excel table in Onedrive for business as below:

Capture.PNG

 

I have created a sharepoint list as below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG 

 

 

A email would be sent with attachment as below:

Capture.PNG

 

Best regards,

Alice

RaoulDobal
Level: Powered On

Re: Create Excel file through flow with data from List

Thanks for that - I concur, this works fine. 

 

The only snag here ist that it is based on a onedrive for business solution and not a sharepoint library. Since this is a team-based task, the template library should be in sharepoint. Again, there are workarounds, but If possible, I would like to avoid have special shared folders for teams - this is what sharepoint is there for.

 

Raoul 

Helpful resources

Announcements
firstImage

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

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 Flow Community Video Gallery!

Users Online
Currently online: 217 members 5,188 guests
Please welcome our newest community members: