Unanswered

Copy value from one column to another column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

hi Experts,

i have following code to patch the record from pending column in sharepoint list. but when i approve it wont save the record but keep the record in the pending column.

below all data card is from the pending. so i was patching monthly actual column with the value of pending column

If(
 !IsBlank(varRecord.ModifiedBy) && varRecord.ActiveStatus.Value = "Active",
 Set(
 varRecord,
 Patch(
 Forecast,
 varRecord,
 {
 ApprovalStatus: "Approved",
 ActiveStatus: {Value: "Active"},
 Jan:Value(DataCardValue56.Text),//DatacardValue56 is the data card value of Jan pending 
 Feb:Value(DataCardValue60.Text),
 March:Value(DataCardValue61.Text),
 April:Value(DataCardValue62.Text),
 May:Value(DataCardValue63.Text),
 June:Value(DataCardValue64.Text),
 July:Value(DataCardValue65.Text),
 Aug:Value(DataCardValue66.Text),
 Sep:Value(DataCardValue67.Text),
 Oct:Value(DataCardValue68.Text),
 Nov:Value(DataCardValue70.Text),
 Dec:Value(DataCardValue71.Text),
 



 ModifiedBy: User().Email
 }
 )
 );

the main purpose of this was to simply copy the value frm pendig to actuals

please advise

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Most likely it is not doing anything because you are trying to set the Modified By column. That is a read only column in SharePoint. So your Patch is most likely failing.

Also, it appears that this is a Form...why a Patch? You should be using SubmitForm on your form.

I hope this is helpful for you.

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

Like
a
(0)

Report
Copy link

Link copied!

hi

i have follwoing scenario>

the app is basically updating monthly hours by PMS for all FTE.

so when they edit the existing list than for the record is saved to Jan pending. only after approval the jan pending data is transfered to the Jan colmn.

now coming to you question patch.

if we submit the form than the existing record will be replaced with the new one. so

i saved the form to var record

Screen Editform:

when i submit the form

the record is saved to pending so that existing record wont get modified unless approved.

now in approval screen approver will approve after reviewing so, whenver record is modified than the column modified by will get updated by the user who requested the update for the record.

now in approval screen any

in approval screen this record only get patched to the Month column from pending column if it gets approved.

there is no error and my record is not patching... thats the issue

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

So still...you are (were) trying to patch the ModifiedBy column. You cannot alter that column in your formula!

As for the rest, I would strongly recommend using your form to do the logic you are showing rather than trying to do it all through a Patch...it's just more work that you don't need to do.

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

Like
a
(0)

Report
Copy link

Link copied!
i created another column modifiedbyemail and tried . but still the same output

If( !IsBlank(varRecord.Modifiedbyemail) && varRecord.ActiveStatus.Value = "Active", Set( varRecord, Patch( Forecast, varRecord, { ApprovalStatus: "Approved", ActiveStatus: {Value: "Active"}, Jan:Value(DataCardValue56.Text), Feb:Value(DataCardValue60.Text), March:Value(DataCardValue61.Text), April:Value(DataCardValue62.Text), May:Value(DataCardValue63.Text), June:Value(DataCardValue64.Text), July:Value(DataCardValue65.Text), Aug:Value(DataCardValue66.Text), Sep:Value(DataCardValue67.Text), Oct:Value(DataCardValue68.Text), Nov:Value(DataCardValue70.Text), Dec:Value(DataCardValue71.Text), Modifiedbyemail: User().Email } ) ); Office365Outlook.SendEmailV2( varRecord.Modifiedbyemail, "Approval for" & varRecord.EmployeeName & "'shas been approved", "Bummer. the Recrd is compliant:<br>", {Cc: varUser.Email} ), varRecord.ActiveStatus.Value = "Inactive", Patch( ResourceAdjustment, Defaults(ResourceAdjustment), { EmployeeID: varRecord.'EmployeeID (EmployeeID0)', EmployeeName: varRecord.EmployeeName, Role: varRecord.Role, ResourceType: varRecord.ResourceType, TerminationDate: varRecord.TerminationDate, DailyHours: varRecord.'Daily Hours', YearlyForecast: Value(varRecord.YearlyForecast), ActiveStatus: {Value: "Inactive"} } ); Remove( Forecast, varRecord ), Set( varRecord, Patch( Forecast, varRecord, { ApprovalStatus: "Approved", ActiveStatus: {Value: "Active"} } ) ); Office365Outlook.SendEmailV2( varRecord.CreatedBy, "Approval for" & varRecord.EmployeeName & "'shas been approved", "Bummer. the Recrd is compliant:<br>", {Cc: varUser.Email} ); Clear(colSelected); ClearCollect( colData, Forecast ); ResetForm(Form1) );

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

It's hard to tell by just looking at that extremely long formula. I would suggest using the monitor tool to determine exactly what is or is not happening in the formula.

But still, this would be much easier by just put it in your form and using a SubmitForm to do the submitting.

You could certainly do what you are mentioning quite easily in the Update properties of your datacards.

Was this reply helpful? Yes No