Unanswered

Add another choice to an existing list of choices - Dataverse Choice Column

(0) Share

Report

Posted on by sasrsc

678

I had assumed I could create the typical classic gallery in my Canvas Power App and display the option set (done), then I assumed I could add a button for New Option and have a text input field to add a new value to my list of option choices... I'm stuck on the patch statement ...

I'm trying to create the UI where the team users can add to the choices. I realize I can go into DV and manually add another option.

Patch(OptionsRoomOccupancy,Defaults(OptionsRoomOccupancy),{

 /* how to patch */


})

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi sasrsc

It's not possible to create a new Dataverse choice item from formula, or by calling Patch.

I'd suggest that you add related table and lookup instead, which would give more flexibility (eg, in the related table, you can 'soft delete' items/mark items as inactive, more easily change the description of existing choice items).

If you actually do want to create a new choice item from Power Apps, you can do so by calling a Flow, as described here.

https://www.powercommunity.com/create-new-dataverse-choices-option-sets-from-canvas-apps/

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report
You should make a practice of only using Choice for fixed items where they are predetermined options being part of your business rules.

Example Use Cases:

Yes/No Fields: Simple binary choices, such as confirming whether a task is completed.

Status Fields: Tracking the progress of tasks or projects with statuses like New, Open, In Progress, and Closed.

Category Fields: Categorizing data into predefined groups such as High, Medium, and Low priority.

Was this reply helpful? Yes No