You’re offline. This is a read only version of the page.
30
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!
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
Share
Report
All responses (
Answers (
