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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,828)