question

KobaThomas-5087 avatar image
0 Votes"
KobaThomas-5087 asked DSPatrick answered

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

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!

not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
1 Vote"
DSPatrick answered

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--


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.