We are working on building a document management for our customer using SharePoint online. the documents will have those 3 categories (metadata)
Client. ClientA, ClientB, ClientC, etc.
Type. General, Know-How, Procedures, Rules, etc.
Department. HR, IT, Finance, etc.
Now we are thinking of doing the following:-
When a new client join the company >> to create the folder structure.
Then users will be uploading documents to the root folder >> tag them by defining the 3 metadata >> then we will have a power automate flow which will move the document to the related folder based on the metadata applied. we will have this folder structure:-
Client Name (Main Folder) >> Type (first level Sub-Folder) >> Department (Second level Sub-folder)
now I have the following three questions:-
is it a bad practice or it is a good practice to define metadata for the documents + arrange them inside folders? or this is considered redundant ? as based on folder location you can know the metadata?
what determine if we should create separate libraries for each client? or store all the documents for all the clients inside the same library ?
what should determine how many libraries we should have? the number of permission sets? or the number of clients? or both?
Thanks