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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

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

Was this reply helpful? Yes No
DDM 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Thanks for responding, i tried that but it returns an error.

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Verified answer

DDM 79 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No