how to patch only one column data into SP existing list? - need help

(0) Share

Report

Posted on by bbsin

1,994

I want to only update one column - Number field into existing SP list record how to patch it?

1) User input eg Product number - how to set when they click enter it auto show in the gallery ? Now I input the number I have to click the arrow icon to display

2) #2 is a form I need the user to input in the Number

3) How to update the number datacard1 into its existing record in SP list without overwrite others? I try

patch(SP list, LookUp(SP list, varRecord (' Number': datacard1.Text})) - not working

my gallery is set as varRecord

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @bbsin :

Could you tell me:

What is varRecord ?

The error I found so far is the syntax error of the formula.The correct syntax is

Patch( DataSource, BaseRecord, ChangeRecord)

Maybe you could try this formula:

patch( SPlist, LookUp(SPlist,'Number'=YourSearchBox.Text ), /*Find the record to be updated*/ {'Number': datacard1.Text} )

Best Regards,

Bof

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof

Great it is working .. Thanks

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof

one question how to refresh all the fields to blank once it click update a pop to show success? Thanks

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft
Hi

Like to check with you
I use the patch syntax on another screen this time bit different and it's not updating the column into the record.

Can kindly advise what is wrong>

I am search descp to sow in the gallery and want to input the numbers to update into SP by the record found

Patch(
'SP list',
LookUp('SP list', Update Number= SearchBox.Text),
{Update Number: Update Numberdatacard.Text}
)

it's not working

Also one question how to disable the input text box but reflect n updated numbers when search exg Workshop a list of workshop will appear??

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @bbsin :

May be you could try:

Patch(
'SP list',
LookUp('SP list', 'Update Number'= SearchBox.Text),
{'Update Number': 'YourTextInputControl'.Text}
)

Best Regards,

Bof

Was this reply helpful? Yes No
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

I did what you have mentioned. But it's not pickup into SP list did I input somewhere wrongly?
am searching by details in the search box and want to patch the POno. of the same record. thanks.

Patch(
'list',
LookUp('List', PONo = tbSearchPoN.Text),
{PONo: PONoInput.Text}
)

Was this reply helpful? Yes No