Unanswered

Save my CSV email attachments to a SharePoint document library

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

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.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

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:

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

Best Regards,

Was this reply helpful? Yes No
nabjad 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Kyle411 5 on at

Like (1)

Report
Copy link

Link copied!

I had the same issue with the gibberish, but then when I used a different trigger it worked.

Was this reply helpful? Yes No
v-imbas Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Use the Get Email action card just below the when a new email arrives, then use the dynamic content coming from Get Email action card. This will create the attachments in SharePoint without corrupting your files.

@Kyle411 Please go ahead and accept this as a solution if this works.

Was this reply helpful? Yes No
JeremieS 11 on at

Like (0)

Report
Copy link

Link copied!

Using the attachment name does work, but if we wanted to have the file as a custom name, like Report.csv, then the contents are not displayed properly.

How can we save with a custom name, extension of csv

Edit: I was trying to save my attachments with spaces in them, which caused the content to be gone, but once I removed spaces from the naming, I was able to name it however I desired.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hey,

I had the same problem with the gibberish and after some playing around, managed to fix it by using 'Content Bytes' in the 'File Content':

Was this reply helpful? Yes No
Belin on at

Like (0)

Report
Copy link

Link copied!

this worked for me, thanks

Was this reply helpful? Yes No
pmenown 3 on at

Like (0)

Report
Copy link

Link copied!

I ran into the same issue when using the 'When a new email arrives in a shared mailbox (V2)' Outlook Trigger and trying to save a CSV file attachment and i believe the test functionality creates a dummy .csv file with random data (IkhEUiIsIkRMNTAwMSIsIkJST0tFUiBERVRBSUxFRC...). However when the flow was triggered by sending a real email the content was perfectly legible.

Was this reply helpful? Yes No
L-T_Emma 15 on at

Like (0)

Report
Copy link

Link copied!

I had the same issue and this is the only fix that has worked for me. Thank you 🙂

Was this reply helpful? Yes No