web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Employees based...

Power Apps

Answered

Filter Employees based on the required inductions of a project

(0) Share

Report

Report

Posted on by kevinbaroro

7

Hi All,

I'm banging my head on how can I correctly filter the employees based on the required inductions from a Project. Below is my data structure.

Employee List

ID EmpName

1 Emp1

2 Emp2

ProjectInduction List

ProjectID InductionID Title

1 1 Cert1

1 2 Cert2

EmployeeInductions

EmpID InductionID

1 1

1 2

2 1

On the above data structure, I want to filter or get only the employees having the same induction from a Project so the desired result must be showing EMPID 1 since he have all the inductions from the specific project

Result collection

EmpID

1

Please let me know if the above is clear. Thank you in advance

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kevinbaroro ,

I assume there are two tables:

ClearCollect( ProjectInduction, {ProjectID:1,InductionID:1,Title:"Cert1"}, {ProjectID:1,InductionID:2,Title:"Cert2"} ); ClearCollect( EmployeeInductions, {EmpID:1,InductionID:1}, {EmpID:1,InductionID:2}, {EmpID:2,InductionID:1} );

Please try:

RenameColumns(Filter(Distinct(EmployeeInductions,EmpID),CountRows(Filter(ProjectInduction,InductionID in Filter(EmployeeInductions,EmpID=Value).InductionID))=CountRows(ProjectInduction)),"Value","EmpID")

Best Regards,

Bof
kevinbaroro 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft,

As per implementing the formula you provided, its working as intended. Thank you so much. Such a big help 😊

Join the conversation