cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tbrantley
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
camel
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).

Anonymous
Not applicable

@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.

@Anonymous, @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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (3,226)