Unanswered

Send Email with csv attachment

(0) Share

Report

Posted on by Stephen_Tyson

I am trying to send multiple .csv attachments in a single email bit it keeps failing stating "Invalid Template" other file types I have tested and work flawless .png, .jpg, .xlsx no problem sending the email, It is only the .csv files that are failing. I followed this post to create the flow and used Expression "body('Get_attachment_content').$content" in the Array instead of the SharePoint Get attachment.

ERROR RECEIVED

InvalidTemplate. Unable to process template language expressions in action 'Append_to_array_variable' inputs at line '1' and column '2325': 'The template language expression 'body('Get_attachment_content').$content' cannot be evaluated because property '$content' cannot be selected. Property selection is not supported on values of type 'String'. Please see https://aka.ms/logicexpressions for usage details.'.

The flow below works for all common file types except .csv.

JSON Array ValueError when trying to get .csv attachment

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Stephen_Tyson,

Could you please share a full screenshot of your flow's configuration?

The issue is confirmed on my side, if the attachments related to the item is CSV files, the "Get attachment content" action returned is binary text representation of the content of CSV file and the output of this action doesn't include $content property:

But the output that we want actually as below:

If the attachments is CSV files, the "Get attachment content" action returned is binary data, but there is no way to analyze binary data in Microsoft Flow currently, so I afraid that there is no way to send multiple .CSV attachments in a single email.

In addition, you could consider take a try to manually convert the CSV files into .XLSX files firstly and then send multiple .XLSX files in a single email.

If you would like this feature to be improved in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Kris

Was this reply helpful? Yes No
Stephen_Tyson 7 on at

Like (0)

Report
Copy link

Link copied!

Here is the entire flow.

Was this reply helpful? Yes No
tcarr 2 on at

Like (0)

Report
Copy link

Link copied!

I have the exact same problem as the original poster. All attachments seem to work fine with Flow except for CSV extensions. Is this a known behavior/bug with Flow? Is there a workaround that would allow me to build an error-handler for CSV files and treat them differently?

Was this reply helpful? Yes No