Powerapps Filter and Search Gallery

(0) Share

Report

Posted on by CU14010518-0

Hi,

Would like to do a filtering with the condition below:

a) ListOwner.Value = CurrentUserListOwner

b) Status.Value = Dropdown1.Selected.Value

c) wildcard search in MvNo, if searchTextbox.Text is blank display all the items with condition (a) and (b)

By using the Filter function below, able to fulfill condition (a) and (b) mentioned above.

Gallery Items Properties: Filter(VehicleList, ListOwner.Value = CurrentUserListOwner && Status.Value = Dropdown1.Selected.Value)

Would like to do the filtering with all the 3 conditions above (wildcard search in MvNo, if searchTextbox.Text is blank display all the items with condition (a) and (b))

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @jshuang ,

Please try this

If(IsBlank(searchTextbox.Text), Filter(VehicleList, ListOwner.Value = CurrentUserListOwner && Status.Value = Dropdown1.Selected.Value), Filter(VehicleList, ListOwner.Value = CurrentUserListOwner && Status.Value = Dropdown1.Selected.Value&& searchTextbox.Text in MvNo) )

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @jshuang ,

Try this - the structure is to give you some degree of Delegation

With( { _Data: Filter( VehicleList, ListOwner.Value = CurrentUserListOwner && Status.Value = Dropdown1.Selected.Value ) }, Search( _Data, SearchTextbox.Text, MVNo ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CU14010518-0 34 on at

Like (0)

Report
Copy link

Link copied!

Hi

Thanks for the reply.

However, when i tried to search the MvNo it not showing the item

without searching be like

Was this reply helpful? Yes No
CU14010518-0 34 on at

Like (0)

Report
Copy link

Link copied!

Hi

Thanks for the reply.

however i hit this error

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

Like (0)

Report
Copy link

Link copied!

@jshuang ,

Dangers of free-typing code - please see amended post.

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

Like (0)

Report
Copy link

Link copied!

Hi @jshuang ,

May I ask how many items do you have in this list?

Best Regards,

Wearsky

Was this reply helpful? Yes No
CU14010518-0 34 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

This works for me!! Thank you!

Was this reply helpful? Yes No
CU14010518-0 34 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft

700+ as for now.

Was this reply helpful? Yes No