Powerapps Filter and Search Gallery

Like (0) Share

Report

Posted on 14 Jun 2024 05:51:08 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))

All responses (8)

Answers (1)

CU14010518-0 34 on 14 Jun 2024 at 07:01:14

Like (0)

Report

Re: Powerapps Filter and Search Gallery

Hi @v-xiaochen-msft

700+ as for now.
CU14010518-0 34 on 14 Jun 2024 at 06:59:46

Like (0)

Report

Re: Powerapps Filter and Search Gallery

Hi @WarrenBelz

This works for me!! Thank you!
v-xiaochen-msft on 14 Jun 2024 at 06:44:47

Like (0)

Report

Re: Powerapps Filter and Search Gallery

Hi @jshuang ,

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

Best Regards,

Wearsky
WarrenBelz 146,508 Most Valuable Professional on 14 Jun 2024 at 06:30:53

Like (0)

Report

Re: Powerapps Filter and Search Gallery

@jshuang ,

Dangers of free-typing code - please see amended post.
CU14010518-0 34 on 14 Jun 2024 at 06:25:49

Like (0)

Report

Re: Powerapps Filter and Search Gallery

Hi

Thanks for the reply.

however i hit this error
CU14010518-0 34 on 14 Jun 2024 at 06:23:40

Like (0)

Report

Re: Powerapps Filter and Search Gallery

Hi

Thanks for the reply.

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

without searching be like
Verified answer

WarrenBelz 146,508 Most Valuable Professional on 14 Jun 2024 at 05:56:35

Like (0)

Report
Re: Powerapps Filter and Search Gallery

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
v-xiaochen-msft on 14 Jun 2024 at 05:55:37

Like (0)

Report
Re: Powerapps Filter and Search Gallery

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