Answered

Auto populate Text Box based on a Dropdown Value

(1) Share

Report

Posted on by TerrificTerri

205

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

Q1.docx

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

Sort by

skylitedave 652 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

TerrificTerri 205 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
skylitedave 652 on at

Like (1)

Report
Copy link

Link copied!

Cool...

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

Was this reply helpful? Yes No
rameshkc 53 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TerrificTerri 205 on at

Like (4)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
TimRohr 669 on at

Like (2)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
rameshkc 53 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TimRohr 669 on at

Like (1)

Report
Copy link

Link copied!
@rameshkc... There are so many ways to do things in PowerApps that I think there are MANY "right" ways!
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"...

Was this reply helpful? Yes No
rameshkc 53 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TimRohr 669 on at

Like (0)

Report
Copy link

Link copied!

OK... yes... now that I see your Items property drills down to the ID field (instead of being the [dbo.tablename]), then you are only getting that one field and you have to do it the way you were before.

If you could get the Items property to point to the table (as above) rather than drilling down to the field, you could do things the way I suggested, because the whole record (all fields) would be in the dropdown.

Was this reply helpful? Yes No