Using Power Apps form to add Choice to column in SharePoint list

[user180618]

I have a Power Apps form that pulls fields from columns in a SharePoint list. The dropdowns in one of the fields is based on Choice column in the list. The column allows adding values manually. The choices relate to company names (e.g. Microsoft, Google, Apple).

What I would like to do is be able to add new companies through the form, instead of manually updating the Choice column in the list.

Ideally, when I'm filling out the searchable field in my Power Apps, I can type in the new Choice, and when the form is completed it adds that Choice to the Sharepoint column.

But I'm happy to try out a dirtier solution if that's not possible.

[TheRobRush]

If only one item get's selected from the ocmbo box for your form, turn on allow searching on the combobox and make the update property for that card something like

If(
    !IsBlank(DataCardValue3.SelectedItems),      
    {Value:DataCardValue3.SearchText},
    DataCardValue3.Selected)

If you can select multiple, it gets trickier because we have to create a collection in app first and the user would have to clear the search text if they didnt WANT it to be added becuase if they use search text to search and select a comopany that is available already, unless they click the x by search text after it does not clear itself, so you could end up with partial search text based entries that were unintentional.

alternatively to allow multiple, you could have the combo box, and a checkbox somewhere that says like, custom that opens a textbox you can use to add an entry

[user180618]

I tried that, but it does nothing when I save the form. The choice column is still blank.

Changed update property and saved:

List still doesn't show the value:

[TheRobRush]

Have you set your choice column in sharepoint to accept manual entries yet? powerapps side code is right, but if that option isnt turned on in sharepoint it will not take the values passed to it

[user180618]

I did yes. I also double checked that "Allow Fill-in choices" is set to Yes in List settings too. Still nothing.

Do I need to change anything in my Save button's properties maybe? At the moment it only has SubmitForm(Form1);NewForm(Form1) for the OnSelect action.

[TheRobRush]

Have the same working on my side, so not sure whats haplening in yours. Might try adding a new form and use same code i gave you up there and see if its same on both, sometimes forms just break when stuff has been changed and a readd will fix.

[negr0re]

As the formula is not blank, the "true" and "false" values should be switched, otherwise if you fill in a non existing value the formula goes to "DataCardValue3.Selected", so it does nothing.

Solution is to remove the "!" before the IsBlank() function. In that way the formula works just fine and add the "DataCardValue3.SearchText" to the available choices of the Sharepoint List's choice column.

So this is the right formula:

If(
    IsBlank(DataCardValue3.SelectedItems),      
    {Value:DataCardValue3.SearchText},
    DataCardValue3.Selected)

[PejuangPower]

If(
!IsBlank(DataCardValue12.Selected),
DataCardValue12.Selected,
If(
!IsBlank(DataCardValue12.SearchText),
{
Value: DataCardValue12.SearchText,
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
},
Blank()
)
)

[MELS12]

Hi hope you going well, 

@user180618  you can try this :

1 - Be sure to set the column in your sharepoint list is set to accept manually new choice.

2 - Go to your update proprety of your datacard  and type : 

If(datacardvalue.Selected.Value=Blank(),{Value:datacardvalue.SearchText},{Value:datacardvalue.Selected.Value})

Best regards,

[domino_kart]

Hello @user180618 , if this thread might help you !

Add multiple values manually into Sharepoint multi-choice column using SharePoint Form Power App
https://powerusers.microsoft.com/t5/Building-Power-Apps/Solution-Add-multiple-values-manually-into-S...