cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Selecting only certain files within sharepoint to display in a powerapps gallery

I am busy creating an app that can view PDF's within sharepoint and displaying the PDF's in a gallery in Powerapps.  All the files are on 1 document library.  I created a flow that I can display to PDF's within the PowerApp.  This is working fine, but I want to only select certain files, not the entire document library.  I created a column in sharepoint and assigned the different categories to each file within the library.  I only want to select the files within a certain category to display in the gallery.  How do I only select files based on the category and not the entire library?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: Selecting only certain files within sharepoint to display in a powerapps gallery

Hi @Suridup 

 

Can you please confirm the "Text" property of the Label inside gallery as:

ThisItem.'File name with extension'

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

6 REPLIES 6
Highlighted
Super User II
Super User II

Re: Selecting only certain files within sharepoint to display in a powerapps gallery

Can you post your current Items property of the gallery of files? And also the name of the column that has the category? 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

Highlighted
Frequent Visitor

Re: Selecting only certain files within sharepoint to display in a powerapps gallery

 Hi, Thanks for your response.  I have attached screenshots with the relevant info.  Within Sharepoint, I created a text column called "Product" where I assigned each line with the relevant product name.  Please see screenshots.

Highlighted
Dual Super User III
Dual Super User III

Re: Selecting only certain files within sharepoint to display in a powerapps gallery

Hey @Suridup 

 

Can you try to update the Items property of the gallery control as:

Filter(Documents, Product = "PowerApps")

This will only fetch the items where Product is equal to "PowerApps".

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Frequent Visitor

Re: Selecting only certain files within sharepoint to display in a powerapps gallery

Hi!

Thanks for the reply!. I did this and it seems to only select the "PowerApps" documents.  Great! (as it only shows 3 documents), but the name of the document is now missing. please see screenshot.

Highlighted
Dual Super User III
Dual Super User III

Re: Selecting only certain files within sharepoint to display in a powerapps gallery

Hi @Suridup 

 

Can you please confirm the "Text" property of the Label inside gallery as:

ThisItem.'File name with extension'

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Highlighted
Frequent Visitor

Re: Selecting only certain files within sharepoint to display in a powerapps gallery

Thanks a lot!  This did the trick, except, I added ThisItem.'Name' as I only needed the name, not file name with extention.  Thanks a lot for your help!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,048)