Answered

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:

Connecting to Data

Mobile App

Using Apps Using Formulas

General Questions

All responses (6)

Answers (2)

ProtoSup on at

Like (0)

Report

Re: How to auto add item into choice column in a form

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

royg on at

Like (1)

Report

Re: How to auto add item into choice column in a form

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

Like (0)

Report

Re: How to auto add item into choice column in a form

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
Verified answer

royg on at

Like (1)

Report
Re: How to auto add item into choice column in a form

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
ProtoSup on at

Like (0)

Report

Re: How to auto add item into choice column in a form

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 ?
mmbr1606 12,108 Super User 2025 Season 1 on at

Like (1)

Report

Re: How to auto add item into choice column in a form

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