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

Send Email with csv attachment

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 ValueJSON Array ValueError when trying to get .csv attachmentError when trying to get .csv attachment

3 REPLIES 3
v-xida-msft
Community Support
Community Support

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:16.JPG

But the output that we want actually as below:17.JPG

 

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

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Here is the entire flow. 

SendEmailAttachment.PNG

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?

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (89,231)