Forum Discussion
Simple Client Request is Driving Me Insane
I suppose I could use a SP List, the 13,000 records seemed a little unwieldy but I suppose if Excel 2007 can handle it...
The one thing I was a little concerned with was staying away from getting into the weeds with permissions and data privacy. While no personal protected information is on the list, it would be an easier pitch if the data was somewhat shielded from the public internet. The records also should not be able to be edited.
The more that I think about it and read these responses, it is probably the best way to go.
SharePoint online is shielded from the Public internet. Only authorized user can access the data.
SP lists can handle way more than 13,000 records, especially with the new intelligent indexing that was recently added.
You may want to consider creating one or more Term Sets for some of the data so that there can be a master set of values that can be reused in many locations, the listing of clients names and TypeOfLaw would be ideal candidates for this.
Another option would be to use BCS to connect directly to the original system, there are several 3rd party tools that make this very easy.
Another option would be to use Flow with a Data Gateway to populate one or more SharePoint lists with data when the source system changes.
