Filter Gallery depends on Toggle value

(0) Share

Report

Posted on by KarCz

Dear PowerApps Experts,

I need your help - I want to Filter a Gallery with dependency on Toggle value. I have 3 columns:

Expert Name (Person)

Specialization (Single Line of Text)

Hobby (Single Line of Text)

The list is filled with data about Expert and his Specializations and/or Hobby. Not every Expert has Hobby/Specialization value. Toggle value is "Specialization" - as false and "Hobby" - as true in toggle (Toggle1.Value).

I want to Filter a Gallery depending on toggle, that shows every Expert with Specialization (if he has this column filled), when I toggle to Hobby, it shows every Expertwith Hobby - if he has this column filled. Of couse most of Expert has both columns filled, so they should appear in both views.

My Items in Gallery looks like this - it worked only for Specialization, but I need to add this Hobby column and show it properly:

SortByColumns(
Filter(
AddColumns(
'Champions',
"PersonSort",
Last(ForAll(Split('Expert Name'.DisplayName," "), {Result: ThisRecord.Value})).Result
),
Active, TextSearchBox1.Text in Specialization || TextSearchBox1.Text in 'Expert Name'.DisplayName),
"PersonSort",
If(SortDescending1, SortOrder.Descending, SortOrder.Ascending)
)

Thank you in advance for your help!

@RandyHayes

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@KarCz - To filter the Gallery to display non-blank entries in the Specialization field, or non-blank entries in the Hobby field based on a Toggle, consider using an IF or Switch function. e.g:

SortByColumns( Filter( AddColumns( 'Champions', "PersonSort", Last( ForAll( Split( 'Expert Name'.DisplayName, " " ), {Result: ThisRecord.Value} ) ).Result ), Active, TextSearchBox1.Text in Specialization || TextSearchBox1.Text in 'Expert Name'.DisplayName, If( Toggle1.Value, !IsBlank(Specialization ), !IsBlank(Hobby ) ) ), "PersonSort", If( SortDescending1, SortOrder.Descending, SortOrder.Ascending ) )

Note I am not clear on what the field type for "Active" is, but I would guess it is a Yes/No field type, which in SharePoint would output true or false.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @KarCz ,

Hope this might help:
//Items property of Gallery If( Toggle1.Value, //Sort and Filter by Hobby , //Sort and Filter by Specialization ) //TrueText of Toggle control "Filtered by Hobby" //FalseText of Toggle control "Filtered by Specialization"

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,033 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @KarCz ,

I may be interpreting what you are asking incorrectly, but is this what you are after ?

SortByColumns( Filter( AddColumns( 'Champions', "PersonSort", Last( Split( 'Expert Name'.DisplayName, " " ) ).Value ), Active && ( TextSearchBox1.Text in 'Expert Name'.DisplayName || ( !Toggle1.Value && TextSearchBox1.Text in Specialization ) || ( Toggle1.Value && TextSearchBox1.Text in Hobby ) ) ), "PersonSort", If( SortDescending1, SortOrder.Descending, SortOrder.Ascending ) )

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
KarCz 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you guys, will check that slightly later & let you know. I really appreciate your help!

Was this reply helpful? Yes No
KarCz 85 on at

Like
a
(0)

Report
Copy link

Link copied!

It worked! Thanks!

I just deleted one line to meet my requirements 🙂

SortByColumns(
Filter(
AddColumns(
'Champions',
"PersonSort",
Last(
Split(
'Expert Name'.DisplayName,
" "
)
).Value
),
Active &&
(
~~TextSearchBox1.Text in 'Expert Name'.DisplayName ||~~
(
!Toggle1.Value &&
TextSearchBox1.Text in Specialization
) ||
(
Toggle1.Value &&
TextSearchBox1.Text in Hobby
)
)
),
"PersonSort",
If(
SortDescending1,
SortOrder.Descending,
SortOrder.Ascending
)
)

Was this reply helpful? Yes No