Unanswered

Combo Box in Form showing manually entered values instead of defaulted ones only

(0) Share

Report

Posted on by lterrazas

Hello,

Beginner here. I have a form that is connected to a SharePoint list. One of the fields is a combo box with five choices for the user to select. (ex. 1,2,3,4, N/A). The user also has the option of entering a value manually. When the user enters the value manually, it adds that entered value to my combo boxes choices. Basically, now makes 6 choices instead of the five. I cant figure of how to only show the default choices and not include any of the manual ones. Any help would be appreciated! Im thinking somehow i would need to change the DefaultSelectedItems perhaps?

Categories:

General Questions

Connecting to Data

All responses (4)

Answers (0)

WarrenBelz 146,618 Most Valuable Professional on at

Like (0)

Report
Combo Box in Form showing manually entered values instead of defaulted ones only

Hi lterrazas

I did not get the reply notification for some reason - firstly assuming you are writing back to a Choice field, then the Update of
{ Value: Coalesce( cboBoltsMissing.SearchText, cboBoltsMissing.Selected.Value ) }

should work,

You can leave the Items as
Choices([@'MT Review-San Francisco'].'# of Missing Leg Bolts?')

assuming that contains the values you need.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
lterrazas 51 on at

Like (0)

Report

Combo Box in Form showing manually entered values instead of defaulted ones only

Hello @WarrenBelz

Im using a form with the classic combo box. I populated my choices in sharepoint. The five choices are 1,2,3,4 and N/A. For this combo box it is setup in sharepoint to allow the user to enter a value manually.

Name of Combo Box: cboBoltsMissing

Items:

Choices([@'MT Review-San Francisco'].'# of Missing Leg Bolts?')

Update for Combo Box Data Card:

If(

!IsBlank(cboBoltsMissing.Selected),

cboBoltsMissing.Selected,

{Value: cboBoltsMissing.SearchText}

)

DefaultSelectedItems:Parent.Default

What I am trying to accomplish is only show the 5 choices in the drop down regardless of what the
user manually enters.

I want to keep their value saved in the sharepoint list just not show it in the drop down.
Any help is appreciated.
Tetralink 64 on at

Like (0)

Report

Combo Box in Form showing manually entered values instead of defaulted ones only

This sounds like your Combo box item property might be linked to your choice column in the SharePoint list. So when they enter new value the form picks that up. I suggest adding your choice as. Named formula.
WarrenBelz 146,618 Most Valuable Professional on at

Like (0)

Report

Combo Box in Form showing manually entered values instead of defaulted ones only

Hi lterrazas

There is a lot of information you have not included, particularly how you add the new choices to the list. As well as this information, what is the current Items of the Combo Box Items and DefaultSelectedItems and Update of the Data Card (or Patch code for it if you are doing it this way) as well as the name and type of field you are writing back to / reading from. Also is this a Classic or Modern control ?