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