Answered

Saving manually added text to choice field to sharepoint column

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xida-msft on at

Like (0)

Report
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,

Was this reply helpful? Yes No
kuglarz96 38 on at

Like (0)

Report

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

Was this reply helpful? Yes No
KZK 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No