You’re offline. This is a read only version of the page.
Announcements
I have a data table with User name as column Headers and their corresponding data as rows as shown below
| Data | Name 1 | Name 2 | Name 3 |
| Skill 1 | Beginner | Beginner | Professional |
| Skill 2 | Professional | Beginner | Professional |
| Skill 3 | Beginner | Professional | Professional |
Part 1:
I want to filter the column according to the user selection in a text box or dropdown.
So when the user selects Name 2 I want the table to be populated as
| Data | Name 2 |
| Skill 1 | Beginner |
| Skill 2 | Beginner |
| Skill 3 | Professional |
Part 2:(can be done by regular Filter method)
Once I get this table I need another dropdown with items "Beginner" and "Professional".
When selected, another dropdown or list,nearby should populate the data of the selected Skill Level of the particular person.
Eg: When "Beginner" is selected the other dropdown or list should contain items "Skill 1" and "Skill 2".
P.S: I also tried transposing the data table and filtering. But doing that i will not get the Part 2 as that requires filtering by columns as well.
So I want a know the way to do the Part 1
Thanks in Advance
Hi @Anonymous
The reason your are having difficulty is because your underlying model is flawed. Your backend database would be best fit to a Many-To-Many relationship as depicted below and it requires three tables to best describe it. The middle table is called a junction table and is a combination of two One to many relationships. IIt is important to understand basic database principles before creating an app. Please review my blog posts that can take you through the rationale and step by step creating a PowerApp. https://powerusers.microsoft.com/t5/News-Announcements/Database-Design-Fundamentals-and-PowerApps-An-Overview/ba-p/184485
Share
Report
All responses (
Answers (
711
