Update SharePoint Choice Colum with Text Input

[mssa12345]

Hello All-

I have a SPO List, in which one of the column is choice and allows fill in choices. There are 5 choices and out of those 5 choices one of them is other, if a user selects other a text input box appears to input text in my canvas  app. However the SPO list only shows Other and not the txt that was input. Can you please advise on how i can update the list column with that typed txt when the Selection is other ?

Thank you for your help.

[mssa12345]

No it does not, i just checked it.

[RandyHayes]

@mssa12345 

Okay, we need to figure out then if the form is not working properly for the column or if something else is going on.

So, to troubleshoot only, change your Update property on the datacard to:

{Value: "existingValueHere"}

And just change the exisdtingValueHere to a value that you already HAVE defined in your choices column.

Try again and see if the list item then has that value.

[mssa12345]

I changed the update property to {Value: "CW"}, still same.

[RandyHayes]

@mssa12345 

If CW is one of your choices then there is something else going wrong.

Let's dig a little deeper...

First, what is the definition of your Choice column?  I know that it is set to allow write-ins, but is it set to allow multiple selections?

[mssa12345]

Yes CW is one of the option. Image below is setting for request type column.

[RandyHayes]

@mssa12345 

Then there has been something gone wrong with the datacard.

Have you made any adjustments to the column in your list since the point at which you added the column to your form?  If so, this confuses the form and it sticks with it.

I would start by removing the datacard/field from your form and then add it back in.

This will give you a datacard that will just have the dropdown/combobox in it and it will be all ready to go.  So, add that field back in and then select a choice from the dropdown and then submit the form...does it THEN show the correct value in the list item?

It should, and if so, then we can add back in the logic for the Other choice again.

[mssa12345]

I removed the requesttype datacard and readded it, now the list shows the correct value.

So should i add the other logic now ?

[RandyHayes · Accepted solution]

@mssa12345 

Yes! Perfect...it is working properly now.

So add your TextInput back in and change the Update property to what I provided and things should start looking up!

[mssa12345]

Thank you for your help, it is working as intended .

[RandyHayes]

@mssa12345 

Excellent! Happy to help.