Power Platform Community Forum Thread Details

I have a data connected list/table with information of people profile information (Name, location, sex, etc.) on one screen title List (it's a Microsoft List).
On the Home Page of the app, I want to have 2 buttons, Wizard and View full list (I don't want the list to be visible on the Home Page).

When the user clicks the Wizard button, I want it to take them to a Filtering Wizard (the other button will link to the the full list on another screen)
This is where I'm stuck.
On the Filtering Wizard, I want to ask 2 questions such as, "Choose a sex" then have Male, Female, or Either (Sex is a column in the List). Then have a second question for location. So it looks like this very rough draft:

How do I code the PowerApp so that when an end user clicks on Male, it will filter the list (on another screen) for all Males; then when they select the Location it filters further and then (maybe they will click a submit button) it displays the filtered list of people?

Do the filters have to be on the same screen as the List? Any help is greatly appreciated!

Categories:

Building Power Apps

hi @TiffanyK ,

off the top of my head, the easiest way i can think of would be to set a variable in your buttons OnSelect property to hold the value of the button that was selected. for example if someone clicks the Male button the onselect property would be something similar to the following:

Set(varGender, "Male")

you would apply that to the other buttons as well to change the value to "Female" or "Either" if those buttons are clicked instead.

then, same idea for location.

Set(varLocation, "LocationButtonName")

in the items property of your gallery you will want to adjust the following code by replacing control names with the names you gave to your controls/ variables.

//if no buttons selected, show entire list
If(IsBlank(varGender) && IsBlank(varLocation), 'YourListName',
//if location button selected filter by selected location
IsBlank(varGender) && !IsBlank(varLocation), Filter('YourListName', 'Sex' = varGender),
//if Gender button selected filter by selected Gender
!IsBlank(varGender) && IsBlank(varLocation), Filter('YourListName', 'Location' = varLocation),
//if both gender and location selected filter by both
!IsBlank(varGender) && !IsBlank(varLocation), Filter('YourListName', 'Location' = varLocation && 'Sex' = varGender))