cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted

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
Highlighted
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).

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

Highlighted

@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

Highlighted

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.

 

 

Highlighted

@camel

 

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

Capture4.PNG

 

Capture1.PNG

Highlighted

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

Info.'Home Address'
Highlighted

@camel

 

Tried mutlple ways and still getting error

 

Capture1.PNGCapture3.PNGCapture2.PNG

Highlighted

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

Highlighted

@camel

 

It says "Invalid Name"

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,158)