Insert, Delete and Update on CSV file in Power Automate

In this video we will learn how to make changes to CSV content from Power Automate. We cover insert, delete and update from Power Automate on a csv file that is uploaded to SharePoint online.
To enroll in my Udemy courses see below link for discount vouchers
sslwsh008.securedata.net/dotn...
- 0:00 Introduction
- 1:17 Setup
- 5:55 How to insert a row into a CSV file
- 9:52 How to delete a row from a CSV file
- 14:20 How to update a row into a CSV file
- 19:27 Learn Power Automate expressions
Contact me
- LinkedIn / alirezaaliabadi
- Twitter / aaliabadi1
- Instagram / alireza.aliabadi_ig
- Facebook / alireza.aliabadi.fb

[@AlirezaAliabadi]

CSV is never considered as a proper data storage, but if you have a relatively small CSV and would like to do some basic data operations on it like insert, delete or update; this is how you can do it.

[@mast733]

Great video. Thanks Alireza

[@user-ef3hk9gc4y]

Finding your video has helped me greatly. Thank you!

[@franknielsen3219]

Very good video Alireza 👌👌

[@sundrapillay6668]

Thanks Alireza

[@amedeotalks]

Ghazanfar :)))) That was awesome :))

[@mohammadaamirkhan7830]

Anazing video!

[@michaelkerwath9902]

Hi Alireza - thanks for your helpfull videos.
I am looking for a way to replace the comma with a tab stop in a comma separated CSV file. Do you have an idea? I have to say that I'm not a professional - I'm currently creating my flows to simplify my life and it works quite well.

[@SachinJainJaipur]

Too good. Initially I was expecting that we will do CSV parsing without Euclidian :)

[@AlirezaAliabadi]

It's coming my friend and it is not going to be like anything you imagine. These days I am too busy to work on it. But it is on my to-do list :)

[@tomasmadrid]

I know this answer was written a long time ago. Did you manage to make the stream without Encodian though?

[@AaronPaul_google]

I have a create csv table step. However when I extract to csv the date format is weird. What can I do to select the column and convert it, apart from looping, as the file is large?

[@somayehsadeghi9576]

How we can delete content of a cell in excel in power automate for example for past dates?

[@AlirezaAliabadi]

Holly smoke. You read my mind. That was the topic for August 22 video that I am recording now 🤔
It is simple. Filter the JSON array and save the filter body to the CSV file.

[@ELGALLINERO92]

Really... the way to insert a new row is to put manually the data into a json step? rofl