08-03-2020 11:49 AM - last edited 08-03-2020 11:50 AM
I've seen many times here people asking for ways to parse CSV files, but the answer is always "use external component X or Y." Depending on external components can lead to trouble, so I created a Power Automate that you can invoke from anywhere in a solution where you can get a nicely formatted JSON that you can then use to parse the information.
I go into extreme detail in how it works here:
So please be sure to check it if you have any questions.