Manually add custom choice to sharepoint column from power apps

(1) Share

Report

Posted on by Mongi

Hello guys, I wanna create a new interface in my power apps app where i can be able to add custom choices for my choice columns in sharepoint without going to sharepoint I tried doing it with a textinput and a button like that : Patch ( DataSource, Defaults( DataSource), { Column : Concatenate(Choices(DataSource.Column),";",TextInput2.Text) } ) But It's not working like that because of invalid argument types "text" and "record"

Anyone can help me please ? And thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi Mongi

If I am reading this properly, you simply want the hard-code additional choices in your drop-down ? Is this what you are trying to do ?
Table( {Value: "Your extra choice"}, Choices(ListName.FieldName) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

HI,

I simply want to add a small detail, as Warren is correct as usual :-)

There is a difference between actually adding a new choice to the list, so that later users can select that

and

Allow them to Type in something for whatever ROW that person is creating at the MOMENT. But other users won't see it as an option going forward to add it for themselves.

Example: Warren wants to add Option 3333

He wants it to be part of what he selected (as a string) value stored for his record.

Then there is

Michael is an Admin, and he wants to create a NEW option so that others can select it later on

OR

Michael is a user, and when he adds a new one, the add should ADD it to the Option list as a new one.

So the second/3rd at the same, just a different reason for doing it.

But 1 & 2/3 are different

Thats why Warren is asking if he is answering what you need. I thought you wanted to ADD a new option, permanently for others to use.

Since Warren and I usually read them the same and don't normally answer on the same thread, I just wanted to be sure as it could just be me and my confusion.

P.S. Warren have a great weekend. :-) New gigs starting soon.. We should work together sometime.

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

Like (1)

Report
Copy link

Link copied!
Thanks Mike,
There are actually three possibilities here - I went for the simplest one first in case that was the one required.
The second option would involve the user adding a value not in the list but not saving this to the future choices. The Items can be the normal Choices(), with Search enabled and the Update of the DataCard
Coalesce( ComboBoxName.SearchText, ComboBoxName.Selected.Value )

So the user could type a value in without selecting anything and that value would be saved in the data source.

The one you mention would need a reference list maintained for all the choices - the Items of the Combo Box would be
Sort( ReferenceList, FieldName ).FieldName

and would require a Patch before submitting the form (so save the value for future use)
If( Len(ComboBox.SearchText) > 0 && IsBlank( LookUp( ReferenceList, FieldName = ComboBoxName.SearchText ).FieldName ), Patch( ReferenceList, Defaults(ReferenceList), {FieldName: ComboBox.SearchText} ) )

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (2)

Report
Copy link

Link copied!

Yeah totally Warren, I was posting to the Author not to you and which choice you made hehe, just that I thought it was a different ask

Was this reply helpful? Yes No