Power Automate csv to json

[RMVW]

Hello Guys,

I really need your help. I tried everything to achieve json from csv file.

But there are few problems like tab delimiter, \r etc.

Finish of this should be items on sharepoint list.

Im attaching my export file. 

Can someone help me out please?

Thank you very much

[grantjenkins]

In your Export.csv file there is only one row of data. Will there always just be a single row, or could be many?

And will the column names always be the same?

[RMVW]

Hello, column names will be always same. Yes there could be many rows.

[RMVW]

Hello Grantjenkins,

Did you find any solution how to do it?

Thank you a milion

[grantjenkins]

@RMVW Sorry for not getting back to you. Did you get this working, or still need help?

[RMVW]

Basically i decided to change source file. To add delimiter at the end of every row. That solved problem.

🙂