Answered

Filtering people on skills from excel

(0) Share

Report

Posted on by Martincrul

Hi All,

I have an excel list of people with scores (1 trough 5) on different skillsets. I would like to make a filter on each skillset so you will only see people that score 3 or higher on that skillset.

Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Do you want to filter and get a list of people who have a higher than 3 score in all skillsets or just one at a time?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
Martincrul 9 on at

Like (0)

Report

Just one skillset at a time, so selection would be made on the skillset and the result would be all people with that skillset scoring 3 or higher.

Was this reply helpful? Yes No
Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
Here is what I have: an excel table that looks like this:

I then added a gallery using this excel sheet as the data source, added 4 buttons with the OnSelect of the buttons as:

Button Skill1: Set(filterBy, "Skill1") Button Skill2: Set(filterBy, "Skill2") Button Skill3: Set(filterBy, "Skill3") All: Set(filterBy, "")

I set the Items property of the gallery to:

Filter( Table1, Switch( filterBy, "Skill1", Skill1 >= 3, "Skill2", Skill2 >= 3, "Skill3", Skill3 >= 3, "", true ) )

This is how the gallery behaves:

Let me know in case of any questions.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Filter(Table,SkillsetColumn>3)

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Glad I could help! Good luck with the rest of the app! Feel free to reach out in case of any questions!

Thanks!

Hardit Bhatia

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
Martincrul 9 on at

Like (0)

Report

Hi Hardit, Thanks!

just posted a new question.

After using the solution for filtering by buttons. I now experience the gallery always returns me to the same records detail page, so pressing the next arrow in the gallery next to personA shows me the detail page for personA. But pressing the arrow next to person B, C D, E etc also takes met to details for PersonA.
When I remove the filterBy string I get the right details? Any idea?

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

What is the data source and items property of the form that is showing the details?

Let me know and I can help resolve that as well.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
Martincrul 9 on at

Like (0)

Report

Hi,

tabel is like the one used before, with names, skil1, skill2, skill3 etc.

property of the gallery is:

Filter(Tabel1; Switch(filterBy;"Barco";Value(Barco)>=3;"Novastar";Value(Novastar)>=3;"DBStar";Value(DBStar)>=3;"Linsn";Value(Linsn)>=3;"Glux";Value(Glux)>=3;"ROE";Value(ROE)>=3;"Brompton";Value(Brompton)>=3;"Megapixel";Value(Megapixel)>=3;"AOTO";Value(AOTO)>=3;"";true) && Value(LED_x0020_Technician)>=3,5)

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Hi @Martincrul

I guess what I was asking was when you click on a gallery item to see the details of that time, I assume the user sees a form which displays the details of the selected item. Is that correct? If so, I would like to know the following properties of that form:

1. Datasource
2. Items

Let me know.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No