cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Auto populate Text Box based on a Dropdown Value

Okay my PowerApps gurus that I have learned so much from………I am having a issue that should be an easy thing, but me and my learning curve just is not getting where I am making my mistake.

 

Here we go…I got a simple SP List with Three Columns (named as shown except Camera Number = Title).  What I need to do in the PowerApp is populate the text field of the Source depending on the selection of the Camera from a dropdown.

 

I have set a varible and also set UpdateContext, but I am not getting the correct value in the textinput.  Please help.

 

Camera Value Card:

DataField                             “Camera”

Default                                 ThisItem.Camera

DisplayMode     `                  Parent.DisplayMode

DisplayName                       “Camera”

Update                                 dd.Camera.Selected.Value

 

 

Camera Dropdown:

Default                                 Parent.Default

DisplayMode                        Edit       

Items                                    ‘Camera.Source’

OnChange                           UpdateContext({varCamRec: ddCamera.Selected.Value + TxtSource})

 

 

Source Value Card:

 

DataField                             “Source”

Default                                ThisItem.Source

DisplayMode                       Parent.DisplayMode

DisplayName                      “Source”

Update                                 TxtSource.Text

 

 

Source Text Input:

Default                                 varCamRec

DisplayMode                        Edit       

Mode                                    SingleLine

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Auto populate Text Box based on a Dropdown Value

Actually I need the Source to show in the text box.  I was able to find a work around with filtered dropdowns.  Thanks for the input!

View solution in original post

10 REPLIES 10
skylitedave
Level 10

Re: Auto populate Text Box based on a Dropdown Value

if i understand what you want to do

 

set the default of the source text input field to 

dd.Camera.Selected.Value

 

or

 

set the default of the datacard to 

dd.Camera.Selected.Value

 

and set the default of the source text field in that data card to Parent.default

 

Let me know if I understood your question properly and if this helps..

Re: Auto populate Text Box based on a Dropdown Value

Actually I need the Source to show in the text box.  I was able to find a work around with filtered dropdowns.  Thanks for the input!

View solution in original post

skylitedave
Level 10

Re: Auto populate Text Box based on a Dropdown Value

Cool...

 

post what you did if possible.. we can all always learn more!

rameshkc
Level: Powered On

Re: Auto populate Text Box based on a Dropdown Value

@skylitedave@TerrificTerri

I am struggling to populate the text value based on dropdown selection. My sql table has three columns. ID, name and description. 

When user selects name from dropdown, i would like to default the text box to its corresponding description. 

Any help would be appreciated. 

Thanks!

 

 

Re: Auto populate Text Box based on a Dropdown Value

the default value of your text box should be the name of your dropdown with a comma and the desired column.  Example ddName = Name dropdown and ID = Title.  When entering your default value of your text box your formula should look similar to:  ddName. Selected.Title, Description.  

TimRohr
Level 10

Re: Auto populate Text Box based on a Dropdown Value

@rameshkc...

 

If your Dropdown references your SQL datasource, it should already have the 3 fields in each record. Thus, you should just be able to reference the field name appended to the .Selected property of the DropDown:

yourDropDown.Selected.yourDescriptionField

If that doesn't work, you can always perform a LookUp() against the same SQL table based on your Dropdown selection, or you could do a First(Filter()).yourDescriptionField where you limit the Filter to match your DropDown selection.

rameshkc
Level: Powered On

Re: Auto populate Text Box based on a Dropdown Value

@TimRohrThanks for the reply. 

That works for the dropdown value. I wanted to display my other field (text field) to default to correspoding column record based on dropdown value selection.

Eg. 

ID             Description

1              Hello

2              Test

So when user selects ID 1 from dropdown, text field should display Hello and samething with ID 2. (hopefully this makes sense)

Here is what ended up doing this morning 

i created On change formula for dropdown to 

UpdateContext({varWork:LookUp('table',Dropdown2.Selected.Value exactin ID)})

and default property of text box to varwork.description

 

Is this a right way to do? or is there a much simpler version than this?

Thanks!

TimRohr
Level 10

Re: Auto populate Text Box based on a Dropdown Value

@rameshkc... There are so many ways to do things in PowerApps that I think there are MANY "right" ways! Man Wink

That said, the only thing I would wonder is... if you set the Items property of your DropDown1 to be the SQL table "myTable," and that table has the 3 fields you mentioned (ID, Name, and Description)... then even if you set the Value property to be "Name," you should still be able to directly reference the Description property in the Textbox DefaultText property:

DropDown1.Selected.Description

It's certainly quicker. Not sure if that makes it any more "right"...

rameshkc
Level: Powered On

Re: Auto populate Text Box based on a Dropdown Value

@TimRohr

 

So i tired on what you said:

Items property of Dropdown: [dbo.tablename].ID

Default property of Textbox: Dropdown.selected.Description

 

my default property on description shows error (name is not valid)

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,816)