Hi @TWolsten ,
I use something similar with new record selecting crew from a gallery based on a collection and then writing back to a SharePoint List. There will be other views on this, but I tend to keep code simple rather than trying to wrap multiple functions inside each other (also MUCH easier to debug), so firstly the new records. The reference to the collection Proposed is actually not needed as the data required is contained in the gallery and the ForAll on a gallery may be ambiguous if referring to something else. So for the new records, try this (works for me when all columns in the gallery line up [name, type] with a field in the List).
ClearCollect(
colNew,
DropColumns(
Filter(
ChooseGallery.AllItems,
New_x0020_Item_x003f_ = "Yes",
),
"ID"
)
);
Collect(
bp_proposed,
colNew
);
Clear(colNew)
Now the existing items
ForAll(
RenameColumns(
Filter(
ChooseGallery.AllItems,
New_x0020_Item_x003f_ = "No"
),
"ID",
"IDRef"
),
UpdateIf(
bp_proposed,
ID = IDRef,
{
Field1Name:Field1Name,
Field2Name:Field2Name,
Field3Name:Field3Name //and so on for the rest
}
)
)
Please give all this a go and see how it works for you.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
