cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Help populating text box based on value of drop down

How can I populate the value of a text box based on the value of a dropdown? The drop down has values from table1 and the text box will retreive its value from table2

1 ACCEPTED SOLUTION

Accepted Solutions

I simulated your lists in PA and everything went OK here. Let me show what I have done:

 

Layout of the applicationLayout of the applicationFirst button, to simulate the Drivers Timesheet ListFirst button, to simulate the Drivers Timesheet ListSecond button, to simulate the Drivers Info ListSecond button, to simulate the Drivers Info ListDropdownDropdownFirst InputFirst InputSecond InputSecond Input

View solution in original post

22 REPLIES 22
Microsoft
Microsoft

You can use UpdateContext({ItemYouSelected: DropdownMenu.Selected }) in the OnChange property from the Dropdown. And after that you can use the filter in Table2 items with the ItemYouSelected.Value (or any property your item has).

Kudo Kingpin
Kudo Kingpin

@tbrantley,

 

There's also another way to do that. Set your text box Default field equal to the DropdownList.Selected.Value, and it will automatically update with the list.

@TonyHart, @camel

 

I got it to populate home address with the value of the drop down. How would I retrieve home address and clock No from Driver Info based off the drop down box?

 

Capture3.PNG

Capture2.PNG

Something like this would work. Just add this to OnChange property from the Dropdown:

 

UpdateContext({Info : LookUp(DriverInfo,DropdownValue exactin Name)})

After setting the Info, you will need to set up the Default property from both 'Home Terminal Address' e 'Clock No' Text Boxes.

 

 

@camel

 

Would I set the default property for 'Home Terminal Address' text box = Info?

Capture4.PNG

 

Capture1.PNG

You need to access the Column 'Home Address' from your Record. Something like this will probably work:

Info.'Home Address'

@camel

 

Tried mutlple ways and still getting error

 

Capture1.PNGCapture3.PNGCapture2.PNG

@tbrantley can you please hover the yellow message sign and show the error message?

@camel

 

It says "Invalid Name"

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (93,421)