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

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.

In this video

• power apps import Excel to SharePoint list or any data source
• Demo of the Excel xlsx file import to SharePoint list with a Power Automate flow
• A demo and explanation of the Power Automate flow
• Create the flow, connect it to Power Apps, and Create file in SharePoint
• Excel Online Business Get Tables
• List Rows Present in a Table and the ISO 8601 date format
• Create Item in SharePoint using the dynamic content we imported
• Updating the flow to make the IDs dynamic
• Using the First expression in Power Automate