Unanswered

Patch with Excel - Error

(0) Share

Report

Posted on by MarcoSager

I am trying to create a patch to an already connected Excel. I think the problem is the two semicolons after "table1". But with one colon the patch has invalid arguments. I've been trying to fix this for three days now hahaha. Can you pls help me 🙂

Set(bst_thispart; TextInput3.Text);;
Patch(Table1;; Defaults(Table1);
LookUp(Table1; ETR = etnr_thispart);
{Inventory: bst_thispart});;
Notify(etnr_thispart & “ ” & bst_thispart)

Translated with DeepL.com (free version)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

MuhammadAizaz 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @MarcoSager ,
here is the correct code:
Set(bst_thispart, TextInput3.Text);
Patch(Table1,
LookUp(Table1, ETR = etnr_thispart),
{Inventory: bst_thispart}
);
Notify(etnr_thispart & " " & bst_thispart)

Was this reply helpful? Yes No
MarcoSager 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey there @MuhammadAizaz1 , thanks for your answer!
But just as i said, for my region (Switzerland) we use semicolons instead of commas. The problem is, that the patch has wrong arguments in it. when i put 2 semicolons (in your case that would be 2 commas) after the first table1, then there is no error. What could be wrong with my data that its says wrong arguments?

Was this reply helpful? Yes No
MuhammadAizaz 53 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @MarcoSager , sorry for late response.
If you issue is still not resolved, please make sure you are either using Default or Lookup function inside Patch function. You cannot use both together inside the Patch function as per my knowledge. Correct code will be.
Set(bst_thispart; TextInput3.Text);;
Patch(Table1;
LookUp(Table1; ETR = etnr_thispart);
{Inventory: bst_thispart});;
Notify(etnr_thispart & “ ” & bst_thispart)

Was this reply helpful? Yes No