Searching a filtered gallery

(0) Share

Report

Posted on by da1ve

340

Hi guys,

I am wanting to add search capability to my gallery. My gallery displays the folders and files of a document library. I am wanting to filter based on the "Owner" field.

The gallery items property is set to:

SortByColumns(
 Filter(
 'Processes',
 'Folder path' = varFolderPathCurrent
 ),
 "{IsFolder}",
 Descending,
 "{Name}",
 Ascending
)

I have tried adding the search context in the gallery items and also in a text input (TextInput16.Text), something like this:

Search(Filter('Processes', 'Folder path' = varFolderPathCurrent), TextInput16.Text, "Owner")

Not sure where I am going wrong, hopefully super simple

Thanks,
David

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

WarrenBelz 154,951 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @da1ve ,

Search and Filter do not always work well together and also neither 'Folder Path' nor Search (nor the code below) is Delegable

Filter( 'Processes', 'Folder path' = varFolderPathCurrent && TextInput16.Text in Owner )

Please click Accept as solution 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 Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report
Copy link

Link copied!
Hi @WarrenBelz ,

Thanks for your reply. I had similar results earlier and with your code it no longer displays the folders (just files). With your code as well as the below it drops off the folders (but search works).

SortByColumns( Filter( 'Processes', 'Folder path' = varFolderPathCurrent && TextInput16.Text in Owner ), "{IsFolder}", Descending, "{Name}", Ascending )

Is it possible to have search while preserving the folder view?

There will never be thousands of records so delegation shouldn't be an issue

Thanks,
David

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,951 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
HI @da1ve ,

I will tell you how I have always dealt with Libraries due to the lack of Delegation (and subsequent issues with filters) and see if that suits you. I keep all relevant values in Text fields (including the name, folders and anything else relevant). I have Flows that take care of this when the file is created and also a SharePoint Integrated form to change anything. I have libraries over 100k records and have no issues with Delegation on any filters as a result. You could try to separate it a bit

With( { wFiles: Filter( 'Processes', 'Folder path' = varFolderPathCurrent && TextInput16.Text in Owner ) }, SortByColumns( wFiles, "{IsFolder}", Descending, "{Name}", Ascending ) )

Please click Accept as solution 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 Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz ,

Not working in my case - doesn't display anything

Also worth mentioning I run an OnStart: Set(varFolderPathCurrent, "Processes/")

Was this reply helpful? Yes No
WarrenBelz 154,951 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@da1ve ,

I assume you picked up the extra bracket (not required) - now fixed.

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report
Copy link

Link copied!

I did thanks - still just shows files and no folders

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz

One other thing to mention, my folder\file label ahs a text property set to: ThisItem.'File name with extension'
Not sure if that makes any sense why folders don't show?

Was this reply helpful? Yes No
WarrenBelz 154,951 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@da1ve ,

Yes - a Folder does not have a 'File name with extension', just a name.

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report
Copy link

Link copied!
@WarrenBelz

So if I remove the
&& TextInput16.Text in Owner
It ends up like this:
With( { wFiles: Filter( 'Processes', 'Folder path' = varFolderPathCurrent ) }, SortByColumns( wFiles, "{IsFolder}", Descending, "{Name}", Ascending ) )
Then the folders and files show (even when the text label is "Name" or "File name with extension")

So adding the && TextInput bit is messing with the folder view.

Was this reply helpful? Yes No
WarrenBelz 154,951 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@da1ve ,

One of the reasons I use all Metadata fields in Libraries (apart from Delegation issues) is just this - inconsistant results the more complex a filter gets. As logic would tell you, if the separate bits work, then it should work together (but it obviously does not). Have you considered what I posted ?

Was this reply helpful? Yes No