Power Apps

Patch not saving when I use Choice columns

(1) Share

Report

Posted on by S S

166 Season of Giving Solutions 2025

Hello,

I tried different ways (cmbx, dropdown-modern and legacy) and my choice columns are not saving

datasource = 'Premium License Tracker'

Text column = Lastname This saves.

Text column = Firstname This saves

Control used Text Input

Column name Organization

Control used Dropdown

Save button

Onselect =

Patch(
    'Premium License Tracker', 
    LookUp(
        'Premium License Tracker',
        ID=ThisItem.ID
    ),
    {
        LastName:TextInputLastName.Text, 
        FirstName:TextInputFirstName.Text, 
        Organization:Dropdown1.Selected
 
}
)
 
also tried cmbx
 
Onselect = 
Patch(
    'Premium License Tracker', 
    LookUp(
        'Premium License Tracker',
        ID=ThisItem.ID
    ),
    {
        LastName:TextInputLastName.Text, 
        FirstName:TextInputFirstName.Text, 
        Organization: Combobox1.Selected
}
)
 
 
Also tried moderndropdown.... still no joy
 
Here is my tree view
 
Appreciate any suggestions
 

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Kalathiya 2,013 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @S S,

Is the Organization column in SharePoint a Choice type column?

If yes, then try below approach (Choice type column (Organization) in SharePoint),

Patch('Premium License Tracker', LookUp('Premium License Tracker', ID = ThisItem.ID), { LastName:TextInputLastName.Text, FirstName: TextInputFirstName.Text, Organization:{Value:Combobox1.Selected.Value} //If you are using Dropdown then we need to replace with Combobox1 } );

If Organization column type is single line of text in SharePoint then try below

Patch('Premium License Tracker', LookUp('Premium License Tracker', ID = ThisItem.ID), { LastName:TextInputLastName.Text, FirstName: TextInputFirstName.Text, Organization:Combobox1.Selected.Value //If you are using Dropdown then we need to replace with Combobox1 } );

Please let me if you are still facing any issues.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

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

Like (0)

Report
Copy link

Link copied!

Hi @kalathiya,

I tried but it still didn't work.

Organization is a SharePoint choice column.

Patch(

'Premium License Tracker',

LookUp(

'Premium License Tracker',

ID=ThisItem.ID

),

{

LastName:TextInputLastName.Text,

FirstName:TextInputFirstName.Text,

Organization:{Value:Combobox1.Selected.Value}

})

I verified the field name is Organization

and that Combobox1 what I used for Organization. Do you see anything that I may have missed?

This is what I used (below) on another app and it worked. I tried to do the same here and it doesn't work. I tried your solution and it wasn't working. I think something changed in Power FX.

Was this reply helpful? Yes No
Kalathiya 2,013 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @S S,

Could you please confirm this organization column type is multiple select in SharePoint?

Try below code:

Patch('Premium License Tracker', LookUp('Premium License Tracker', ID = ThisItem.ID), { LastName:TextInputLastName.Text, FirstName: TextInputFirstName.Text, Organization:Combobox1.SelectedItems } );

Dropdown control will not work correctly for a SharePoint multi-select Choice column because Dropdown supports only single selection so combobox if it's multiple select column.

Please share the error screenshot as well if you are still getting any error.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

Like (0)

Report
Copy link

Link copied!

@Kalathiya

I changed the Organization to multi select then for Organization in Power Apps I changed it to allow multi select

and on the SPO list it saved however on the Power App the Organization value did not appear. Here I selected USASOC as the organization Then when I click Save, the Organization field goes blank (it says "Find Items") but on the SharePoint list the value USASOC appears in the Organization field

My end user won't be going on the SPO list. They would need to see their Organization appear on the Power App. Not sure why the Org

value disappears in the Power App. Its getting closer :-)

Was this reply helpful? Yes No
Kalathiya 2,013 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @S S,

Great, Patch is working.

Quick questions:

#1.Where are you showing this Organization ComboBox?
- Inside a Gallery?
- Inside an Edit Form?
- Directly on the Screen?

#2. How have you configured the ComboBox default property?
- DefaultSelectedItems of the combobox control.

If the ComboBox is inside a Gallery, then set:

DefaultSelectedItems = ThisItem.Organization

If the ComboBox is inside a Form control, then set:

DefaultSelectedItems = Parent.Default

If this is an individual ComboBox control outside the form and you are using manual form design with a variable/record, then use something like:

DefaultSelectedItems = yourVariableName.Organization //yourVariableName - Replace this with your variable name

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No