Update SharePoint Choice Colum with Text Input

Like (0) Share

Report

Posted on 8 Jul 2022 14:01:46 by mssa12345

111

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.

Categories:

General Questions

All responses (20)

Answers (1)

kmw1130 948 on 06 Nov 2024 at 21:26:22

Like (0)

Report

Update SharePoint Choice Colum with Text Input

I have a similar scenario, except for dropdown choices, I have checkboxes. If one particular checkbox is checked (true) I want the user to enter text into a input text box.

Currently this is my code for the default of the check box(s):

For this particular checkbox, if it is checked then I want the user to fill in the input text box.

For the Card Update code:

Not sure what the default of the input text box should be and if I concatenate it with the chkboxHybrid?
RandyHayes 76,287 Super User 2024 Season 1 on 08 Jul 2022 at 17:32:01

Like (0)

Report

Re: Update SharePoint Choice Colum with Text Input

@mssa12345

Excellent! Happy to help.
mssa12345 111 on 08 Jul 2022 at 17:28:30

Like (1)

Report

Re: Update SharePoint Choice Colum with Text Input

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

RandyHayes 76,287 Super User 2024 Season 1 on 08 Jul 2022 at 17:16:54

Like (1)

Report

Re: Update SharePoint Choice Colum with Text Input

@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 111 on 08 Jul 2022 at 17:02:50

Like (0)

Report

Re: Update SharePoint Choice Colum with Text Input

I removed the requesttype datacard and readded it, now the list shows the correct value.
So should i add the other logic now ?
RandyHayes 76,287 Super User 2024 Season 1 on 08 Jul 2022 at 16:56:00

Like (0)

Report

Re: Update SharePoint Choice Colum with Text Input

@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 111 on 08 Jul 2022 at 16:49:50

Like (0)

Report

Re: Update SharePoint Choice Colum with Text Input

Yes CW is one of the option. Image below is setting for request type column.
RandyHayes 76,287 Super User 2024 Season 1 on 08 Jul 2022 at 16:47:52

Like (0)

Report

Re: Update SharePoint Choice Colum with Text Input

@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 111 on 08 Jul 2022 at 16:44:58

Like (0)

Report

Re: Update SharePoint Choice Colum with Text Input

I changed the update property to {Value: "CW"}, still same.
RandyHayes 76,287 Super User 2024 Season 1 on 08 Jul 2022 at 16:40:06

Like (0)

Report

Re: Update SharePoint Choice Colum with Text Input

@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.