Powerapp compare 2 lists

[fosso]

Hi, I’m currently creating a canvas app that tracks qualifications held by employees, the data is stored in SharePoint lists I have setup the following lists

Employee

EmployeeRole

Roles

RoleQualifications

Qualifications

EmployeeQualifications

So the employee has a ‘role’ or multiple ‘roles’ these roles are linked to qualifications.

I’m trying to come up with a way of comparing the qualifications required for a role to the qualifications held by the employee and ‘highlighting’ the qualifications that are ‘missing’ for that employee.

Any help pointing me in the right direction would be appreciated.

[eka24]

Can you be more specific with some samples of what role and qualifications. Or just checking if blank would be ok

------------

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.

[leyburn19]

I do this.  You need three lists.  Employee, Roles,  Qualifications

When anew employee is added,  the user then goes to a view to add roles.  From here they select all teh roles the want teh employee top have.  I use a simple list based on the Roles List and add to a Collection.  When save this then adds all those selected roles to the employee Qualifications list which is connected using the ID from teh employee field.  As they are new each role gets a basic status and it is expected to be updated when evidence or qual is achieved.

In the background I have a weekly flow that checks teh quals list for those due to expire or not yet updated and send an email to Site Leader with To Do List

[v-siky-msft]

Hi @fosso ,

Could you please share more details about your scenario?

I have no idea about the structure of these lists and their relationships.

In my opinion, This is a table relationship issue. After the relationship between the these LISTS of Employee, EmployeeRole and RoleQualifications is clarified, the qualifications required by the specific role of employees can be obtained and displayed in the Gallery. After comparing the qualifications which are already had  by employees, different colors can be displayed in the fill attribute of the gallery to highlight them.

Sik

[fosso]

So

i have the Employee list with the usual personal details ie;

FirstName: Joe

Surname: Bloggs

Department: Mining

Role List, has role descriptions;

ID	Title
1	Truck Operator
2	Chargeup

I then have the Employee Linked to the Role with; (Employees may have multiple roles)

EmployeeRole List;

Employee: Lookup-Employee List

Role: Lookup-Role List

ID	Employee	Role
1	Joe Bloggs	Truck Operator
2	Sam Smith	Charge-Up
3	Joe Bloggs	Charge-Up

Then the Role has Qualifications linked to it & The Qualifications have competencies linked to them, so basically the employee completes individual competencies to gain qualifications for the role.

RoleQualification 

ID	Role	Qualification
1	Truck Operator	Operate UG Truck
2	Truck Operator	UG General Induction
3	Charge Up	UG General Induction
4	Charge Up	Production Charging

QualificationCompetencies

ID	Qualification	Competency
1	Operate UG Truck	UG Truck Theory Assessment
2	Operate UG Truck	UG Truck Practical Assessment
3	Production Charging	Production Charge Theory
4	Production Charging	Production Charge Practical

The final list is the competencies held by the employee 

ID	Employee	Competency	Completed Date
1	Joe Bloggs	UG Truck Theory Assessment	1/10/2020
2	Sam Smith	Production Charge Practical	2/09/2020

I have been able to create screens that display the roles for the employee and a list of all competencies held(Using Galleries), however I’m having trouble Showing what roles the employee is fully qualified for and also listing what competencies the employee needs to complete the qualification.

[fosso]

Hi  @v-siky-msft

Thanks for the response, I have posted further details below, I like the idea of using fill colour to highlight, what is the best way to do the comparison between What the role requires and what qualification the employee holds.