Skip to main content

Notifications

Community site session details

Community site session details

Session Id : pkXrl7Ut7GM4CZDsVCUKs4
Power Apps - Building Power Apps
Answered

Update SharePoint Choice Colum with Text Input

Like (0) ShareShare
ReportReport
Posted on 8 Jul 2022 14:01:46 by 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:
  • kmw1130 Profile Picture
    936 on 06 Nov 2024 at 21:26:22
    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 Profile Picture
    76,287 Super User 2024 Season 1 on 08 Jul 2022 at 17:32:01
    Re: Update SharePoint Choice Colum with Text Input

    @mssa12345 

    Excellent! Happy to help.

  • mssa12345 Profile Picture
    111 on 08 Jul 2022 at 17:28:30
    Re: Update SharePoint Choice Colum with Text Input

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

  • Verified answer
    RandyHayes Profile Picture
    76,287 Super User 2024 Season 1 on 08 Jul 2022 at 17:16:54
    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 Profile Picture
    111 on 08 Jul 2022 at 17:02:50
    Re: Update SharePoint Choice Colum with Text Input

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

    So should i add the other logic now ?

  • RandyHayes Profile Picture
    76,287 Super User 2024 Season 1 on 08 Jul 2022 at 16:56:00
    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 Profile Picture
    111 on 08 Jul 2022 at 16:49:50
    Re: Update SharePoint Choice Colum with Text Input

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

    column.PNG

  • RandyHayes Profile Picture
    76,287 Super User 2024 Season 1 on 08 Jul 2022 at 16:47:52
    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 Profile Picture
    111 on 08 Jul 2022 at 16:44:58
    Re: Update SharePoint Choice Colum with Text Input

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

  • RandyHayes Profile Picture
    76,287 Super User 2024 Season 1 on 08 Jul 2022 at 16:40:06
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,763 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard