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 / Help show value from a...
Power Apps
Suggested Answer

Help show value from a choice column in SharePoint list

(1) ShareShare
ReportReport
Posted on by 4
 
The Right side, I have a gallery  (with Text Labels) that's pulling data from my sharepoint list.
The left side I have a few text input boxes and "Default" is set to "gallSelected.Sharepointcolumm". 
 
When I select a item from the Right side, the values popuplate into boxes on the left side (so far so good). The end goal is to be able to edit the data that shows up on the left side and update it back to the list using a button and the patch function (not there yet). Currently, i can edit all the values in the boxes on the left side except the field that contains the choice column. The field will show me the values in that column but i cannot edit the values (The sharepoint list column has 4 choices,). if i changed the input to Drop / combo, I get the same values that already exist (which is fine) but i do not see the other available choices or be able to select them. 
 
 
Ex. I have a record (in sharepoint list)
 
Name       Mailbox        Location (4 choices in column in sharepoint)
Test           O365            main Office (this was selected for this record)
                                      Home
                                      Road
                                      remote office
 
In powerapps the field would show main office for test which is correct. But If i want to change that to home or road I cannnot. I cannot edit the text imput value, I also do not see the other available options to select it. 
 
This is where I am stuck. 
 
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,969 Moderator on at
     
    You need to make sure that your Items property is actually set to the Choices(yourchoice) so it lists them all. Then in the DefaultSelectedItems, you would select the ones that are for the current record.
     
    What do you havein the Items property for the Combo/Dropdown, my guess is you have it set to the selected record?
  • JL-18031601-0 Profile Picture
    4 on at
     I'm very new to powerapps. in drop down, there is a "items" and it is set to "DropDownSample" and no "defaultselecteditems". If i use a combo box both items exist. I guess I should be using a combo box for this then. 
     
     
     
     
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,969 Moderator on at
     
    So the items property, it drives what the "total viewable/selectable things are".
     
    A drop down by default, is a single select and it automatically selects the first item, but you can turn that off.
    For a dropdown, the Default Is where select which item is selected (versus the default of the first item)
     
    So in the Dropdownsample if it was ["1","2","3"]
     
    By default you'd see 1 selected and 1 2 3 as the options. If you wanted 2 to be shown as the selected, because the data you want to display already has an option in your data storage, you'd set the Default to 2. (you'd do it progrmatically, not hard code it to 2)
     
    For ComboBoxes
    It works like a Dropdown and Multi-select dropdown in one, meaning
     
    1. You can set a ComboBox to only allow 1 selectable like a Dropdown
    2. You can set a ComboBox to allow you to select multiple items
     
    If you do #1, and if you saved the data and later wanted to display the selected "data point" then you would use the Default property.
    If you do #2, and selected multiple items, then you have to set them in the DefaultSelectedItems as its  Table of records, not a Single record.
     
    Imagine this.
     
    1. You have a Gallery of data or a Table in the UI
    2. You select a record
    3. You want people to see (view) the data in a new form. You would use the Gallery.Selected property to then populate the Form with data.
    each control ON the form would show the Value that was in the Gallery (aka loaded from your datasource)
     
    But imagine now that you want to Edit that record not view it.
    Further imagine you have a list of options for a Column. 
    You would want 2 things
    1) to load all the possible options it COULD be in the Items property
    2) Have the "selected" or "selecteditems" property set to the currently loaded records data, so you can see what its currently set to. then change it, and then save it.
     
    So in what you just typed, you simply have a list of data (the dropdownsample), and since you have no Default value set, it woudl just select 1 (assuming thats the first data point)
     
  • JL-18031601-0 Profile Picture
    4 on at
    So I set the "items" attribue so now I had the list of choices but the "defaultselecteditems", I'm trying to get it to show the existing values if any but I can't figure out the sytnax. I tried using filter(SharePointlist, columnname = (", ") ) but that doesn't seem to work. 
     
     

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard