web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Bulk patch some name I...

Power Apps

Answered

Bulk patch some name Items

(0) Share

Report

Report

Posted on by loopingmurdock

250

Hello Guy,

I have a sql database and would like to know how to patch all the row with the same PROD_NAM.

datebase: ot_lu_prod

change: price_unity

lookup: Prod_Sid

Forall(ot_lu_prod(patch(ot_lu_prod, lookup(ot_lu_prod, textinput.text = Prod_sid),{price_unity: 5})

it just changes the first one

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @loopingmurdock,

Do you want to bulk update the records with the same PROD_NAM?

Could you please tell me more about your scenario?

If you want to update all the same PROD_NAM with the same price_unity, I think you should use the UpdateIf() function as below:

UpdateIf(ot_lu_prod,Prod_sid=textinput.Text,{price_unity: 5})

Join the conversation