Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Converting a CSV file to JSON


I'm working on a Flow to take updates from a vendor and put it into our system.


I've been following along with this tutorial to convert the CSV to JSON and I'm having a bit of trouble. I'm stuck on Step 3. 




I'm not sure what the "Append to array variable" is supposed to be or do. Nothing I put in there seems to work. Also, when I try and test run the "Apply to Each" section that follows (Assuming I skip that append) I get an error.2019-01-23_13-46-37.png

Does anyone have any advice? Sorting this out would make my life a lot easier.

Level: Powered On

Re: Converting a CSV file to JSON



Try contacting Serge direct he helped me out within 24 hours.  I will say that not everything is shown on his blog posts.





Community Support Team
Community Support Team

Re: Converting a CSV file to JSON

Hi @RTW,


The action Append to array variables is used to add a new value to the end of the list. This is most useful inside an Apply to each, where you can continue adding new items into the array each time the loop runs.

Please check the blog at here for more details on it:

Besides, please check For each approver part in this blog for more details on how to use this action:

Hope it could be helpful for you.


Best regards,



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

Re: Converting a CSV file to JSON

You can use Parse CSV action from Plumsail Documents connector. It allows you to convert CSV into an array and variables for each column. Please read this article demonstrating how it works.

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,500)