Hello PowerApps Community! I am relatively new so this might be a general question.
I would like to populate a text label based on dynamic user-selected inputs from 2 dropdowns. All the data comes from a table in a static excel sheet. If I were doing this in excel, a simple vlookup or index formula would give me the value.
So my table has three columns, lets say Colour, Number and Shape with values as follows -
Column 1: Colour - Red, Red, Green, Green, Blue, Blue
Column 2: Number - One, Two, One, Two, One, Two
Column 3: Shape - Circle, Triangle, Line, Rhombus, Square, Pentagon
Required output:
DropDown1: Green (user selected) DropDown2: Two (user selected)
Text Label: Rhombus (autopopulated)
I tried checking other community posts but have found nothing that works for this requirement. What can be done in this case?
Thanks so much!
