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

Like (0) Share

Report

Posted on 24 Nov 2024 14:36:56 by sasrsc

658

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:

General Questions

All responses (2)

Answers (0)

ronaldwalcott 3,653 on 24 Nov 2024 at 17:16:41

Like (0)

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

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.
timl 35,109 Super User 2025 Season 1 on 24 Nov 2024 at 16:00:42

Like (0)

Report

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

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/