SKILL MATRIX DEVELOPMENT - Assessment of skills and kow-how with digital check-list in power apps

(0) Share

Report

Posted on by JB-15051554-0

I try to count a number of employee who have complete one or more skills in my application :

Formula for gallery item :

CountRows(
    GroupBy(
        Filter(
            'SKILL MATRIX';
            LookUp('CHECK LIST';
                ID = 'ID EMPLOYES';
                'ID CHECK-LIST'
            )=ThisItem.ID;
            'ID SAVOIR FAIRE' in ComboboxCanvas1.Selected.'Savoir faire générique'.Id
        );
        'IDSAVOIRFAIRE';
        Data
    )
)

Detail of Structure with list microsoft :

- Employee list = ID employee

- Skill list = ID skill, ID know-how

- Check-list list = ID Employee, ID check-list

- Skill matrix list = ID Skill matrix, ID check-list, ID Know-how

Please could you help me with those information ?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

MS.Ragavendar 4,975 Super User 2025 Season 2 on at

Like (0)

Report

@JB-15051554-0,

ComboboxCanvas1.Selected only handles one item — but if you're using multi-select, you need SelectedItems.

Try this

CountRows(
Distinct(
Filter(
'CHECK LIST',
'ID CHECK-LIST' in
Filter(
'SKILL MATRIX',
'ID SAVOIR FAIRE' in
ForAll(ComboboxCanvas1.SelectedItems, Id)
).'ID CHECK-LIST'
),
'ID EMPLOYES'
),
'ID EMPLOYES'
)

If its only single select

Try this

CountRows(
Distinct(
Filter(
'CHECK LIST',
'ID CHECK-LIST' in
Filter(
'SKILL MATRIX',
'ID SAVOIR FAIRE' = ComboboxCanvas1.Selected.'Savoir faire générique'.Id
).'ID CHECK-LIST'
),
'ID EMPLOYES'
)
)

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 4,975 Super User 2025 Season 2 on at

Like (0)

Report

@JB-15051554-0,

A quick follow-up to see, does the suggestion worked for you or still you were looking for any other approaches or assistance.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No