You’re offline. This is a read only version of the page.
Announcements
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:
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.'.
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.
Share
Report
All responses (
Answers (
11,681
