How to Export a Large Filtered SharePoint List into a CSV File Using Power Automate
In the previous post I imported 100,000 rows of data from Excel into a SharePoint List using Power Automate. In this post, I will export a large amount of filtered data out of the same SharePoint List and into a CSV file using Power Automate. Within Power Automate, I’m just using a manual trigger and […]
How to Import a Large Excel Dataset into SharePoint Using Power Automate
In this blog post, I discuss how to import 100,000 rows and 56 columns (5.6m data points) into a SharePoint List (Microsoft Lists) from a Microsoft Excel csv file using Power Automate. I downloaded a 1.8 GB csv dataset from Kaggle with 495,000 rows and 89 columns and transformed the data into two 50 MB […]