Text in columns with powerautomate

[Geometry]

Hello

I need to know how can I turn text in columns from a csv file using powerautomate.

Thanks

[Rhiassuring · Accepted solution]

Hi there,

You can use a split() on the delimiter (comma), and then build an array to format it in the way you want to put it into your SharePoint list. 

For example .. split(CSV,',')

Then, I'm lazy, so I'd run the flow - copy the JSON - then use a Parse JSON action.

Then, you can create a "Create Item" SharePoint action, and use the outputs from the Parse JSON - it'll turn into an apply to each, which is perfect for your needs.

[Geometry]

thank you for you help, I tried it and it was great