Failed Converting CSV/Text File (via Get Attachment(V2)) to JSON Object using a Filter Array Action

(0) Share

Report

Posted on by Community Power Pla...

Hi!

I'm trying to create a flow that will get the attachment file (CSV) received via e-mail and apply a filter to get certain values on several columns before I put them on a SharePoint List.

So I got the error below for the Filter Array action using this Expression:

json(split(base64ToString(outputs('Get_Attachment_(V2)')?['body/contentBytes']),outputs('New_Line')))

Error Details:

Unable to process template language expressions in action 'Filter_array_–_Convert_to_usable_form' inputs at line '0' and column '0': 'The template language function 'json' expects its parameter to be a string or an XML. The provided value is of type 'Array'. Please see https://aka.ms/logicexpressions#json for usage details.'.

All responses (1)

Answers (1)

Verified answer

Ellis Karim 10,847 Super User 2025 Season 1 on at

Like (1)

Report

Re: Failed Converting CSV/Text File (via Get Attachment(V2)) to JSON Object using a Filter Array Action

Please see: Power Automate: How to parse a CSV File to create a JSON array
"There are no built in actions in Power Automate to Parse a CSV File. There are external connectors which can do this for you, but this blog post will cover how to Parse a CSV in Power Automate without the use of any external connectors."
The flow in the above post is a very simple flow can be easily recreated.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.