Answered

Newby's first button

(0) Share

Report

Posted on by Manuel_O

Hello,

I'm just about doing my first PowerApp, watched the videoes and read some documentation, but seemly I'm not able to get a proper result.

For my first test, I'm connected tp an excel table on oneDrive, I made an app out of the data and this works fine. Now I try to add a button that feeds a field with a value. I tried with:

Update( Tabelle2, { Stamp: 0 } )

on the onSelect property. The table's name is Tabelle, the field is stamp. Can someone tell me what the correct syntax would be?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The update fx updates a whole record in the table and expect the old record, then the new record (old to update)
UpdateIf can modify value(s) in record(s)

Examples: https://docs.microsoft.com/en-us/powerapps/functions/function-update-updateif

Was this reply helpful? Yes No
timl 37,241 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Manuel_O

It looks like you're trying to update an existing record in your Excel spreadsheet.

With PowerApps, there are a few functions that can carry. The two main ones are Update and Patch. Update replaces an entire record in a table, whereas Patch updates one or more values in a record and the other values alone. In both cases, we need to specify the record to update and this is the bit that's missing in your formula.

Assuming that you added a gallery control called BrowseGallery1 that shows records from Tabelle2, the formula to update the currently selected record would be:

Patch( Tabelle2, BrowseGallery1.Selected, { Stamp: 0 } )

Was this reply helpful? Yes No
Manuel_O 32 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you!
I changed it to:

Patch( Tabelle2, DetailForm1.Selected, { Stamp: 0 } )
to fit the controls name (DetailForm1)..but it still does not work: ("Expected:: ParenClose; Found: Error" says fhe warning sign).

Was this reply helpful? Yes No
timl 37,241 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Manuel_O

DetailForm1 is the control that displays a single record, so unlike the gallery control, it doesn't have a Selected property.

To find the record that you're updating, I recommend that you look at the properties of DetailForm1. The Item property defines the record that the detail form shows. This is the value that you should provide as the second argument to the Patch function.

Was this reply helpful? Yes No
Manuel_O 32 on at

Like
a
(0)

Report
Copy link

Link copied!

"BrowseGallery1.Selected" seems to be correct, following your tips. But I still get errors:

Was this reply helpful? Yes No
Manuel_O 32 on at

Like
a
(0)

Report
Copy link

Link copied!
It seems to work when I use semicolons instead of commas:

Patch( Tabelle2; BrowseGallery1.Selected; { Stamp: 0 } )

Was this reply helpful? Yes No
Verified answer

timl 37,241 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Manuel_O

Yes, it is correct to use a semi-colon instead of a comma when you run PowerApps in German.

Here is something that I posted earlier this week that explains this behaviour.

https://powerusers.microsoft.com/t5/General-Discussion/Combining-2-actions-for-a-Button/m-p/84045#M32335

Was this reply helpful? Yes No
Manuel_O 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, I did not know this. Even the code examples in the german(!) documentation are with commas and therefore don't work here.
Good to know! Thank you all for the help!

Was this reply helpful? Yes No
timl 37,241 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You're welcome! I'm glad I could be of help.

Was this reply helpful? Yes No