Power Platform Community Forum Thread Details

hi expert

trying to patch the form to the sharepoint list where i wanted to copy value from one column to another colum

If(
 !IsBlank(varRec.ModifiedBy) && varRec.ActiveStatus.Value = "Active",
 UpdateIf(Forecast, EmployeeName = varRec.EmployeeName,
 {
 ApprovalStatus: "Approved",
 ActiveStatus: {Value: "Active"},
 Jan: Value(DataCardValue56.Text),//datacard value is the datacard of pending column
 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),
 
 }
 );
 Office365Outlook.SendEmailV2(
 varRec.ModifiedBy,
 "Approval for" & varRec.EmployeeName & "'shas been approved",
 "Bummer. the Recrd is compliant:<br>",
 {Cc: varUser.Email}
 ),
 varRec.ActiveStatus.Value = "Inactive",
 Patch(
 ResourceAdjustment,
 Defaults(ResourceAdjustment),
 {
 EmployeeID: varRec.'EmployeeID (EmployeeID0)',
 EmployeeName: varRec.EmployeeName,
 Role: varRec.Role,
 ResourceType: varRec.ResourceType,
 TerminationDate: varRec.TerminationDate,
 DailyHours: varRec.'Daily Hours',
 YearlyForecast: Value(varRec.YearlyForecast),
 ActiveStatus: {Value: "Inactive"}
 }
 );
 Remove(
 Forecast,
 varRec
 ),
 Set(
 varRec,
 Patch(
 Forecast,
 varRec,
 {
 ApprovalStatus: "Approved",
 ActiveStatus: {Value: "Active"}
 }
 )
 );
 Office365Outlook.SendEmailV2(
 varRec.CreatedBy,
 "Approval for" & varRec.EmployeeName & "'shas been approved",
 "Bummer. the Recrd is compliant:<br>",
 {Cc: varUser.Email}
 );
 Clear(colSelected);
 ClearCollect(
 colData,
 Forecast
 );
 ResetForm(Form1)
);
Navigate(Welcome)