Answered

ForAll - patch multiple records in table

(0) Share

Report

Posted on by MrDrone

I'm only a couple of months into my power apps experience. So, the question might be basic, but still, I'm struggling.

I've been trying for a while to get this code to filter all items in a table and edit a specific field for all matching filter. Don't know if it is syntax or I'm using the functions wrong...

ForAll(
 Filter(
 // Filter out the records that contains the SetID in variable selectedSet
 BatteryTbl, SetID = selectedSet
 ),
 Patch(
 BatteryTbl,
 LookUp(BatteryTbl, BatteryID = ThisRecord.BatteryID), 
 {
 // Set the Location field of record to the selected item in a dropdown box.
 Location: locationdd.SelectedText
 }
 )
)

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @MrDrone ,

Please try this formula :

UpdateIf(BatteryTbl,SetID = selectedSet,{Location: locationdd.SelectedText})

I think this link will help you a lot:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-update-updateif

Best Regards,

Bof

Was this reply helpful? Yes No
MrDrone 5 on at

Like (0)

Report
Copy link

Link copied!
That is awesome. Thank you both for the formula and the link. That formula is so much cleaner and works perfectly. Just had to add .value to the SelectedText in the dropdown to get text variable and not the record.
UpdateIf(BatteryTbl,SetID = selectedSet,{Location: locationdd.SelectedText.Value})

Was this reply helpful? Yes No