web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Help : update in bulk

Power Apps

Unanswered

Help : update in bulk

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to bulk update records in SQL table "dbo.Test" from Gallary "Gallery1"

I have a collection which is made from Gallery1

here is the onSelect when they click Approve

ForAll(Collection1,Patch(
'dbo.Test',
First(
Filter(
''dbo.Test',
ID = Gallery1.ID
)
),
{
Status:"Approved"
}
))

is it correct?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Try this:

ForAll(Collection1,Patch( 'dbo.Test', First( Filter( ''dbo.Test', ID = Collection1[@ID] ) ), { Status:"Approved" } ))

Let me know if this works.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try:
ForAll(Collection1,Patch(
'dbo.Test',
First(Filter('dbo.Test',ID = Gallery1.ID)),
{Status:"Approved"}))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

If you only want to update "Approved" to Status field, please try with UpdateIf function, which could be more efficient.

UpdateIf('dbo.Test', ID in Collection1.ID, {Status:"Approved"})

Hope this helps,

Sik

Was this reply helpful? Yes No

Join the conversation