search within the country selection filter

(0) Share

Report

Posted on by AmitLoh-Powerap

608

I want to do keyword search on country selected by user in a dropdown.

SortByColumns(Search(Filter(PRCWithReimbursementV2,Country=Dropdown1.Selected.Country), TextInputsearch.Text, "Description","Company","ProductGroup"), "Description", Ascending)

With this keyword search works but its not limiting it based on country selected. Its searching within all even if I have filtered data source. Does anyone know how to achive search within filter?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

AmitLoh-Powerap 608 on at

Like (0)

Report
Copy link

Link copied!

I tried
Filter(PRCWithReimbursementV2,Country=Dropdown1.Selected.Country && TextInputsearch.Text in Description) but it exludes country when I type in textbox, If I change country it does good country search.

Was this reply helpful? Yes No
AmitLoh-Powerap 608 on at

Like (0)

Report
Copy link

Link copied!

does not work-
Search(Filter(PRCWithReimbursementV2,Country=Dropdown1.Selected.Country),TextInput2.Text,"ProductGroup")

Was this reply helpful? Yes No
AmitLoh-Powerap 608 on at

Like (0)

Report
Copy link

Link copied!

I have
Filter(PRCWithReimbursementV2,Country=Dropdown3.Selected.Country && TextInput1.Text in Description)
where I need country to be dropdown selected and then description column based on text typed but its ignoring country in gallery.
How to add multiple filter conditions? I can not use if because that kills 500+ item delegation.

Was this reply helpful? Yes No
AmitLoh-Powerap 608 on at

Like (0)

Report
Copy link

Link copied!

I was able to figure this out!!

Filter(PRCWithReimbursementV2,(Country = Dropdown3.Selected.Country && (ProductGroup=TextInput1.Text || Indication=TextInput1.Text || Description=TextInput1.Text)))

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

Like (0)

Report
Copy link

Link copied!

Hi @AmitLoh-Powerap,

Have you tried to search the results with a new collection created by the filter function?

I will try to make some tests from my side, and will post back if I have any helpful results.

Regards

Was this reply helpful? Yes No
Verified answer

AmitLoh-Powerap 608 on at

Like (2)

Report
Copy link

Link copied!

was able to fix it!!
Filter(PRCWithReimbursementV2,(Country = Dropdown3.Selected.Country && (ProductGroup=TextInput1.Text || Indication=TextInput1.Text || Description = TextInput1.Text || Company = TextInput1.Text)))

Was this reply helpful? Yes No