cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RMVW
Regular Visitor

Power Automate csv to json

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

5 REPLIES 5
grantjenkins
Community Champion
Community Champion

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?



----------------------------------------------------------------------

If I've answered your question, please mark the post as Solved.

If you like my response, please consider giving it a Thumbs Up.

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

Hello Grantjenkins,

 

Did you find any solution how to do it?

 

Thank you a milion

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



----------------------------------------------------------------------

If I've answered your question, please mark the post as Solved.

If you like my response, please consider giving it a Thumbs Up.

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

🙂

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,205)