Forum Discussion
Splitting a sharepoint list used as database
Hi, I recently became the owner of a Powerapps application to code calls for our call center. Though I understand data, know some very basic coding and know my way around excel, I am still relati...
Hi Riverain96,
Splitting the list by year is a good approach.
I would create additional Views that filter based on year and export those rows to Excel. From Excel, I would export to a new SharePoint List. Removing the archived rows is time-consuming and I would suggest looking into Powershell to do it, specifically Remove-Pn
I would not change the default view that is referenced by the PowerApp. Also, consider a yearly archive and purge to keep performance high (in its current state anyway).
I hope this helps.
Norm
- Thanks for the reply!
I will look into powershell to see if I can make it work that way, though it seems more and more that a sharepoint list just isnt the proper way to store our data.
Also - I looked into creating a flow to archive part of the list into a new list but the 5000 line limit seems to make it impossible.
Thanks again for the help!Riverain96 views that filter based on year should overcome the 5,000 limits.
