Patch LookUp Columns with ID selection

(0) Share

Report

Posted on by maheralkhalil

Hi All

I try to Use Patch for LookUp In my power app

My SP List is 'Store Inventory' Column is StatusCode with LookUp Tow Choices (On Hold and Done).

I use Patch as below but it is working Only with first Item In my list even i used with another filed but the changing Happened with the first filed that his ID = 1

Patch(Store Inventory
LookUp(Store Inventory, ID= 1)
, {
StatusCode: {Value: "On Hold"}
}
)

regards

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

maheralkhalil 92 on at

Like (0)

Report
Copy link

Link copied!

for button i use
Patch( 'Store Inventory',
LookUp('Store Inventory', ID=1),
{
StatusCode:Dropdown2.Selected
}
)

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

Like (0)

Report
Copy link

Link copied!
Hi @maheralkhalil ,

It only works for the first record in the list because you specify that the record to be modified is always the one with ID 1.
https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-patch#modify-or-create-a-record-in-a-data-source-1
Maybe you could try as below:
Patch(Store Inventory LookUp(Store Inventory, ID= 2), {...........} )
or
Patch(Store Inventory LookUp(Store Inventory, ID= Gallery1.Selected.ID), {...........} )

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
maheralkhalil 92 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yujincui-msft
thx for your replay
it was try with ID= 2 but that not working
with secound option Also not working
regards

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @maheralkhalil ,

Do you want to patch a SharePoint Lookup column?
I have made a test for your reference.

1. Here are my lists.
2. Here are my App.
Result

In addition, here is a link that for your reference.
https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-lookup-column-in-power-apps/

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
maheralkhalil 92 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yujincui-msft
I use in SP list Task Outcome Column for Choices not lookaup Column but I use same patch
Regards

Was this reply helpful? Yes No
maheralkhalil 92 on at

Like (0)

Report
Copy link

Link copied!

hi @v-yujincui-msft
it's working now as what you do on Up
thank you
I think I was used wrrong patch
now OK

Was this reply helpful? Yes No