Unanswered

Search/Filter gallery with a dropdown

(0) Share

Report

Posted on by TomasZF

Hello community,

I'm trying to build an app that would help us find a right contact from Sharepoint list (all columns are a "single line of text" type)

Users could use SearchBox and/or dropdown

Searchbox with current formula works perfectly:

Filter(CVSContactFinderSP,StartsWith(ProcessNameEN,SearchBox.Text))

Although I'm not able to write/find out what would be the right formula for the Dropdown1_1 to filter gallery based on column AccountableOrganization from SP list

I would really appreciate your help here.
Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Filter([SPList], ( isBlank(Dropdown1_1.Selected.Value) Or [Column_Name] = Dropdown1_1.Selected.Value)
And StartsWith(ProcessNameEN,SearchBox.Text))

Please refer my comment as an accepted solution if it solve your problem!
Regards.

Was this reply helpful? Yes No
TomasZF 24 on at

Like (0)

Report
Copy link

Link copied!

Hi, I'm not sure if I'm writing this correctly because now it does not retrieve any values

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

put the whole function
Filter([SPList], ( isBlank(Dropdown1_1.Selected.Value) Or [Column_Name] = Dropdown1_1.Selected.Value)
And StartsWith(ProcessNameEN,SearchBox.Text))

Was this reply helpful? Yes No
TomasZF 24 on at

Like (0)

Report
Copy link

Link copied!

Is this correct?

Filter(CVSContactFinder, ( isBlank(Dropdown1_1.Selected.Value) Or AccountableOrganization = Dropdown1_1.Selected.Value)
And StartsWith(ProcessNameEN,SearchBox.Text))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

There is 1 additional bracket on the end ")"
when you remove the bracket if there still an error please send me the error
regards.

Was this reply helpful? Yes No
TomasZF 24 on at

Like (0)

Report
Copy link

Link copied!

I've removed the bracket at the end:

Filter(CVSContactFinder, ( isBlank(Dropdown1_1.Selected.Value) Or AccountableOrganization = Dropdown1_1.Selected.Value)
And StartsWith(ProcessNameEN,SearchBox.Text)

Thanks for your help

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sorry my bad! Please re-put the bracket and send me the error you see when you put the function

Was this reply helpful? Yes No
TomasZF 24 on at

Like (0)

Report
Copy link

Link copied!

No worries, please see the two errors below:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

as you can see, Fix the "isBlank" to "IsBlank"
and hover on your function with your mouse slowly to see if there is other errors

Was this reply helpful? Yes No
TomasZF 24 on at

Like (0)

Report
Copy link

Link copied!

IsBlank is fixed now.
When I hover over Dropdown1_1
When I hover over AccountableOrganization

When hovered over process name
and SearchBox

Was this reply helpful? Yes No