web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Join tables and find r...
Power Apps
Unanswered

Join tables and find records based on search criterias

(0) ShareShare
ReportReport
Posted on by 44

Hi all,

 

I am quite new to Powerapps and as I am not a developer nor especially good in Excel I would appriciate some guideance and help for the app I am trying to build.

Car finder
Goal of the app: Let users search and find cars within the stock inventory (or on the way/ordered to the stock inventory) based on certain search criterias

Table 1: CarTable
All cars are located within the "RefTable" - each car has a unique identifier (CarID). This table also includes the class and model of the car.

CarID

CarClass

CarModel

1111

Sedan

SE-25

1112

Sedan

SE-30

2222

Pickup

PU-10

3333

Pickup

PU-20

4444

Sport

SP-55

5555

Sport

SP-90


Table 2: LifeCycleTable

However - as a car can have multiple lifecycles, where only one can be active - there is another table which holds the relationship between the Car (CarID) and the active lifecycle of the car (LifeCycleID - also a unique ID). This means there is a relationship between the LifeCycleID. This table also holds more information about the lifecycle such as condition, inventory status etc. 

RefID

LifeCycleID

Type

Status

Condition

1111

CAR-1234

New

InStock

OK

1112

CAR-2312

Used

Reserved

OK

2222

CAR-9200

New

InStock

OK

3333

CAR-0812

Used

Reserved

OK

4444

CAR-4512

Used

InStock

Poor

5555

CAR-0721

Used

Ordered

OK


Table 3: SpecTable
Each car/lifecycleID consist of different configuration options which are classified within different configuration types (Option/Accessory)

Description

LifeCycleID

SpecType

2-door

CAR-1234

Option

V8 Engine

CAR-2312

Option

V8 Engine

CAR-9200

Accessory

22" Rims

CAR-0812

Option

24" Rims

CAR-4512

Accessory

Goodyear Tires 24"

CAR-0721

Used


Right now I have this setup of dropdowns but it does not really work. But what I am after is something like this:

Users specify the following information:

AndLun_0-1643364843390.png

And in this case the search/list of results should only display CAR-9200 as this is the only car that is available in stock of that specific model with a specification description that includes "V8". 

I've done some modelling with the dropdowns but can't really get it to work... Appriciate all help and guidance! Thanks!


Categories:
I have the same question (0)
  • AndLun Profile Picture
    44 on at

    Anyone have any suggestions or guidance? Still trying to find a way how to proceed here. Thanks!

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @AndLun,

    I think you want to create cascading dropdown.

    Here is how I configure the dropdown.

    1). To set the Car Class dropdown Items property as below:

    Distinct(CarTable,CarClass)

    2). To set the Car Model dropdown Items property as below:

    Distinct(CarTable,CarModel)​

    3). To set the Car Type dropdown Items property as below:

    Distinct(LifeCycleTable,CarType)​​

    4). To set the  Specification dropdown Items property as below:

    LookUp(LifeCycleTable,RefID=LookUp(CarTable,CarClass=Dropdown_CarClass.Selected.Result,CarModel=Dropdown_CarModel.Selected.Result).CarID).LifeCycleID
  • AndLun Profile Picture
    44 on at

    Thanks! I have actually already done the 3 first ones (however they only return the top 50 values or so..). I will try the one for specification. However - as I only want to show cars that are in stock - I guess I would need a filter somewhere and I am a bit unsure where to put this (InStock)?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 70

#2
WarrenBelz Profile Picture

WarrenBelz 64 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 36 Super User 2026 Season 1

Last 30 days Overall leaderboard