Unanswered

Filter a Dropdown Based on Two Different SharePoint Lists

(0) Share

Report

Posted on by Applications

Hello!

I'm trying to filter a PowerApp dropdown based on two different SharePoint list values,

One is a List with whether or not a vehicle is "available" which I currently am using for the default filter for the dropdown:

Filter('Vehicle Information', Status.Value="Available")

I need to add another filter from another SP list that will track whether or not the vehicle is "checked in" meaning available to be checked out by users. This SP list is essentially a running list of who has checked in/checked out the vehicles and at what time, but I cant seem to figure out how to add both filters to my dropdown to get them to work in combination with each other.

End goal is to show which vehicles are "available" from SP list 1 as well as "checked in" from SP list 2.

My SP List names are:

SP List 1: Vehicle Information

SP List 2: Vehicle Tracker

Important Columns and Names:

SP List 1: "Status"

SP List 2: "Vehicle ID Number" (Field=IdentificationNumber), "Vehicle Status: (Field=EquipmentStatus)

Anyone able to assist me? I'm not sure if adding another Filter is correct, or if it needs to be distinct or last - although I'm sure there's multiple ways to do this... I just cant figure it out for some reason 😞

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

DavidZoon 738 Most Valuable Professional on at

Like (0)

Report
Hello,

You can try something like this :

Filter('Vehicle Information', Status.Value="Available", CountRows(Filter('Vehicule Tracker',IdentificationNumber=[your Vehicule ID Number in SPList1],EquipmentStatus.Value="Checked in"))>0 )

The idea is to add a condition to your main filter, where you count the rows matching your condition on SP List 2 Data.

You just have to get a common ID between 2 lists : [your Vehicule ID Number in SPList1] / "Vehicle ID Number" in SP list 2

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.

Was this reply helpful? Yes No
Applications on at

Like (0)

Report
So I modified it slightly to fit your point you made in your reply to:

Filter('Vehicle Information', Status.Value="Available", CountRows(Filter('Vehicle Tracker', IdentificationNumber=['Vehicle Information'.Identifier], EquipmentStatus.Value="Checked In"))>0 )

But my dropdown is now blank and doesn't show any of the vehicles at all. Also I'm not sure if it matters in this formula or not, but the Identifier column in SP List 1 is a text field (also the field=Title), whereas in the Vehicle Tracker, the Identification Number is a selection.

Was this reply helpful? Yes No