How to delete all contents of a SharePoint list and insert all contents from a Excel Business Workbook?

Question

I have a Excel Business sheet that gets updated once a week and I am using a copy of it as a SharePoint list to populate a PowerApp. For some reason the PowerApp will not accept the Excel Business sheet so I'm needing to automatically update this SharePoint list once a week to include all of the new entries and delete all of the deleted entries.

I thought the most obvious workaround for this would be to delete the entire sheet and then replace it all, although maybe that's not the best option. I have no experience with PowerAutomate so any help is much appreciated!

Answer 1

Power apps is not currently supported here on Q&A. The product group for Power apps actively monitors questions over at
https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

--please don't forget to upvote and Accept as answer if the reply is helpful--