Populate a collection with a ForALL and If condition

[TB05]

Hi, I'm trying to update/patch a new collection with records from an existing collection that DO NOT exist in a SharePoint list based on an ID and Date of the records. If the records exist in the SharePoint list I DO NOT want them added to my new collection.

Here is my "Patch" that I'm having issues with:

ClearCollect(collectEmployeeBonusDetails, Filter(ForAll(collectER_Dev_2 ,If(IsBlank(LookUp(BonusInputDEV, TimeID = ID And Date = DateRange)), ThisRecord))));

I also, get an error that DateRange is not a valid name, although it is in my collectER_Dev_2 collection.

Thanks for your help!

[RandyHayes · Accepted solution]

@TB05 

Please consider changing your Formula to the following:

ClearCollect(
    collectEmployeeBonusDetails, 
    Filter(collectER_Dev_2 As _item,
       !LookUp(BonusInputDEV, TimeID = _item.ID And Date = _item.DateRange, true)
    )
) 

In your original formula, you are referencing records (with ThisRecord) that are not what you expect.

There is no need for a ForAll - just the Filter is all you need.  Your original filter was not specifying any criteria either.

I hope this is helpful for you.

[TB05]

Thank you @RandyHayes , you have helped me solve so many issues and quickly!  Very much appreciated!!!

I hope you have a great day.

[RandyHayes]

@TB05 

Happy to help!