Please help spot the error

[JomarGF]

Hi All

Please help me spot the error in the following code:

If(
CountIf(
collDefectsList,
fkAssetID = iAssetID,
fkDefectID = ThisItem.DefectID
) > 0,
Patch(
collDefectsList,
LookUp(
collDefectsList,
fkAssetID = iAssetID && fkDefectID = ThisItem.DefectID
),
{
DTStamp: Now(),
fkAssetID: iAssetID,
fkDefectID: ThisItem.DefectID
}
),
Patch(
collDefectsList,
Defaults(collDefectsList),
{
DTStamp: Now(),
fkAssetID: iAssetID,
fkDefectID: ThisItem.DefectID
}
)
);

Thank you in advance!

[JomarGF]

The error starts with Patch...

[CNT]

@JomarGF what is the error? 

[JomarGF]

Red line from Patch to end of the code. Saying Patch has invalid arguments?

[CNT]

@JomarGF you're using ThisItem.DefectID

What is ThisItem referring to? 

[JomarGF]

Hi CNT

ThisItem.DefectID is from the gallery where I select the defect desc + defectID. I tried taking out ThisItem.DefectID and the issue persists. 😞 

[CNT]

@JomarGF In the If you have 2 Patch statements ( 1 in the If part and the other in the else part). To isolate the error could you just remove one and see which Patch has the problem.

[JomarGF]

Hi CNT

Thank you for your reply.

I took out the values inside the brackets and the redline disappears! (see screenshot). What do you think is the issue?

[JomarGF]

Hi CNT

Does Patch work for Collections???

Thank you.

[CNT]

@JomarGF Are the datatypes of fkAssetID & fkDefectID matching with iAssetID & ThisItem.DefectID.

Did you try to hardcode some value and see?