Answered

Patch multiple records

(0) Share

Report

Posted on by JanMarten

Hey I know, there are already much thready who handle this, but I didn´t understand how I can patch multiple records in a sharepoint list.

ForAll(Filter(Collection;User().Email=person.Email);Patch(ThisRecord;{variable:true}))

But this do nothing if I put this on a button.. I have to use much more conditions, but want to try it first with a easier version. So in the sharepoint there are definetley records who match this condition, but nothng happens.

Idk. if this with "ThisRecord" is right, but I don´t understand how I could get a loop in the patch.

Know someone what I do wrong?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JanMarten ,

Try

ForAll( Filter( Collection; User().Email=person.Email ) As aPatch; Patch( YourSPListName; {ID:aPatch.ID}; {variable:true} ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
JanMarten 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz thank you for your answer.
I tried it, but sadly I get the error that I can´t use the same datasource in the Patch-function as the one of the ForAll-funtion.

EDIT:
Got it working through creating a variable of the sharepoint fistly and then I put this variable/collection in the ForAll command, but idk if this is a clean method...
Sry that I haven´t clariefied that, "YourSPListName" and "Collection" are the same. If I remove "YourSPListName", the error disappers, but if I try it, nothing happens.
Reinerknudsen87 59 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz - I love this solution after I fought for hours with that same issue. Would you mind quickly explaining what happens here. I get everything but the first pair of curly parentheses in the Patch. What does {ID: aPatch.ID} actually do? does that represent a record?
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Reinerknudsen87 ,

You can call aPatch whatever you want - I just have a naming protocol. All the As Function does is disambiguate the fact that the key fields have the same name (you cannot put {ID:ID} as Power Apps will not know which one you are referring to).