Patch not saving changes for Choice columns

(0) Share

Report

Posted on by S S

224 Season of Giving Solutions 2025

Hello,

For some reason Patch doesn't save the choice columns. This what I have for the

Save button OnSelect =

Patch(
    PA, 
    LookUp(
        PA,
        ID=ThisItem.ID
    ),
    {Title:TextInput3.Text, 
    ChoiceCol:Combobox3.Selected
             })
 
This is my tree view 
 
Note I replicated my app and stripped out the other stuff so that the  focus could be on what's broken.  Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (3)

Sort by

Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @S S,

I assume you are using SharePoint here. It depends on the Items and DisplayFields of ComboBox3 and also if ChoiceCol and ComboBox3 are a single or multiple value. You also did not say if you were getting an error or if it simply did not work. The pattern you need for a single selection/value is (using your DisplayFields property without quotes)
ChoiceCol: {Value: Combobox3.Selected.YourDisplayFields}

I suspect that it is not Value, otherwise what you have would work.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
S S 224 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

Hi Warren,

This is what I have on the real app. I made the changes that you recommended. I didn't get an error message. It just didn't work. It is single select.

I didn't get any error messages after I put in your recommendation but it still didn't save. Did I do it wrong? My display field is Category. Should I put Category at the end after selected? When I do I get this

Sharon

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @S S,

Can you please post the Items of the Combo Box and a screenshot of the DisplayFields

Also confirm that both the Category field and the Combo Box are single value only.

Was this reply helpful? Yes No
S S 224 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

Here is the Items property for the combobox

I don't have Display fields property. This is what I have. Will this do?

Category column

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @S S,

OK I see now - a Modern Combo Box (DisplayFields are in the Classic control). Firstly ensure DisplayMultiple is false (on the Combo Box), and if so, what I posted should technically work (there is really nothing else you can send), however I am having the same issues here in testing.

If you really want to fix this properly, use a Classic Combo Box and either what you had originally or what I posted will work.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
S S 224 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

I used a classic combobox and used in Save OnSelect for the classic combobox as you recommended

Category:{Value:ComboBoxCategoryClassic.Selected.Value}

IT WORKED!! THANK YOU SO MUCH!!

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @S S,

Just adding, this has to be a bug, so did some more testing and got it working on a Modern control with
With( {_Data: Combobox3.Selected.Value}, Patch( PA, { ID: ThisItem.ID, Title: TextInput3.Text, ChoiceCol: {Value: _Data} } ) )

Effectively grabbing the Combo Box selected value first as a temporary variable then using that in the Patch.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
S S 224 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

This is great! I always prefer to modern controls. Thank you for posting this update :-)

Was this reply helpful? Yes No