cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Why can't I create a dropdown with the choice fields of my SharePoint list ?

Hello,

When I'm creating a dropdown using data from my list I noticed that in "Value" (see attachment), you can put all the fields of the SharePoint list BUT the choice fields,

Why is that and how can use create a dropdown with all the items of a choice field ?

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions

The settings for your column will be on SharePoint. You go to your SharePoint list, and go to your list settings. If you are at the SharePoint list you can click on the gear in the top right and one of the options from it is 'List settings'. 

 

Once you have it open click on the column that is a choice column and look at the settings for it. Under the Display choices using the options are: Drop-Down Menu, Radio Buttons and Checkboxes. You want to have it as the Drop-Down Menu choices. 

 

After that is selected in your app the DropDown items will be Choices([@SPListName].ColumnName). The Items should be the same whether you use a dropdown or combo box. 

 

 

View solution in original post

8 REPLIES 8
rebeccas
Community Champion
Community Champion

Dropdown only allows a selection of one item...Combo box will allow you to select more than one. Check the settings on your column and see if it "allows multiples" and if it does then you will not be able to use a dropdown for it unless you change that.

Anonymous
Not applicable

Not sure what you mean, when I create a combo box it's automatically dependant of the dropdown I already created and that's not what I want,

 

As for the settings on my column, what do you mean and where do I find them ?

The settings for your column will be on SharePoint. You go to your SharePoint list, and go to your list settings. If you are at the SharePoint list you can click on the gear in the top right and one of the options from it is 'List settings'. 

 

Once you have it open click on the column that is a choice column and look at the settings for it. Under the Display choices using the options are: Drop-Down Menu, Radio Buttons and Checkboxes. You want to have it as the Drop-Down Menu choices. 

 

After that is selected in your app the DropDown items will be Choices([@SPListName].ColumnName). The Items should be the same whether you use a dropdown or combo box. 

 

 

Anonymous
Not applicable

I checked and I already have it has dropdown

Anonymous
Not applicable

Ok, now I can have my field in a dropdown thanks to this formula =  Choices([@SPListName].ColumnName)

 

I want to use this dropdown as a filter for a gallery along with a searchbox, the searchbox is already working well, but the error come when I add the dropdown.

 

Here is my formula : Filter('Liste OT test V2',StartsWith(NumOT,RechercheOT.Text) Or RechercheOT.Text in DescriptionOT),EquipeOT.SelectedText = EquipePrincipale

 

You can see the error in the attachment,

 

RechercheOT = searchbox

EquipeOT = dropdown

Anonymous
Not applicable

I found the syntaxis error:

 

I should have put "value" at the end of each variable: 

Filter('Liste OT test V2',StartsWith(NumOT,RechercheOT.Text) Or RechercheOT.Text in DescriptionOT,EquipeOT.Selected.Value = EquipePrincipale.Value)

 

Now it works perfectly,

 

Thanks for your help,

zedinfotech
New Member

on the item property of dropdown use this code   :     choices(listname.choice column name)

PowderTracksAdm
Frequent Visitor

None of the solutions they suggested in here worked for me. No matter what I did, I could not get a drop down control to give me values for Choice columns.  The only way I got this to work was to go into the Sharepoint list and create a Calculated column then set its value to equal what ever the choice columns value was. Literally just double click the column from the list in the formula. Save it and boom, it shows the text value. The calculated columns shows up in the options for displaying the value. The only down fall to this is that all calculated rows that don't have values now show a 0 instead of simply being blank. So I entered a formula in the column settings that just simply puts a blank if it is empty. Example -  =If(IsBlank(ChoiceColumn),"",[ChoiceColumn]). Adding to this, I had to add a filter on the drop down in Powerapps: Filter(SharepointList,!IsBlank(CalculatedColumn)). Now my Drop Downs populate with my choice columns. I would also add a formula that filters unique values to narrow down your list if you have several of the same thing in the list. 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (4,060)