Please help me spot the error in the following code:
fkAssetID = iAssetID,
fkDefectID = ThisItem.DefectID
) > 0,
fkAssetID = iAssetID && fkDefectID = ThisItem.DefectID
Thank you in advance!
Solved! Go to Solution.
Not yet. I think I need to rethink my approach. Maybe not start with CountIf? What I am trying to do is check if a record exist in the collection with the argument fkAssetID and fkDefectID.
If it does, I would update that record, if not add new.
What if I just delete the record and add my new value each time an update or add new is triggered?
Have a great day!
ThisItem.DefectID is from the gallery where I select the defect desc + defectID. I tried taking out ThisItem.DefectID and the issue persists. 😞
@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.
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?
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!