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

Save my CSV email attachments to a SharePoint document library

Hi, I have a data system sending me a daily email with an attached CSV file containing sales data.  I am trying to get this file into my Sharepoint document library so I can use it as a data source for Power BI.

 

I am using this standard flow template: Save my email attachments to a Sharepoint Document Library to take that attachment and save to Sharepoint.

 

The flow seems to run fine, however the CSV file that is saved in Sharepoint is complete gibberish

 

excel-gibberish.JPG

 

Below is the "Create File" part of the flow.  Note: I have an email rule set up to move these data emails to a particular folder, and the flow is only looking for new emails in that folder. Each email only has one attachment, Phocas.csv.

 

file-creation.JPG

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Save my CSV email attachments to a SharePoint document library

Hi @Sandie ,

 

I used the template you provided on my side to test it, and did not meet the problem you mentioned.

After the file is opened, it is consistent with the content of the original file.

Try to use Attachment Name to configure the File Name field directly. If you fill in a fixed value, it will cause the file with the same name to be overwritten.

If you just want to save the attachment file to SharePoint library every day, try using the following configuration directly:

3.PNG

Please take a try and let me know if issue still exist.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
nabjad
Level: Power Up

Re: Save my CSV email attachments to a SharePoint document library

so, I am having a similar problem with CSV attachnments saving to sharepoint. except mine do not save at all instead of giving gibberish.. it looks like a large csv (15Mb) wouldnt work, but a csv of size 200Kb works fine.

the problem doesnt occur with other type of attachments (xlsx, Pbix...etc) only csv.

Helpful resources

Announcements
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!

fourthImage

Australia Summit

Travel to Melbourne and network with thousands of peers!

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!

Top Kudoed Authors
Users Online
Currently online: 31 members 4,417 guests
Please welcome our newest community members: