cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
meywenz
Frequent Visitor

Filtering Gallery or Table, checking if there's a column that is named like a value of Text input and checking if it a has a specific choice value. (HR App)

Hi there!

 

I am currently working on a HR app that deals for example leave requests and employee's skills.

 

Employee's skills are stored in a SharePoint list called competencies and it looks like this. 

 

meywenz_0-1607522831272.png

It is my first project ever and I am not sure if that's a good way but I did it like this so every new employee can fill up a form about his skills and experience.

 

For example, every programming language is an individual  Choice column that has choices like "Don't know", "Novice", "Advanced Beginner" etc.

 

This app has 2 different section, section for employees and managers. Manager should have a ability to filter employees basing on their skills. For example a Manager is looking for employee who knows C/C+ and puts it in a Text Input, Dropdown or Combo box and gallery or table is filtered so it shows a list of employees who choose value other that "Don't know" in that column called "C/C+".

 
 

managerscreen.jpg

Is there any way to filter the gallery for example like this:

-Combobox1.selected.value is a name of column 

-That column has has selected value other than "Don't know".

 

Is this possible? If not, how can I properly prepare list to store that kind of information?

 

I'll appreciate any help.

 

Best regards. 

1 ACCEPTED SOLUTION

Accepted Solutions
FrostedFlake
Resolver I
Resolver I

First of all: I highly recommend to anonymize the names of your employees.

Hope this will help you (Put this in your "Items" property of your gallery)

 

 

Filter(Sort(Competencies; ID; Descending); JavaScript.Value <> "Don't Know")

 

 

FrostedFlake_0-1607526361889.png

 

This should only show entrys where JavaScript is unequal "Don't know", sorted Descending.

Let me know if this works for you, you should be able to extend this query for your needs.

 

View solution in original post

5 REPLIES 5
FrostedFlake
Resolver I
Resolver I

First of all: I highly recommend to anonymize the names of your employees.

Hope this will help you (Put this in your "Items" property of your gallery)

 

 

Filter(Sort(Competencies; ID; Descending); JavaScript.Value <> "Don't Know")

 

 

FrostedFlake_0-1607526361889.png

 

This should only show entrys where JavaScript is unequal "Don't know", sorted Descending.

Let me know if this works for you, you should be able to extend this query for your needs.

 

View solution in original post

Thank you for your answer!

 

I left only my name so don't worry. 

Your formula gave me a hint how to do that. I hope it's going to work.

 

Let me know!

meywenz
Frequent Visitor

Yes it did work.

 

I used your hint and prepared a long Switch that looks like this:

Switch(
    ComboBox1.Selected.Value,
    "JavaScript",
    Filter(
        Sort(
            competencies,
            ID,
            Descending
        ),
        JavaScript.Value <> "Don't know"
    ),
    "Python",
    Filter(
        Sort(
            competencies,
            ID,
            Descending
        ),
        Python.Value <> "Don't know"
.
.
.
.
.
.
.
    ), competencies
)

but with many more languages etc 😉

 

I know it's not a sophisticated way to do it but it worked. 

 

Thank you for your help.

Well done!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,298)