Patching a choices OptionSet through PowerApps

(0) Share

Report

Posted on by trjackson77

254

Hi,

I developed an app where some columns in the Dataverse data source are Choices columns. I initially set up the choices options when creating the tables.

Now users are requesting that they configure Choices Optionsets (New Options, Editing Values) via a power app interface instead of running a request through me to make changes.

Is it possible to patch an optionset in Power Apps?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hi @trjackson77

I think you can do the below for the same to achieve

Patch(Table,Defaults(Table){ColumnName : Dropdown.Selected.Value})

you can refer this link

https://powerusers.microsoft.com/t5/Building-Power-Apps/Can-t-patch-OptionSet-value-to-DataVerse-table/td-p/964467#:~:text=Option%20sets%20and%20Patching%20is,comes%20is%20an%20expected%20error.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
trjackson77 254 on at

Like (0)

Report

@rampprakash, respectfully, this is not what I am asking. Your suggestion will patch the choices lookup column in the table. I want to Patch the OptionSet itself using a Canvas App. I want users to be able to configure the choices in the OptionSet without giving them access to / forcing them to use the Dataverse environment backend.
Regards,

Tim.

Was this reply helpful? Yes No
Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

@trjackson77 if your users has the necessity to modify the collection, I strongly suggest to create a custom table and change the field from a choice to a lookup.

Was this reply helpful? Yes No
trjackson77 254 on at

Like (0)

Report

@GuidoPreite just to be clear, are you saying it is not possible to modify the optionset in a canvas app?

Was this reply helpful? Yes No
Verified answer

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (1)

Report

I didn't say it's not possible. But the optionset values are considered metadata, and in order to modify them a privilege higher than the standard CRUD must be given (there are exceptions to this like is possible to add values due to excel import) but if the users needs to add/update/delete options, a custom table and a lookup makes more sense from a software architecture point of view.

Was this reply helpful? Yes No
trjackson77 254 on at

Like (0)

Report

Awesome, @GuidoPreite , thanks for the clarification. Something to think about when I'm building apps on Dataverse going forward.

Thanks again.

Tim.

Was this reply helpful? Yes No