Unanswered

How to auto add item into choice column in a form

(0) Share

Report

Posted on by ProtoSup

Hi everyone,

I'm working on a inventory app and I want to make adjustment on my create item form. I want to be able to create a value directly if not exist into my dropdown list field column.

For example in my choice column, selectables values are 1, 2, 3 Ans User want to create an item with choice column value = 4. How power apps can directly crte item and create choici in the choice column ?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

hey @ProtoSup

in a choice column as the name says the user can choose from choices you offer.

you could add a text input field where the user can put a value outside of the coices.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
ProtoSup on at

Like (0)

Report

Hi @mmbr1606 ,
I discover possibility directly in microsoft list interface an option to add if not exist : please see my screenshot

Sharepoint tell me "Add "NOT EXIST" "

Do you follow me ?

Was this reply helpful? Yes No
Verified answer

royg on at

Like (1)

Report
Hi @ProtoSup,
To allow the users to add items to the list of choices, as you discovered, you need to enable that in your list settings (Edit the choice field and check that option):
Then in your app, unblock the field that updates the choice column and set its Update property to:
Coalesce(DataCardValue8.Selected, {Value:DataCardValue8.SearchText})
* Replace DataCardValue8 with your combobox name.
Now if the user searches for a value that is not present in your choice list, upon update, a new choice will be appended.

Hope this helps

Was this reply helpful? Yes No
ProtoSup on at

Like (0)

Report

Thanks @royg I'm still on this problem since morning, and I also found this solution, how can i adapt my SubmitForm() to choses this formula instead of the combobox slected item ?

Thanks a lot for your nexts advices

Was this reply helpful? Yes No
Verified answer

royg on at

Like (1)

Report

Not sure why this didn't work. Did you Change the "Update" property of your DataCard as suggested?

Was this reply helpful? Yes No
ProtoSup on at

Like (0)

Report

@royg
Very good solution, works well, thank you very much !

Was this reply helpful? Yes No