Share
Report
76Hi,
I'm new to PowerApps and i'm stuck on building an app. I simplified this example to understand what i need to do.
Let's say i have 3 items, and 3 properties. The quality of the property differs per item, this is rated by a letter (A,B,C.. etc), it looks like this:
| Property1 | Property2 | Property3 | |
| Item1 | A | A | C |
| Item2 | A | B | D |
| Item3 | B | C | D |
I want the user of my app to fill in the quality of each of the 3 properties, with this i want the app to find a suitable item.
Lets say on dropdown1 (property1) i fill in quality A, then dropdown2 (property2) should only give me a choice containing A and B.
If i choose quality A in dropdown2 (property2) aswell, then i want dropdown3 (property3) to only let me select quality C.
Now every property has a quality and item1 should be the result of my property choices.
Thusfar i used 'Distinct(Filter())' to for example get the avaible qualities of property2 based on my quailty choice in property1, however i do not know how to do this for multiple properties at once. For example the the quality based on my choice in property1 and my choice in property2.
I'm sure i can use a 'and' statement in my filter to show results based on multiple criteria, however when i get alot of properties this will be diffecult to maintain, there must be a more dynamic way of setting this up
In reality it looks like this it is alot more properties, qualities and possibly resulting items:
Blue = properties
Red = items
Black= qualities
All responses (
Answers (
