How to get the results from 3 lists

(0) Share

Report

Posted on by dkayt

517

Hi All,

I have 3 lists :

* Combined List : CombinedNumber and EmployeeID;

* Vehicle : CombinedNumber, RentalColumn ("Yes","No");

* Driver - EmployeeID and Department ("A","B", "C")
I want to have the CountRows() of the results of these 3 lists. How should my Filter() look like? Should I use a Lookup()?

e.g. There is 5 Employees (Department : B; RentalColumn : Yes).

Best Regards,

dKayt

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

royg on at

Like
a
(0)

Report
Copy link

Link copied!
Yes, you need to add 2 LookUp columns to your combined list:
Something like:
AddColumns(CombinedList, "EmpDepartment", LookUp(Driver, EmployeeID=CombinedList[@EmployeeID]).Department, "VehicleRental", LookUp(Vehicle, CombinedNumber=CombinedList[@CombinedNumber]).RentalColumn)
You can collect that into a collection and display in gallery or simply set the gallery items property to that expression.
Now, you can Filter by the 2 added columns (EmpDepratment and VehicleRental) and count the returned rows or simply display the gallery itemscount property.

Hope this helps

Was this reply helpful? Yes No
dkayt 517 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
thanks for replying.
I try this, I put it into a Collection and I get the entire CombinedList with 2 additionals columns.
My Filter looks like this :

CountRows(Filter(CombineList, VehicleRental.Value = "Yes" And EmpDepartment.Value = "B"))

Currently result : all the items from CombineList.
What I want to see : Only 5 Items.

Do I miss something in my Filter()?

Was this reply helpful? Yes No
royg on at

Like
a
(0)

Report
Copy link

Link copied!

Perhaps it should be = "Yes" instead of = Yes

Was this reply helpful? Yes No
dkayt 517 on at

Like
a
(0)

Report
Copy link

Link copied!

Even If I correct it. It doens'nt work like expected.

Was this reply helpful? Yes No
Verified answer

dkayt 517 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @royg
I find another way to resolve my problem, hopfully It can help someone too ^^

OnVisible ClearCollect(colVehicle, Filter(Vehicle, RentalColumn.Value = "Yes").CombinedNumber); ClearCollect(colDriver, Filter(Driver, Department.Value = "B").EmployeeID); ClearCollect(colCombinedList, Filter(CombinedList, CombinedNumber in colVehicle)); ClearCollect(colResult, Filter(colCombinedList, EmployeeID in colDriver)); Label - Text property: CountRows(colResult)

It works fine.

Was this reply helpful? Yes No