Answered

Adding Search Box with Dropdown Filters

(0) Share

Report

Posted on by TONYSTORM

Need help adding a dropdown to the below code. Keeps showing errors. Thanks so much.

If(IsBlank(Dropdown1_2.Selected.Result),If(IsBlank(Dropdown1.SelectedText),Sort(‘DATA SOURCE’,NAME),Filter(‘DATA SOURCE’,’START DATE'=Dropdown1.Selected.Result)),Filter(If(IsBlank(Dropdown1.SelectedText),Sort(‘DATA SOURCE’,NAME),Filter(‘DATA SOURCE’,’START DATE'=Dropdown1.Selected.Result)),Dropdown1_2.Selected.Result=LOCATION))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

TONYSTORM 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry need help adding a Search box to the code

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TONYSTORM ,

Try below codes, just add search at the beginning and follow the syntax in the end:

Search( If( IsBlank(Dropdown1_2.Selected.Result), If( IsBlank(Dropdown1.SelectedText), Sort(‘DATA SOURCE’,NAME), Filter(‘DATA SOURCE’,’START DATE'=Dropdown1.Selected.Result) ), Filter( If( IsBlank(Dropdown1.SelectedText), Sort(‘DATA SOURCE’,NAME), Filter(‘DATA SOURCE’,’START DATE'=Dropdown1.Selected.Result) ),Dropdown1_2.Selected.Result=LOCATION ) ), SearchBox.Text, SearchColumnName )

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TONYSTORM ,

Have you resolved the issue?

If above post helps, then please consider Accept it as the solution to help the other members find it.

Best regards,
Community Support Team _ Jeffer Ni

Was this reply helpful? Yes No
TONYSTORM 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Working great! Thanks so much 🙂

Was this reply helpful? Yes No