Hi everyone, I need to add one local collection values into another local collection and I am using ForAll to do this but it is only updating the first record in the collection.
Here is my formula,
ForAll(envtable,
Update(citable,First(Filter(citable,ThisRecord.SysID=SysID)),
{
Environment:ThisRecord.Environment,
ApplicationName:LookUp(citable,SysID=ThisRecord.SysID,ApplicationName),
Child:LookUp(citable,SysID=ThisRecord.SysID,Child),
ChildClass:LookUp(citable,SysID=ThisRecord.SysID,ChildClass),
RelationType:LookUp(citable,SysID=ThisRecord.SysID,RelationType),
SysID:LookUp(citable,SysID=ThisRecord.SysID,SysID)}
)
);
where SysID is common column among two collections.
I need to update the record which matches the SysID of both collections one by one.
Please Help.
Thank you in advance
