web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Update date in same ce...

Power Apps

Answered

Update date in same cell button

(0) Share

Report

Report

Posted on by Gionny91

2

Hi, I am new to the world of PowerApps and need some help. I have connected an Excel Online (Business) file to my App. Now I would like to create a button where the user, by clicking on it, automatically updates a single cell in Excel with the current date. This should essentially always update the same cell, not create a list of dates. I enclose screenshot of the Excel with the table name. The idea is to create a button for each "Sektor" (202AB, 203AB, etc). Thank you very much for your help

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

timl 37,248 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Gionny91

To do this, you would add a gallery control and set the Items property to DatumHR.

You can then add a button to the gallery template and set the OnSelect property to the following:

Patch(DatumHR, ThisItem, {Datum:Today} )

Note that if you're running Power Apps in German, you would use semi-colons instead of commas.

Patch(DatumHR; ThisItem; {Datum:Today} )

Was this reply helpful? Yes No

Join the conversation