How to Import CSV Data to SharePoint List with Power Automate | Tutorial

Are you tired of manually importing data from CSV files into your SharePoint List? Look no further! In this comprehensive step-by-step tutorial video, I'll guide you through the seamless process of effortlessly importing your CSV data into your SharePoint List using the incredible power of Power Automate flows.

🚀 What You'll Learn:
📂 How to Import CSV data directly into your SharePoint List in a matter of minutes.
📥 Trigger instant cloud flows to quickly upload CSV files and get started.
🔄 Transform CSV data into strings, arrays, and parse through JSON effortlessly.
🧹 Efficiently filter data from your CSV files to import only what you need.
🌟 Supercharge your data import by handling empty values + tips on how to speed up the process.
➡️ Harness the full potential of expressions for maximum effectiveness.
📂 I'll take it a step further and show you how to import data from multiple CSV files in one go to SharePoint Lists, saving you time and effort.

Say goodbye to tedious manual data import tasks and automate your data import process with ease. Dive into the video now and unlock the potential of Power Automate for SharePoint List data import.

⬇️ Download the CSV Files, SharePoint list schema & Power Automate flows showcased in the video:
Exclusive for Channel Members (Silver 🥈 & Gold 🥇 Club)
Find the download link in the Community Tab for Members.

🔗 Add & Update Excel Data to SharePoint List using Power Automate | Excel Import using flow

#PowerAutomate #SharePoint #CSV #Excel #PowerPlatform

Table of Contents:
00:00 - Introduction to importing CSV file data into a SharePoint / Microsoft List with Power Automate flows
00:33 - Scenario: Import CSV to SharePoint List
01:06 - Import CSV data quickly into SharePoint List (out of the box feature)
05:35 - Use Power Automate to import CSV data to SharePoint List
09:55 - Filter data in CSV file with Power Automate
13:18 - Add Filter Array data JSON output (CSV) to SharePoint List - Import into text, number, choice, date columns
16:54 - Speed up the data import process in flows with apply to each loop pagination
17:27 - Import Person (Email) data from CSV to SharePoint list
17:59 - Import data to Multi Choice SharePoint Column
20:37 - Handle empty data scenarios in CSV file
24:02 - How to Import data rows from multiple CSV files to SharePoint list
25:28 - READY to subscribe to Reza Dorrani’s channel

🤝 Let’s connect on social:

This demo is awesome🤘! It shows me how to import CSV data into SharePoint List with Power Automate flows in a very clear and easy way. I love 😍 how the video explains every step of the process, from triggering the flow to filtering the data and using expressions. The tips on how to handle empty values and speed up the process are very helpful too. Error handling FTW. I also appreciate how the video covers importing multiple CSV files at once, which is something I always wanted to learn. This demo is very well structured and informative, thank you 🙏 for sharing it!

[Dustin.Stubbs]

Thanks this was very helpful. I was getting a \r that was messing things up for me.
I resolved by switching the Split Array Expression to skip(split(outputs('CSVData'), decodeUriComponent('%0D%0A')), 1) which removed the \r and \n This also allowed me to get rid of the "New Line" step.

[datadragyn]

Explained extremely well 👏 👌 There are so many gold nuggets of knowledge I'm going to map it out for myself. Remove empty strings, Remove header row, filter array to add only open, split, split, replace, so much goodness 😁

[elizabethtrent]

I truly appreciate the way you explain this, step by step, in a way that I can understand and troubleshoot my flow. This is incredibly helpful; I learned something today. You are an excellent teacher, Reza!

[mutantlabor]

This basic tutorial is one of the best learnings on Power Automate fundamentals I have watched. No better way to spend a hot Saturday night in July on the porch than watching Reza open my mind to new flow possibilities.

[arvindbhat]

What an amazing video! As always Reza picks up real practical scenarios. This one had so many e.g. within CSV import. Gives such clarity and sense of direction for people like me. Wish to keep learning more from you!! Best wishes!!!!

[anjanchidige]

Very common use case and very well demonstrated with exception handling. Take a bow Reza 🎉

[prabhurajaram]

i am so glad to be a subscriber of you, really it means a lot for me, whenever i struck somewhere on my work, firstly i refer your videos, and for sure i get clarity and complete my work. really love the way you create your videos with easy explanations and live runs. thank you so much for your efforts to share your knowledge to others.😍

[borien]

Thanks so much! This was clear, concise, and very helpful. I especially appreciate you structuring the exercise in such a way that we check and understand the output of each step. Thanks!

[ericzheng]

Always learn something new from Reza's video even if you have obtained the techniques from his previous videos!

[luizfurtado]

That is really great, I had a similar use case recently! Just a small piece of advice for the use of concurrency: I had a large batch of data to import (10K plus lines), but I need to implement some data transformation for a couple of fields from my csv. After a couple of tests, I realized that some SharePoint fields had the wrong value, and these are actually mixed values from other lines in my spreadsheet! When I ran the same tests without concurrency, all went well. I'm guessing (and this is a very wild guess) that the use of concurrency somehow makes Power Automate keep some values from the transformation action between transactions. So, I ended up by decoupling my flow into a child flow that receives some smaller batches of data to work with the data transformation and SharePoint insertion, and just returns to the main flow a list of items created with success or any errors that might occur with the insertion. So, my parent flow runs with concurrency, while the child flow runs without it. But here also I understand that, for this scenario, perhaps Power Automate is not a good fit, but it worked at the end of the day.

[calebstucki]

Really like your videos and appreciate your dedication to helping people. Keep up the good work and don't worry about the haters!

[MohammadAli-tsev]

❤ Many of my long standing issues got resolved ❤

Thank you Reza.

[priyankagorkhe]

Thank you so much. Your video saved me from a big storm actually. Thanks from big heart❤

[amiturmipurohit]

Very informative video Reza. Appreciate for all your hard work in making the videos which are very informative and explained in wonderful way.

[oluwatobipaul]

Thank you Reza. I had a similar project use case but users used Power Apps to upload their documents

[mohemmadriyazkalva]

Great content sir. Real time scenarios covered in very less time. Thanks for sharing. Keep giving us incredible content.

[pradeepv]

Great tutorial as usual. We recently had to deal with similar use case.

But the problem we faced is there were line breakers and comma's in the data itself and Power Automate considered the data/text after the line breaker as a new row and comma in single column was considered as multiple columns which completely changed the structure and we had to follow a different approach.

[rachelwu]

Thank you for this!! Your video is always so informative and concise. Once the CSV file is imported, is there a way to keep the file updated with any new updates? would it be the same as how you update excel files?

[Joker]

Hi Reza, needless to say, this is absolutely remarkable! Thank you very much - I literally watch as many videos from you as I can and I have to say, you honestly do an incredible job of explaining everything!
Btw, I have a (stupid) question, if you don't mind :)
What is the difference between Compose and Initialize/Set variable? Variables are always my pain points because I am just starting out with these tools...
Thank you again for the great work!