cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mikello-6626
Helper III
Helper III

How to Show items from all doc lib using filter

How to Show items from all doc lib using filter

 

1 ACCEPTED SOLUTION

Accepted Solutions
Spamrancher
Resolver I
Resolver I

Create separate connections to the SharePoint libraries. I created two libraries and put one document in each. ClearCollect for the first library, then Collect the rest of the libraries. Change your filter so that Review = true. Set the data source for the gallery to be your collection. Magic!

 

Spamrancher_1-1638490128385.png

 

 

 

 

View solution in original post

18 REPLIES 18
Mikello-6626
Helper III
Helper III

Any replies appreciated

Spamrancher
Resolver I
Resolver I

Create separate connections to the SharePoint libraries. I created two libraries and put one document in each. ClearCollect for the first library, then Collect the rest of the libraries. Change your filter so that Review = true. Set the data source for the gallery to be your collection. Magic!

 

Spamrancher_1-1638490128385.png

 

 

 

 

Mikello-6626
Helper III
Helper III

@Spamrancher would it be a link to the documents?

Spamrancher
Resolver I
Resolver I

I suppose it would depend on what you put in the gallery. If you're trying to display the actual file in your gallery it might not perform well -- that's a lot of data to pull down. In my example I just used 'file name with extension', but you could add a button to the gallery with text like "Open File", and set the OnSelect action to Launch(ThisItem.'{Link}').

 

Edit: Or, even better, put an image control in the gallery with its Image property set to ThisItem.'{Thumbnail}'.Small. Then set the OnSelect on the image to Launch(ThisItem.'{Link}').

 

Spamrancher_0-1638491885237.png

 

AmDev
Super User
Super User

Hi @Mikello-6626  - Given that you plan to combine all 4nr libraries into one Gallery in the app, is there a reason why you cannot just use one combined Doc Library from the start and as you say then use delegable filter queries - Your app will then be much simpler and it wont matter how many docs are in your library (provided that your library columns are indexed etc)

 

Another option is to create a tabbed experience in your app i.e. 1 tab per gallery, which  could be a good UI, if the docs are by default categories from their respective sources.

 

@Spamrancher  has made a good suggestion on the use of collections - if you are just viewing the data and not editing, this would work very well. I would just caution that there can be complications with layering up multiple collections due to differing Column names, but that can be overcome. 

 

Unfortunately there is no perfect solution for this, but there are certainly a few good options. Good Luck! ☘

 

 

Would docs be security trimmed

@Mikello-6626   If a user doesn't have access to a library, that permission will persist through to the app. So it should still be OK.

 

Would dare I say it folders with different permissions in one library be an option? That way you would just hook the doc lib up to the app and users will only see what they are allowed to and you're not trying to combine anything

Yeah I thought of that but granular permission maintenance could become an issue going forward. Also the total number of documents in one library could exceed 5k and I wouldn’t want to add that complication. So was hoping the Powerapp could be a nice independent display solution so we could have best of both worlds. 

I am looking for documents to display as links so users can click on it and it would open to edit in browser. 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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