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

Hi Everyone,

This video is a step-by-step 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.

This 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

Thanks,
Reza Dorrani, MVP
YouTube
Twitter