Patching parent, child record error

(0) Share

Report

Posted on by Andrey Nikolaev

Hi,

I'm trying to patch parent/ child tables in single onselect event, like this

ClearCollect(
colEmployee,
Patch(
Employees,
{Employee:Blank()},
{'FIRST NAME':"Test patch"}
)
);
ClearCollect(
colEmployeeChanges,
Patch(
Employee_Changes,
{Employee_Change:Blank()},
{Employee:First(colEmployee).Employee},
{REQUESTOR:"Test patch"}
)
)

The error is saying that the expected type of argument is record while a guid is supplied instead.

The error refers to this line {Employee:First(colEmployee).Employee},

Employee is lookup column in Employee_Changes tabe to an Employee table.

Could someone please advice id there's a way to convert types or to do something similar to fix the issue.

Thanks!

Categories:

Microsoft Dataverse

Tables

All responses (1)

Answers (0)

Ram Prakash 5,166 Super User 2025 Season 1 on at

Like (0)

Report

Re: Patching parent, child record error

Hello @Andrew7345,

If you are sure that {Employee:First(colEmployee).Employee} this Line is throwing error then you can try changing the same like below to make it work

{Employee:LookUp(EMPLOYEETABLENAME,'FIELD FROM EMPLOYEE'=VALUE FROM COLLECTION)}

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com