Answered

Will Patch Update ONLY the Item Associated with the 'ID"

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I need this Patch to update the fields within it for ONLY the Member and CQTitle associated with Defaults(MemberCertsandQualsList.ID). I am pulling the 'ID' from the SP list MemberCertsandQualsList.

Will the below do what I desire, and not update any other items on the list.

Patch(MemberCertsandQualsList,

Defaults(MemberCertsandQualsList.ID),

{DteofCQ:Value(UpdateCQDateofAwardFld.Text), CQYr:Value(UpdateCQStandardYearFld.Text), CertBody:UpdateCertifyingBodyFld.Text, CQTitle:UpdateCQTitleFld.Text, CertNo:Value(UpdateCertNumberFld.Text), ClassNumber:Value(UpdateClassNumberFld.Text), ClassStartDate:Value(UpdateCQClassStartDateFld.Text), ClassEndDate:Value(UpdateCQClassEndDateFld.Text), AcrdtnAgncy:EditAccredingAgencyDropdown.Selected.Value, Rcprcty:EditReciprocityDropdown.Selected.Value});

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Your syntax is incorrect for the Defaults function. Defaults is used to specify a New record for a list. There is no ID associated with it and will be blank in your scenario.

When you use Patch, you specify the datasource, the record and the column values (as a record).

I am not sure exactly what you are trying to do from your description as you reference Defaults(MemberCertsandQualsList.ID), which is not valid.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The data is from an update form (really a Gallery).

The user changes whatever needs to be updated of the default information (from the MemberCertsandQaulsList based on varIsUpdateMemberRecord, which has all the data for the fields, again from the MemberCertsandQaulsList.

I am trying to Patch back (overwrite to the same item on the same list the changes above, only overwriting those fields shown in the Patch.

Is this more apppropriate:

Patch(MemberCertsandQualsList,
Lookup(MemberCertsandQualsList,MemberCertsandQualsList.UpdateFormItemIDNo.Text),

With the contents of UpdateFormItemIDNo.Text (in the Update Gallery) being the ID of the item in
MemberCertsandQualsList?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Since you already have the ID in the list, you can utilize the following instead:

UpdateIf(MemberCertsandQualsList, ID=varIsUpdateMemberRecord.ID, {...the columns you want to update})

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Crying early...

I don't have a varIsUpdateMemberRecord. Should I create one? I do have a varEditCertQualRecord; is it the source that populates the Gallery (and has the 'ID'.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

A little confused...you said:

"based on varIsUpdateMemberRecord, which has all the data for the fields,"

So what was that?

Also, you will not be patching and updating...get rid of the Patch part of that formula, the first line.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I must have misspoken somewhere. The variable is varIsUpdateMemberRecord. I took out the Patch part and the error went away.

Was this reply helpful? Yes No