cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mansoor88
Level: Powered On

help, want to update gallery based with criteria, with checkbox

Hi Everyone, hope you're PowerAppsing well 👍

 

I may need your advise please: I would like to filter the gallery with checkbox,but it doesn't work.

 

 

onCheck: Filter('TI Tools Library'; Titre= "Proposal") >>> Filter('source:TI Tools Library'; Criteria (column name Titre= and criteria Pro

 

Thanks a lot

3 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft v-siky-msft
Microsoft

Re: help, want to update gallery based with criteria, with checkbox

Hi @Mansoor88,

 

We should define the corresponding properties in the formula bar of the respective properties.

That means the filter formula should be put in Items property of gallery.

If we want to use check box to control the filter, the Items of Gallery should be:

 

If(Checkbox1.Value; Filter('TI Tools Library'; Titre= "Proposal"); 'TI Tools Library')

 

Best regards,

Sik

View solution in original post

Microsoft v-siky-msft
Microsoft

Re: help, want to update gallery based with criteria, with checkbox

Hi @Mansoor88 ,

 

Try this:

 

If(

CheckboxEngineering.Value; Search( Filter('TI Tools Library';Titre="Engineering"); ToolSearchBox.Text; "Tool") ;

CheckboxDBOffice.Value;  Search(Filter('TI Tools Library';Titre="DB Office"); ToolSearchBox.Text; "Tool") ;
CheckboxConstructCommiss.Value; Search( Filter('TI Tools Library';Titre="Construction & Commissioning"); ToolSearchBox.Text; "Tool") ;
CheckboxFinancePerformance.Value;  Search(Filter('TI Tools Library';Titre="Finance & Performance"); ToolSearchBox.Text; "Tool") ;
CheckboxMarketing.Value;  Search(Filter('TI Tools Library';Titre="Marketing"); ToolSearchBox.Text; "Tool") ;
CheckboxProposal.Value;  Search(Filter('TI Tools Library';Titre="Proposal"); ToolSearchBox.Text; "Tool") ;
CheckboxDTI.Value;  Search(Filter('TI Tools Library';Titre="DTI"); ToolSearchBox.Text; "Tool") ;
CheckboxSCPM.Value; Search( Filter('TI Tools Library';Titre="SCPM"); ToolSearchBox.Text; "Tool") ;

Search('TI Tools Library'; ToolSearchBox.Text; "Tool")

)

Best regards.

Sik

View solution in original post

Microsoft v-siky-msft
Microsoft

Re: help, want to update gallery based with criteria, with checkbox

Hi @Mansoor88 ,

 

If my post help you resolve your issue, please click  "Accept as Solution"  to help other members to find more quickly.

Best regards,

Sik

View solution in original post

7 REPLIES 7
Mansoor88
Level: Powered On

Re: help, want to update gallery based with criteria, with checkbox

with the picture

Microsoft v-siky-msft
Microsoft

Re: help, want to update gallery based with criteria, with checkbox

Hi @Mansoor88,

 

We should define the corresponding properties in the formula bar of the respective properties.

That means the filter formula should be put in Items property of gallery.

If we want to use check box to control the filter, the Items of Gallery should be:

 

If(Checkbox1.Value; Filter('TI Tools Library'; Titre= "Proposal"); 'TI Tools Library')

 

Best regards,

Sik

View solution in original post

Mansoor88
Level: Powered On

Re: help, want to update gallery based with criteria, with checkbox

Hi, 

 

Thanks a lot, it is working perfectly,

 

however, I have another doubt and issue,.

 

In the same example, I have plenty Checkbox, with plenty Criteria "Proposal" , "Engineering" , "Supply Chain" etc, 

How to include them all?

 

Second question, is it possible to do Filter function with Checkbox, and also Search function by Tool name, in the same gallery.

 

- If(Checkbox1.Value; Filter('TI Tools Library'; Titre= "Proposal"); 'TI Tools Library')

- Search('TI Tools Library';ToolSearchBox.Text;"Tool")

 

Please advise.

 

Mansoor88
Level: Powered On

Re: help, want to update gallery based with criteria, with checkbox

Hello,

 

 

In the attached File, I have a gallery with Checkbox and searchbox

 

In the property Items of the gallery :

 

I put:

If(CheckboxEngineering.Value;Filter('TI Tools Library';Titre="Engineering");
If(CheckboxDBOffice.Value;Filter('TI Tools Library';Titre="DB Office");
If(CheckboxConstructCommiss.Value;Filter('TI Tools Library';Titre="Construction & Commissioning");
If(CheckboxFinancePerformance.Value;Filter('TI Tools Library';Titre="Finance & Performance");
If(CheckboxMarketing.Value;Filter('TI Tools Library';Titre="Marketing");
If(CheckboxProposal.Value;Filter('TI Tools Library';Titre="Proposal");
If(CheckboxDTI.Value;Filter('TI Tools Library';Titre="DTI");
If(CheckboxSCPM.Value;Filter('TI Tools Library';Titre="SCPM");'TI Tools Library'
))))))))

 

BUT also, i would like to add the formula for the serachbox in the Items of the same gallery, but it doesn't work.

 

   Search('TI Tools Library'; ToolSearchBox.Text; "Tool")

 

Please advise.

 

Thanks in advance,

Best regards.

Microsoft v-siky-msft
Microsoft

Re: help, want to update gallery based with criteria, with checkbox

Hi @Mansoor88 ,

 

Try this:

 

If(

CheckboxEngineering.Value; Search( Filter('TI Tools Library';Titre="Engineering"); ToolSearchBox.Text; "Tool") ;

CheckboxDBOffice.Value;  Search(Filter('TI Tools Library';Titre="DB Office"); ToolSearchBox.Text; "Tool") ;
CheckboxConstructCommiss.Value; Search( Filter('TI Tools Library';Titre="Construction & Commissioning"); ToolSearchBox.Text; "Tool") ;
CheckboxFinancePerformance.Value;  Search(Filter('TI Tools Library';Titre="Finance & Performance"); ToolSearchBox.Text; "Tool") ;
CheckboxMarketing.Value;  Search(Filter('TI Tools Library';Titre="Marketing"); ToolSearchBox.Text; "Tool") ;
CheckboxProposal.Value;  Search(Filter('TI Tools Library';Titre="Proposal"); ToolSearchBox.Text; "Tool") ;
CheckboxDTI.Value;  Search(Filter('TI Tools Library';Titre="DTI"); ToolSearchBox.Text; "Tool") ;
CheckboxSCPM.Value; Search( Filter('TI Tools Library';Titre="SCPM"); ToolSearchBox.Text; "Tool") ;

Search('TI Tools Library'; ToolSearchBox.Text; "Tool")

)

Best regards.

Sik

View solution in original post

Mansoor88
Level: Powered On

Re: help, want to update gallery based with criteria, with checkbox

Thank you very much, You are awesome.

 

now I get the point. Keep it on 

Microsoft v-siky-msft
Microsoft

Re: help, want to update gallery based with criteria, with checkbox

Hi @Mansoor88 ,

 

If my post help you resolve your issue, please click  "Accept as Solution"  to help other members to find more quickly.

Best regards,

Sik

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (6,824)