web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Populating text input ...
Power Apps
Answered

Populating text input fields with values from dropdown list connected to lookup list in Sharepoint

(0) ShareShare
ReportReport
Posted on by 85

I'm customizing a SharePoint edit form with powerapps. When I open the record it displays the correct data in all the fields. I've added an additional dropdown field [SelectedDescription] that displays choices from another lookup list. I want to select an appropriate choice in that dropdown field and have it populate other text fields in the form already populated by its default value when opened.

 

My lookup list [Order Parts Lookup] has the following fields: Description, Part Number, and Master. The [SelectedDescription] dropdown pulls values from the Description column of OPL. I have all this working so far.

 

On a button push I want to replace the Description, Part Number, and Master text input field values on the form with that of the selection I have made in the dropdown field.

 

Form.Description = OPL.Description

Form.Part Number = OPL.Part Number

Form.Master = OPL.Master

 

I'm having trouble getting the input fields to populate with the lookup field data. On the [OnSelect] property of the button I have the following so far:

 

DataCardValue13.Text = SelectedDescription.Selected.Description

Categories:
I have the same question (0)
  • NandiniBhagya20 Profile Picture
    4,667 Super User 2024 Season 1 on at

    Hi @ShawnPelletier ,
    WOuld you like to diplay Part Number and Master values based on selection of Description dropdown?
    Try using below formula on respective fields - 
    1. Default property of control (DataCardValue..) which needs to display Part Number - LookUp(OPL, DescriptionDropdown.Selected.Value = Description, 'Part Number')
    2. Default property of control (DataCardValue..) which needs to display Master - LookUp(OPL, DescriptionDropdown.Selected.Value = Description, Master)

  • ShawnPelletier Profile Picture
    85 on at

    I need it to happen on a button push otherwise the default values of my text fields will change automatically and not on demand or as needed. Also the Dropdown field I added always displays the first choice from the lookup list and I don't know how to set it to blank instead.

  • Verified answer
    NandiniBhagya20 Profile Picture
    4,667 Super User 2024 Season 1 on at

    Hi @ShawnPelletier ,
    You can use below formula to add blank value to dropdown - 
    Ungroup(Table({dropdownOptions : Table({Value: Blank()})}, {dropdownOptions : Distinct(LookUpList,Title)}),"dropdownOptions")
    To set default value, you will have to use variables - 
    OnSelect property of button - UpdateContext({varPartNumber: LookUp(OPL, DescriptionDropdown.Selected.Value = Description, 'Part Number'), varMaster: LookUp(OPL, DescriptionDropdown.Selected.Value = Description, Master) })
    Then you can use these variables in Default property of controls.
    Assuming the variables will be used on a single screen.


Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard