Filter list item with a checkbox

(0) Share

Report

Posted on by David410

Hi,

I'm new in powerApps, and sorry for my poor english.

I have a SharePoint list "Congés", with a multiple choice column "Type of leave" which can be :
RTT/ Paid leave/etc.

Capture d’écran 2022-12-28 132022.jpg

I would like to filter this list, in powerApps, by leave type, with an RTT checkbox that only displays RTT type leaves if it is checked.

Capture d’écran 2022-12-28 132210.jpg

On my checkbox, on the "Oncheck" property, I put :
Filter('Congés';'Type de congés'.Value="RTT")
But it doesn't work.

Someone can explain me why ?
Thank you !

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@David410

In the items property of your gallery

Filter('Congés'; !Checkbox1. Value || 'Type de congés'.Value="RTT")

Was this reply helpful? Yes No
David410 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp
Thank you.
But is it possible to use the "Oncheck" property of my checkBox to manage my list items or, for example, change the color of a component ?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @David410，

Do you want to change the color of a control based on the OnCheck property of the Checkbox?

Set the Color property of your component as below:

If(Checkbox1.Value,Red,Green)

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@David410

Do you see the pattern? The target controls reference the checkbox. The checkbox doesn't initiate the action.

Was this reply helpful? Yes No
David410 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp
1/Ok, but in this case, how do we use the checkBox properties "onCheck" / "onUnCheck" / "onSelect" etc. ?

2/On my gallery I have this formula to sort my items :
SortByColumns(Filter([@Congés]; StartsWith(Title; TextSearchBox1.Text)); "Created"; If(SortDescending1; Descending; Ascending))
How can I add this condition :
Filter('Congés'; !Checkbox1. Value || 'Type de congés'.Value="RTT") ?

Thank you !

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@David410

WIth({_cong: Filter('Congés'; !Checkbox1. Value || 'Type de congés'.Value="RTT")},

SortByColumns(Filter(_cong; StartsWith(Title; TextSearchBox1.Text)); "Created"; If(SortDescending1; Descending; Ascending))
)

Was this reply helpful? Yes No