cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nikki_R
Regular Visitor

Updating LookUps

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

0 REPLIES 0

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,363)