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

56,369
0
2023-09-04に共有
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.
To become a member, click here: youtube.com/rezadorrani/join

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

#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:
🔗 Reza Dorrani LinkedIn: www.linkedin.com/in/rezadorrani/
🐦 Reza Dorrani Twitter: twitter.com/rezadorrani

コメント (21)
  • 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!
  • 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.
  • 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!
  • @anjanchidige
    Very common use case and very well demonstrated with exception handling. Take a bow Reza 🎉
  • @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.
  • @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.😍
  • 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!!!!
  • @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!
  • Great content sir. Real time scenarios covered in very less time. Thanks for sharing. Keep giving us incredible content.
  • ❤ Many of my long standing issues got resolved ❤ Thank you Reza.
  • @atehaa
    Another great tutorial. Thanks mate :)
  • @calebstucki
    Really like your videos and appreciate your dedication to helping people. Keep up the good work and don't worry about the haters!
  • Very informative video Reza. Appreciate for all your hard work in making the videos which are very informative and explained in wonderful way.
  • Thank you so much. Your video saved me from a big storm actually. Thanks from big heart❤
  • @ericzheng4838
    Always learn something new from Reza's video even if you have obtained the techniques from his previous videos!
  • @c.mdsalih
    Awesome video as always, Thank you :)