Answered

filter gallery search bar and user

(0) Share

Report

Posted on by Matt383

407

I have a gallery with the datasouce linked to sharepoint list and currently have the gallery filtered (see below, i have this under Items) I am trying to add search bar that a user can type into to filter by customer. So i have added a text input (SrchBox), then trying to add;
Search(KBXoffline, SrchBox.Text,"Customer") in the items off the gallery. Because i already have the syntax below, it wont allow me to to ; and paste it in. Do i need to combine these two syntax?

FirstN(Sort(If(User().Email in varAdminEmail, KBXoffline, Filter(KBXoffline, 'Created By'.Email = User().Email)), Created, Descending), 50)

Any assistance would be much appreciated,

KR's,

Matt383

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

WarrenBelz 154,593 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Matt383 ,

Try this

FirstN( Sort( Filter( KBXoffline, If( User().Email in varAdminEmail, true, 'Created By'.Email = User().Email ) && SrchBox.Text in Customer ), Created, Descending ), 50 )

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.

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren, thanks for feedback. Although no luck
Delegation warning. The Sort part
The function sort has some invalid arguments
Cannot sort on the expression type
Invalid number of arguments

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

Like (0)

Report
Copy link

Link copied!

Hi @Matt383 ,

Please see updated post - dangers of free-typing. NOTE; the in Filter (and Search) are not Delegable, neither is User().Email (although there is a workaround for this). How many records are in your list ?

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.

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren, i have aprox 20 fields i am capturing in the sharepoint list but only need to filter 1-2 fields in the gallery

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

Like (0)

Report
Copy link

Link copied!

Hi @Matt383 ,

I meant the number of records in your list (not fields)

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Currently around 40-50 and increasing

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

Like (0)

Report
Copy link

Link copied!
OK @Matt383 ,

This should find up to 500 without Delegation Warnings (and you can increase this to 2,000 in Advanced Settings)

With( {wKBX:KBXOffline}, FirstN( Sort( Filter( wKBX, If( User().Email in varAdminEmail, true, 'Created By'.Email = User().Email ) && SrchBox.Text in Customer ), Created, Descending ), 50 ) )

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.

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren, still no luck. Do I replace the wKBX with the field i am searching for?
The function sort, with, filter has invalid arguments

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,593 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Matt383 ,

Typing gremlins again - should be colon : in the With() statement - corrected in original post

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

Like (0)

Report
Copy link

Link copied!

Hi @Matt383 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No