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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,732)