Patch dropdown not working

(0) Share

Report

Posted on by DDM

Hi All,

I am struggling to get patch function to work. Code below is not patching

Please can you help.

Thanks

Patch(

'Archive',

LookUp(

'Archive',

ID = varItemID

{

ContractOwner: cbxContractOwnerView.Selected,

Company: cbxCompanyView.Selected,

BusinessFunction: cbxBusinessFunctionView.Selected

}

);

Categories:

General Questions

All responses (4)

Answers (1)

Verified answer

DDM 79 on at

Like (1)

Report

Re: Patch dropdown not working

Hi Anand,

I figured it out. It was my varItemID.

It was a text value not a number. To change to number i did following:

Set(varListItemID, Value(varItemID));

Patch(
'Archive',
{ID: varListItemID},
{
ContractOwner: cbxContractOwnerView.Selected,
Company: {Value: cbxCompanyView.Selected.Value},
BusinessFunction: {Value: cbxBusinessFunctionView.Selected.Value},
Site: {Value: cbxSiteView.Selected.Value},
Country: {Value: cbxCountryView.Selected.Value},
DocumentSubject: txtDocumentSubjectView.Text,
DocumentDescription: txtDocumentDescriptionView.Text,
ContractDescription: txtDocumentDescriptionView.Text
}
)

Thanks for you help.
anandm08 1,936 Super User 2025 Season 1 on at

Like (0)

Report
Re: Patch dropdown not working

Patch( 'Archive', LookUp( 'Archive', ID = varItemID ), { ContractOwner: { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership| User().Email", Department: "", DisplayName: User().DisplayName, Email: User().Email, JobTitle: "", Picture: "" }, Company: cbxCompanyView.Selected.Value, BusinessFunction: cbxBusinessFunctionView.Selected.Value } );

try this.

Please click Accept as solution 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 giving it Thumbs Up.
DDM 79 on at

Like (0)

Report

Re: Patch dropdown not working

Hello,

Thanks for responding, i tried that but it returns an error.
anandm08 1,936 Super User 2025 Season 1 on at

Like (0)

Report
Re: Patch dropdown not working

Try this
Patch( 'Archive', LookUp( 'Archive', ID = varItemID ), { ContractOwner: cbxContractOwnerView.Selected.Value, Company: cbxCompanyView.Selected.Value, BusinessFunction: cbxBusinessFunctionView.Selected.Value } );