Unanswered

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

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
user180618 86 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
user180618 86 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
negr0re 33 on at

Like (2)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No
PejuangPower 5 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MELS12 19 on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
domino_kart 56 on at

Like (0)

Report
Copy link

Link copied!

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-Sharepoint-multi/td-p/2614067

Was this reply helpful? Yes No