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 a Dropdown ...
Power Apps
Unanswered

Populating a Dropdown with a Column from a SharePoint List, then populating text inputs with the SharePoint list entry

(0) ShareShare
ReportReport
Posted on by 98

Hi everyone, I'm back with another probably noobish question, so sorry in advance!

How can I populate a dropdown with a certain column from a SharePoint list? Would it be possible for me to then populate text inputs with the data from that selection to allow for editing? If so, how?

Categories:
I have the same question (0)
  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @GenericoName  Could you be more specific. What is the data type of this column in SP? Is this comboboc inside an Edit Form? 

  • GenericoName Profile Picture
    98 on at

    It's just a normal app, not a form. All columns in the SP list are set as 'Single line of text'.

  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @GenericoName Could you share your screen and also some more info on the column you want to show in the dropdown and what values you want to be shown in the other TextFields based on the selection in the drop down.

  • GenericoName Profile Picture
    98 on at

    Here you go. I want to have a dropdown populated with the users in the Name column. I want to populate these blank inputs with the rest of the information for the selected Name in the SharePoint List.

    List.PNG

    NHPage.PNG

  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @GenericoName 

    1. The Items Property for the Name ComboBox will be, yourSPList.NameColumn
    2. The OnChange Property for the Name ComboBox will be, UpdateContext({ctxSelectedRecord:LookUp(yourSPList, NameColumn=Self.Selected.NameColumn)})
    3. In the Text Property of the other TextFields, ctxSelectedRecord.columnName
  • GenericoName Profile Picture
    98 on at

    The text inputs don't have a text property, only default. The labels have a text property but, even then, it fails to recognise ctxSelectedRecord.

     

    LoadTest1.PNG

    LoadTest.PNG

  • GenericoName Profile Picture
    98 on at

    Sorry @CNT, forgot to tag again. I'm used to reply functions automatically tagging.

  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @GenericoName Could you show me the code of how and where you are setting ctxSelectedRecord

  • GenericoName Profile Picture
    98 on at

    Posted it in response to your last post, just forgot to tag you 😛

    Is there anything else in particular that I should grab?

  • GenericoName Profile Picture
    98 on at

    @CNT Arrrrgh, I did it again. So sorry!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 329 Most Valuable Professional

#2
11manish Profile Picture

11manish 209 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 179

Last 30 days Overall leaderboard