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

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
v-yuazh-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
v-yuazh-msft
Community Support
Community Support

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

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,076)