Patch Gallery

[iwonder]

Thank you for taking the time to read my question.

I am trying to loop through all the filtered results of my Gallery and patching the ones that have the checkbox checked.

This is my formula. When I type it in, it's fine but when I run it the Lookup() part gets the red underline.

Also, the Patch doesn't happen and the record is not updated.

Thanks!

[WarrenBelz]

@iwonder ,

Can you please supply your formula as text.

[PaulD1]

Could you try turning on Performance Monitor and seeing if that gives any more detail about the error?

[iwonder]

Hi WarrenBelz,

Thank you for your reply.

Here is the formula as text:

ForAll(NewHistoricalPelleting.AllItems, If(ThisRecord.chkUpdate.Value = true, Patch(PelletingRecord,LookUp(PelletingRecord,ID = ThisRecord.ID ),{QAReviewedDate:Now(),QAReviewedBy:User().Email,QAComments:QAComments})));Notify("All Done",NotificationType.Information)

Thanks!

[iwonder]

Hi PaulD1

I am in Advanced Settings and I do not see Performance Monitor. Is there somewhere else I should be looking?

Thanks

[iwonder]

I found "Monitor"

Is this helpful?

Thanks

[iwonder]

One thought.

Do I need to use RenameColumns()? The name of the columns are the same... they're both "ID". One "ID" is ThisRecord and the other is from PelletingRecord in SharePoint.

Thanks,

[iwonder · Accepted solution]

I figured it out. I used RenameColumns() on the Gallery.

ForAll(
    RenameColumns(NewHistoricalPelleting.AllItems,"ID","RecID"),
    If(
        ThisRecord.chkUpdate.Value = true,
        Patch(
            PelletingRecord,
            LookUp(
                PelletingRecord,
                ID = RecID
            ),
            {
                QAReviewedDate: Now(),
                QAReviewedBy: User().Email,
                QAComments: QAComments.Text
            }
        )
    )
);
Notify(
    "All Done",
    NotificationType.Information
)

Thank you for your responses to my question.