Answered

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

(0) Share

Report

Posted on by Suridup

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Suridup on at

Like (0)

Report

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.

PDF page with flo...

Sharepoint site.PNG

Gallery view.PNG

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suridup on at

Like (0)

Report

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.

Gallery new.PNG

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suridup on at

Like (0)

Report

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!

Was this reply helpful? Yes No