Power Platform Community Forum Thread Details

I'm trying to save dropdown items to a SharePoint list using PowerApps, but while Business Unit and ReceptionPlace are saved, the other three don't save properly even when I click the save button.



    Set(
        gblClaimRec,
        Patch(
            ClaimMaster,
            Defaults(ClaimMaster),
            {
                'Business Unit': {
                    Value: Dropdown1.Selected.Value
                },
                'ReceptionPlace': {
                    Value: Dropdown2.Selected.Value
                },
                'ComplaintCategory': {
                    Value: Dropdown3.Selected.Value
                },
                'RequestedInvoiceProcess': {
                    Value: Dropdown4.Selected.Value
                },
                'InitialResponse': {
                    Value: Dropdown5.Selected.Value
                },
            }
        )
    );

Apps2.png

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building Power Apps

Hi @TY-16030359-0,

Your Patch formula looks correct, and since Business Unit and ReceptionPlace are saving properly, the issue is not with the Patch function itself. This behavior usually occurs due to a mismatch between the SharePoint column type and the value being passed from Power Apps.

What’s likely happening

The fields that are working are most likely single-choice columns, which accept values in this format:

{ Value: Dropdown.Selected.Value }

However, the other fields (ComplaintCategory, RequestedInvoiceProcess, InitialResponse) are likely configured differently in SharePoint.

What to check

Please verify the column types in your SharePoint list for these fields. Depending on their type, the Patch structure needs to be adjusted.

Fix based on column type

Single Choice column
{ Value: Dropdown.Selected.Value }
Single line of text
Dropdown.Selected.Value
Multi-select Choice column
Dropdown.SelectedItems
Lookup column
{
Id: Dropdown.Selected.ID,
Value: Dropdown.Selected.Value
}

Helpful Debug Tip

To confirm what your dropdown is returning, you can temporarily use:

JSON(Dropdown3.Selected)

This helps identify whether the correct property is .Value, .Result, or .Title.

Summary

Your implementation is correct, but Power Apps requires the data format to match the SharePoint column type exactly. Once the correct structure is applied for each field, all values should save successfully.

If this resolves your issue, please consider marking the answer as accepted and giving it a like. It helps others facing similar problems and contributes to the community. Thanks!