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!
Solved! Go to 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.
Could you try turning on Performance Monitor and seeing if that gives any more detail about the error?
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!
Hi PaulD1
I am in Advanced Settings and I do not see Performance Monitor. Is there somewhere else I should be looking?
Thanks
I found "Monitor"
Is this helpful?
Thanks
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,
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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
253 | |
122 | |
84 | |
84 | |
67 |