Choice column - add value manually

(0) Share

Report

Posted on by lidor_dayan

192

Hi all, I have an integrated app with SharePoint list.

I added a new choice column with the feature "can add values manually" from SharePoint to the list and added it in the app but when I tested it in the app I can only choose and not able to enter manually when I enter value manually it is not being saved.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Verified answer

WarrenBelz 154,757 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @lidor_dayan ,

You need to do this in Power Apps - if you are using a Combo Box (I will call it cbChoices below for example), the Update of the Data Card would be

{ Value: Coalesce( cbChoices.SearchText, cbChoices.Selected.Value ) }

Ensure Allow Searching is turned on and this uses anything typed in without a selection being made to be used to update the field.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
lidor_dayan 192 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz
I didn't understand what to put instead of "cbChoices" - the data card of the combo box "DataCardValue15"?
thank you for your help!

Was this reply helpful? Yes No
WarrenBelz 154,757 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@lidor_dayan ,

Yes - the name of the Combo Box

Was this reply helpful? Yes No
lidor_dayan 192 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz, I can't leave it blank after I'm putting any value.
I'm trying to erase the value I wrote and click save but it is not delete the value.

Was this reply helpful? Yes No
WarrenBelz 154,757 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@lidor_dayan ,

Turn on Formula Level Error Management in your Advanced settings.

Was this reply helpful? Yes No
lidor_dayan 192 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz,
It was on.

Was this reply helpful? Yes No
WarrenBelz 154,757 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@lidor_dayan ,

Are you saying you clear the contents of the Combo Box, save the record and the value in the data source does not update to blank ? If so, what is the Update of the Data Card and how to you save the record ?

Was this reply helpful? Yes No
lidor_dayan 192 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz,
the Update of the Data Card is:
{Value:Coalesce(DataCardValue15.SearchText,DataCardValue15.Selected.Value)}

I didn't understood the second question

Was this reply helpful? Yes No
WarrenBelz 154,757 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@lidor_dayan ,

OK I have eliminated all the things I thought may be wrong - if the Update is (as you posted)

{ Value: Coalesce( DataCardValue15.SearchText, DataCardValue15.Selected.Value ) }

and you have cleared the selected item from the Combo Box and have nothing in the Search Text (as well as having Formula Level Error Management turned on) and you are (I assume) using SubmitForm to save the record, then it certainly should clear the field in the data source. I have a feeling however you may have found a bug here - to test, put this in the Update and see if it clears the field

DataCardValue15.Selected

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
lidor_dayan 192 on at

Like (0)

Report
Copy link

Link copied!

It is clear the field but need to change the Update again for adding new manually value.

Was this reply helpful? Yes No