Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Lisa White]

I have a Power App that uses parent and child SharePoint lists.

In the child list (CRSP-Workflow), there is a Status drop-down field. If the user selects “Complete,” I need to update the Completion Date field in the parent list (CRSP-Main), which is a DateTime column in the SharePoint list.

Here’s what I’ve tried.

In child list form (frmWorkflow):

• Dropdown is NewStatus (DataCardValue28).
• In OnChange property of DataCardValue28, I want it to set variable only if the user selects Complete. Otherwise, do nothing. I have tried all of these:
  • If(“Complete” in DataCardValue28.SelectedItems.Value, Set(varCompletionDate, (Now())))
  • If(“Complete” in DataCardValue28.SelectedItems.Value, Set(varCompletionDate, Text((Now()))))
  • If(“Complete” in DataCardValue28.SelectedItems.Value, Set(varCompletionDate, DateTimeValue((Now()))))
• I have a label on the form containing the variable – with all of these commands, the variable looks correct:

  

Here’s the Patch command in the OnSuccess of frmWorkflow:

If(
!IsBlank(varCompletionDate),
Patch
(
‘CRSP-Main’,varRecord,
{‘Date Completed’: {Value:varCompletionDate}
}
)
);

This is the error message:

I read somewhere (which of course I can’t find again) that Now() is a record.

Can anyone help me with this?

Thanks.

——————————
Lisa White
Senior IT Specialist
Herndon VA
703-709-7172
——————————

[Koen Mathijs]

Hi Lisa,

please try to use the Now() function directly in your Patch statement instead of having it in a variable.
You could try something like this:

if(
“Complete” in DataCardValue28.SelectedItems.Value,
Patch(
‘CRSP-Main’,varRecord,
{‘Date Completed’: Now()
}
)
)

Let us know if this works or not

——————————
Koen Mathijs
——————————
——————————————-

[Lisa White]

Thanks, Koen. That worked! Here’s the new code:

If(
varCompleted =”Yes”,
Patch
(
‘CRSP-Main’,varRecord,
{‘Date Completed’: Now()
}
),
Patch
(
‘CRSP-Main’,varRecord,
{‘Date Completed’: Blank()}
)
)

——————————
Lisa White
Senior IT Specialist
Herndon VA
703-709-7172
——————————
——————————————-