Saving manually added text to choice field to sharepoint column

[kuglarz96]

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

[v-xida-msft · Accepted solution]

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:

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:

Best regards,

[kuglarz96]

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

[KZK]

Hello,

I tried this but the option doesn't show up on my end:

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

When I save it and then come back to the form I don't see the option in the field and don't see the option in the dropdown list as well. My choice field is multi-select. Could that be the reason? If it is then how do I add a value manually to a multi-select choice field from powerapps?

Thanks

KP