This video is a stepbystep tutorial on how to add and update your SharePoint list items from Excel Table data using Power Automate flows.
We will create a template Excel file, where data to be imported to SharePoint will be loaded. The Template file will be made available for download from SharePoint Library (or OneDrive). Excel files with data rows will be uploaded to a SharePoint drop off library where Power Automate flow will be listening to start adding or updating the data from the Excel file (Table with rows) to SharePoint List.
Flow will track the status of the Excel file, Log updates & perform error handling, add & update SharePoint list data for most column types Text, Date, Date & Time, Choice, Lookup, Person, Multi select choice, multi select person columns & more.
We will also look at getting lookup column ID from secondary SharePoint List.
Flow will check if row in Excel has an existing item in SharePoint. If yes, then flow will update SharePoint item from Excel row data else flow will create a New Item in SharePoint List.
This Power Apps Video covers the following:
✅ SharePoint List
✅ Excel Template from SharePoint List
✅ Add Excel data to SharePoint List using Power Automate
✅ Update Excel data to SharePoint List using Power Automate
✅ Add data validation & null checks in Excel & flow
✅ Date and time conversions
✅ Excel file import status logging & more.
✅ Performance & Limitations for large excel files with large number of rows, 256 row limits, pagination, 6 minutes delay for locked file status & more.
Download ⬇ Sample flows
https://github.com/rdorrani/Microsoft...
List rows present in a table (Excel Connector)
https://docs.microsoft.com/enus/conn...
SharePoint connector
https://docs.microsoft.com/enus/conn...
Power Automate flow Expressions Tutorial
• Power Automate flow Expressions Tutorial
Table of Contents:
0:00 Introduction to Add & Update Excel Table data to SharePoint using flow
0:47 SharePoint List Scenario
2:08 Import Excel data to SharePoint
2:41 Create the Excel template file to Import to SharePoint
7:19 Excel Data Validations
8:35 Create Power Automate flow to add Excel Table rows to SharePoint List
24:33 Add Null Checks in Flow
26:41 SharePoint Date & Time Columns Time Zone Conversions
29:25 Limitations & Performance for large data in Excel
32:27 Update Excel File Status (file locked scenario when List Rows present in a Table action is called in flow)
35:51 Add logic in flow to update SharePoint List data from excel file.
40:04 Log results of Excel file import to SharePoint using Power Automate
41:42 Subscribe to Reza Dorrani channel
#PowerAutomate #Excel #SharePoint #ExcelImport #SharePointList #Flow #MicrosoftFlow
Let’s connect on social:
LinkedIn: / rezadorrani
Twitter: / rezadorrani