How to Import a Large Excel Dataset into SharePoint Using Power Automate

Показать описание

In this video, I review the steps taken on how I imported 100,000 records of data in Excel to a SharePoint Online List and discuss the challenges to import large datasets into SharePoint Online.

Visit the link below to see the step-by-step breakdown:

Be sure to subscribe to get all the latest technology tips and to visit my website where you can find the documented version of my videos.

--------------------------------------------------------
CONNECT WITH ME:
___________________________________

Рекомендации по теме

Комментарии

This was EXACTLY what I needed. Easy-peasy low coding and very effective! Thanks so very much for sharing!😊

AVielot

Hi, thanks for the video. Why didn't use th import option from the List app directly? Is it because of the size? Thanks``

assiabouhadouza

Hi, great video! I have a query. How are you not getting the threshold error? As soon as I uploaded the Excel to list I am only able to view the data in online sharepoint and not the list desktop app. Also in the settings of list it is showing threshold issue. How do I fix that?

UmairKhan-gxmw

thanks, helpted a lot. Btw My runtime for 22000 records was 17 min, still aboslutly fine

nayanfrancis

Am I missing something? There's a 5, 000 row threshold limit on Pagination in Power Automate. How are you able to get it to save the Flow with 100, 000?

nikews

I get this error for a specific date field "Input parameter 'item/field_13' is required to be of type 'String/date-time'. The runtime value '"45482"' to be converted doesn't have the expected format 'String/date-time'." I've already formatted it as date in the excel table and it still doesn't work. The process works if I put the date fields as "single line of text" but if I try to convert that to date in the List afterward, then it shows blanks. Any idea of what could be happening?

And thank you for the video! I didn't know this was a possibility.

marjorieherrera

Brilliant video - are you doing more?

pravinshingadia

Inefficient. Use batch processing for sharepoint lists instead.

jakubholasek

How to Import a Large Excel Dataset into SharePoint Using Power Automate

How to Import Database using Terminal (Command Line) | Import Large Databases

Import Huge file (5M Records) into MySql in 2 minutes

How to import large SQL file (.sql) into phpmyadmin Database

How to Import very large MySQL database .sql file to phpmyadmin using wamp server

How to Import Large MySQL Database (.sql) file to phpmyadmin using WAMP server

How to import large csv into Power BI in few seconds (5 million rows)

How to Import mysql DB with XAMPP using command line - Very Large Database Import

Import Not Appearing in the Viewport Quick Fix in Blender

LangChain Lecture 1: Large Language Models, Prompt Templates, and Basic Chain Building

How to import a big dataset on mySQL workbench using terminal - macOS [Tutorial]

How to Export and Import a large SQL script into MySQL? | Export and import MySQL database script

Google Sheets Import Range | Multiple Sheets | Import Data | With Query Function

Speed Test: Laravel CSV Export/Import Large Files in 3 Ways

The fastest way to import CSV data into MySql database table via Command Line (LOAD DATA INFILE)

95 How to import a csv file into SQL Server using bulk insert SQL query

How to quickly bulk import data from Excel to a SharePoint List

How to import large files - Premiere Pro File Import Error 'Not Responding' FIX!

Easily Import Large iPhone Videos to Mac with Image Capture

Import More than 1 million rows data in Excel

06 How to import a csv file into MySql workbench

How to import data from Microsoft Excel into Microsoft SQL Server

14 How to import csv file in mysql using bulk insert query

Import Large SQL File Using MySQL Command Line

How to IMPORT Excel file (CSV) to MySQL Workbench.