Answered

Updating multiple records using patch

(0) Share

Report

Posted on by arahrooh

I'm trying to update all records when the user picks the employee and changes their Equipment Status with the combo box but confused how to implement an update or ForAll loop.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

rzuber 552 Moderator on at

Like (1)

Report
Copy link

Link copied!
Can you use UpdateIf()? Update and UpdateIf functions - Power Platform | Microsoft Learn

UpdateIf( FullEquipmentMasterList, EMPLOYEE = EmployeeBox_Status.Selected.EMPLOYEE, {'EQUIPMENT HR STATUS':NewHRStatusBox.Selected.STATUS} )

Here's a ForAll() loop example to Patch each record one by one:

With( {_records: Filter(FullEquipmentMasterList, EMPLOYEE = EmployeeBox_Status.Selected.EMPLOYEE)}, ForAll( _records As _rec, Patch( FullEquipmentMasterList, _rec, {'EQUIPMENT HR STATUS':NewHRStatusBox.Selected.STATUS} ) ) )

Was this reply helpful? Yes No
arahrooh 6 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much, was overthinking it too much

Was this reply helpful? Yes No