Modify several records in a datasource

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello 🙂

I have a collection that contains two colums: "RecordID", "Quantity". It contains several records.

I need to update only the "Quantity" field in my Datasource for each apropriate RecordID.

I can do it one at a time. But how to update them alle at once?

Thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

SmartMeter 248 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Jesper,
To do this, you will need to use a patch command. You can find the basic syntax here:
https://powerapps.microsoft.com/en-us/tutorials/function-patch/

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks SmartMeter,

The Patch is working fine. The challenge is getting alle the records in my collection to modfy fields in different records in the datasource. I am trying something like this:

Collect(xUpdateChanges,UpdateChanges); ForAll(UpdateChanges, Patch(Vareliste,First(xUpdateChanges).RecordId),{Sorter: Value(First(xUpdateChanges).Sorter)}; Remove(xUpdateChanges,First(xUpdateChanges)) )

Was also looking at this:

UpdateIf(Vareliste,UpdateChanges.RecordId exactin Vareliste.RecordId,{Sorter: UpdateChanges.Sorter})
I much prefered the second option, But cant get any of them to work.

Or is there some entirely different way of doing it?

Thanks in advance.

Was this reply helpful? Yes No
SmartMeter 248 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi again Jesper,
I believe this thread might help you do what you want to do. From what I can see, you are explicitly referencing the id of the record you want updated, so your code will inherently only apply to one record. Check out the forall expression in this poster's question, it might be what you are looking for 😉

https://powerusers.microsoft.com/t5/PowerApps-Forum/Hot-to-Patch-to-update-multiple-records/td-p/51714

Was this reply helpful? Yes No