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:
https://manueltgomes.com/microsoft/powerautomate/how-to-parse-csv-file/
So please be sure to check it if you have any questions.