saving csv files to a sharepoint library is null

(0) Share

Report

Posted on by mthiru_0023

212

I have build a flow using the template to save new email attachments to a SharePoint document library. The flow runs successfully when I receive a new email in my box and uploads the file to the document library but when I select the csv file in the document library it is null and file size is 4 bytes. I have lost the contents of the csv file. Do you know what I am missing.

On new email attachment, I have specified the email inbox folder, Include attachments = Yes, Only with attachment = Yes.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi there,

This issue might occur if your email contains any email signatures. To resolve this, modify the File Name property in your Create File action by using dynamic fields. This will prevent the system from mistakenly treating an image file as a CSV.

Was this reply helpful? Yes No
mthiru_0023 212 on at

Like (0)

Report
Copy link

Link copied!

Thanks Sudeep, I tried that and the csv file is still null.

Was this reply helpful? Yes No
MC-05090511-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,
I've solved my problem converting from base64 To String before "create file" action.
My .CSV file didn't came in blank to sharepoint, but came like an encrypted file.

add "compose" then use the function "base64ToString" on "Attachment content", example: base64ToString(item()?['contentBytes'])

use the output on File content on "Create fie"

Was this reply helpful? Yes No