Answered

Issues with creating a patch function

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am creating an application which will update different spreadsheets (which all have identical templates). I'm using a switch statement for that part. Reading on the forums, I saw that the best way to update different spreadsheets was by using a patch function.

Anyways, an issue I was having is that the patch function keeps showing that there are errors, despite the fact that my syntax appears to be correct. It is hard to see from this screenshot, so I have created another patch function with a simple function, that shows the same exact error as this function.

Is there a mistake I am making with patch functions?

GenJuly is the table, YES is a column.

On the first screenshot GenYES, GenNO, and GenComm are datacards.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Is your Switch function within a behavior property (one that starts with "On")? Patch() is a behavior function, so it can only be invoked from a behavior property.

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

It seems that you appended the formula on a Label or Text Input box, please try and use it on a Button's OnSelect as mentioned by @BCLS776 .

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, sorry for the delayed response. The Switch function is within an onselect property.

The formula is being put onto an icon if that is relevant.

Was this reply helpful? Yes No
Verified answer

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Your issue is probably stemming from the syntax of the multiple statements in your code. It should look more like:

SubmitForm(EditForm1); Reset(GenCBox); Reset(RadioA); Switch( // with the rest of your code

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Don't chain commands with SubmitForm(). Put them in the OnSuccess property of the form. You don't want them to execute if the form is not successfully submitted.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I've tried this and I believe you are right! Thanks for the help.
On a side note, how do you determine when to use semicolons between functions and when to use a plus sign?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

I've never used a plus sign and this is the first I have heard that you could do it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Will try that.

Was this reply helpful? Yes No