Database
[{_id:"Some random ID",name:"ABC",profiles:[{profileId:"123",attachedOn:ISODate("2022-07-28T15:08:11.072Z")},{profileId:"456",attachedOn:ISODate("2022-07-28T15:08:11.072Z")},{profileId:"789",attachedOn:ISODate("2022-07-28T15:08:11.072Z")},{profileId:"101",attachedOn:ISODate("2022-07-28T15:08:11.072Z")}]}]
Query
db.collection.update({"name":"ABC"},[{"$set":{"profiles":{"$concatArrays":["$profiles",{"$filter":{"input":[{profileId:"123",attachedOn:ISODate("2022-07-28T15:08:11.072Z")},{profileId:"456",attachedOn:ISODate("2022-07-28T15:08:11.072Z")},{profileId:"789",attachedOn:ISODate("2022-07-28T15:08:11.072Z")},{profileId:"202",attachedOn:ISODate("2022-07-28T15:08:11.072Z")}],"as":"profile","cond":{"$not":{"$in":["$$profile.profileId","$profiles.profileId"]}}}}]}}}])