Power Apps import Excel to SharePoint list or any data source with Power Automate

In this video, you will learn how to use Power Apps to import an Excel file to your SharePoint List or other data source. This allows users to update SharePoint with their excel table data. This is done with the use of Power Automate flow actions that Create a file in SharePoint, then get tables, list rows present in table, and finally in an apply to each use Create item in SharePoint. Not terrible hard but has a few gotchas because of dates and because you want the files from XLSX to be dynamic.

How to upload files to SharePoint with Power Apps and Automate https://www.youtube.com/watch?v=3QaiM8SeWfM

0:00 power apps import Excel to SharePoint list or any data source
0:59 Demo of the Excel xlsx file import to SharePoint list with a Power Automate flow
2:18 A demo and explanation of the Power Automate flow
8:25 Create the flow, connect it to Power Apps, and Create file in SharePoint
9:48 Excel Online Business Get Tables
11:17 List Rows Present in a Table and the ISO 8601 date format
12:00 Create Item in SharePoint using the dynamic content we imported
14:03 Updating the flow to make the IDs dynamic
14:46 Using the First expression in Power Automate

http://www.cleverworkarounds.com/2021/02/21/how-to-clear-annoying-excel-file-locks-in-power-automate/

Power Apps Consulting and training at https://www.PowerApps911.com

#Powerapps #excel #powerautomate