Table of Contents Introduction CSV vs Tab-Delimited: Which to Use? Step-by-Step Flow Setup 1. Trigger: File Upload 2. Settings (Parse JSON) 3. Get File Content 4. Parse CSV or Tab-Delimited Data 5. Generate SharePoint Data 6. Batch Processing and Create Items Full Flow Diagram References Introduction Importing large amounts of data from CSV or tab-delimited files to a SharePoint list is a common business need. This guide explains how to build a Power Automate flow for bulk import, highlights key challenges, and provides practical tips for reliable results.

Table of Contents Introduction Why Tab-Delimited Files? Step-by-Step Guide 1. Prepare Your Data 2. Import from Excel Table (Alternative) 3. Build the Flow for Tab-Delimited Files Batch Processing with HTTP Request (Alternative) Tips & Troubleshooting Outcome Comparison Conclusion References Introduction Importing large datasets into SharePoint lists can be tricky, especially when dealing with CSV or tab-delimited files. This guide walks you through a reliable Power Automate approach, highlights common pitfalls, and shares practical tips for handling big data without premium connectors.

If it takes too long to deploy the solution, time out issues might occur. In this instance consider checking and updating the MaxAsyncWaitTime. Its value has been increased to 120 which means the deployment process will wait up to 120 seconds (or 2 minutes) for asynchronous operations such as import power platform solution to complete fixing the timing out issue. The fix is to amend the MaxAsyncWaitTime to 120 - task: PowerPlatformImportSolution@2 inputs: authenticationType: PowerPlatformSPN PowerPlatformSPN: 'powerplatform-t-connection' Environment: 'https://contoso-st.