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:
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!
