
Hi
I am trying to update a number of entries in a sharepoint list (LookUp column). I have the formula working but it does not add the item to all of the entries.
This is my current code
ForAll(G_Conditions.AllItems,
Collect(Coll_Cond2,
{Title: Title3.Text,
C_ID: ID,
Old_Deals: Deals
}));
ForAll(G_Conditions.AllItems,
With({parentRecord: LookUp (Coll_Cond2, C_ID > 0)},
With({Coll_Cond3:parentRecord.Old_Deals},
Collect(Coll_Cond3, {Id: F_New_Deal.LastSubmit.ID,
Value:F_New_Deal.LastSubmit.Buyer});
Patch(Coll_Cond2, parentRecord, {Old_Deals:Coll_Cond3})
)));
It updates the new entry to the child collection entry but only for the first entry not any subsequent entries.
T