Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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?

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

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

  3. Any other ideas?


Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,347)