Ideas for scalability - multiple document libraries
I have built and launched a canvas app which brings into a single app, some documents from multiple (currently 14) document libraries. Each library has between 2 and 380 documents, only a subset of these (currently max 380, average 100, in a single library totalling around 1000) are filtered into the app by a field in each document library. All document libraries are set up identically. The app brings documents to be viewed in the PDF viewer. A few drop downs help the user find the right document set, then a gallery helps the user find the right document for their use. The user can launch the document in browser or download. Some documents are within a zip, and I take advantage of the new image column to present a thumbnail (manually generated) of what the zip contains so that people don't have to download to see what's in it, there is also a text description of what's in the zip. The addition of new templates is rare: once every two weeks or so.
The app was set up with 4 document libraries, but the app now needs to be scalable with some users experiencing delegation issues.
Current solution: Connect directly to the document libraries within the app. Need to republish to connect a new library.
Potential solutions: any ideas?
Use Power Automate to dynamically loop through a list of sites and libraries, for each library get the filtered list of items, copy each item's metadata to a SharePoint list add a column to. Use the metadata within the app to access the document views etc. Add a column with a randomly generated letter, import the documents to a single collection based on the letter, reducing delegation issues.
Use Power Automate, generate a CSV list of all documents and bring in the blob and extract it out to create a collection of all item's metadata and use that.