cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kuglarz96
Level: Powered On

Saving manually added text to choice field to sharepoint column

Hi,

 

I'm making custom form in powerapps. I have made column Role1, type choice in sharepoint list with option to add values manually. When I submit form with enable choices everything save and work, but when I enter value manually, I lost data after submit. Do you know how to fix this ?

 

Formula on my Role1 dropdown (DataCardValue14):

Default: Parent.Default
Items: Choices(SharepointListName.Role1)

Formula on my Role1_DataCard:

Default: ThisItem.Role1
Update: DataCardValue14.Selected

I tried to change "Update" to DataCardValue14.Selected.Value but it expects Record, not Text values.

 

Thank you in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Saving manually added text to choice field to sharepoint column

Hi @kuglarz96 ,

Could you please share a bit more about your scenario?

Do you also want to save the manually typed text within the Role1 ComboBox into the Role1 Choice type column in your SP List?

 

I have made a test on my side, please take a try with the following workaround:3.JPG

Unlock the Status data card in your Edit form, set the Update property of the Status Data card to following:

If(
    !IsBlank(DataCardValue3.SearchText),             /* <-- DataCardValue3 represents the ComboBox within the Status Data card in my Edit form */
    {
        Value: DataCardValue3.SearchText
    },
    DataCardValue3.Selected
)

On your side, you should modify formula within the Update property of the Role1 Data card to following:

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

Please check the following GIF screenshot for more details:Test.gif

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Saving manually added text to choice field to sharepoint column

Hi @kuglarz96 ,

Could you please share a bit more about your scenario?

Do you also want to save the manually typed text within the Role1 ComboBox into the Role1 Choice type column in your SP List?

 

I have made a test on my side, please take a try with the following workaround:3.JPG

Unlock the Status data card in your Edit form, set the Update property of the Status Data card to following:

If(
    !IsBlank(DataCardValue3.SearchText),             /* <-- DataCardValue3 represents the ComboBox within the Status Data card in my Edit form */
    {
        Value: DataCardValue3.SearchText
    },
    DataCardValue3.Selected
)

On your side, you should modify formula within the Update property of the Role1 Data card to following:

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

Please check the following GIF screenshot for more details:Test.gif

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

kuglarz96
Level: Powered On

Re: Saving manually added text to choice field to sharepoint column

Worked like a charm, thank you very much, i really appreciate your profesional help

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 359 members 5,892 guests
Please welcome our newest community members: