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.
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.
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:
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?
Check out new user group experience and if you are a leader please create your group
May the fourth be with you, join us online!
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.