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 (let me know if you have solutions to this as well) 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!