Answered

Filter Gallery to Show Files (ONLY) from SharePoint Library

(1) Share

Report

Posted on by Phineas

5,331 Moderator

The Images gallery Items has - Filter(col_Document_Library, !IsFolder). This works

to eliminate folder names.

I've added a Dropdown.

I would like the Documents gallery to be filtered to return only the documents (no Folders) located in the folder
that matches the choice made in the Dropdown.

The following formula returns no content.

What am I missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

I figured it out.

I updated the gallery formula to the following -

Gallery Items -

Filter(

col_Document_Library,

!IsFolder && Dropdown3.Selected.Value in 'File name with extension'

)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,352 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@Phineas,

If you have the full file name in the drop-down, you need.
Filter( col_Document_Library, 'File name with extension' = Dropdown3.Selected.Value )

but why are you bothering with !IsFolder if you have the file name ? I also assume that this is a Collection and that the file is in it (If it is the actual Library, you also have Delegation issues)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No