Update a Field with Current DateTime via Button

(0) Share

Report

Posted on by ndionysiadis

Hello everyone, happy to be here!

I'm new on PowerApps and I'm struggling with an issue for hours now.

I want to set a field value to the current date & time via button. This field is a table field and I want to update it for each row I'm pressing the button.

Here is my code:

Set(CurrentDateTime, Now());
Update(ThisItem.Submitted, CurrentDateTime);
Refresh(expenses)

And here is a screenshot to understand my issue better:

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @ndionysiadis ,

You should just need

Patch( SPListName, ThisItem, {Submitted: Now()} )

and should not need to refresh.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ndionysiadis 68 on at

Like (0)

Report
Thank you for your anwer!

This is what I'm getting as errors:

1) The function 'Patch' has some invalid arguments.
2) Invalid argument type (DateTime). Expecting a Record value instead.
3) Cannot use a non-record value in this context: 'ThisItem.Submitted'.

And this is the code:
Patch( expenses, ThisItem.Submitted, {Submitted: Now()} )

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@ndionysiadis ,

What type of field is Submitted - it should be date/time

Was this reply helpful? Yes No
ndionysiadis 68 on at

Like (0)

Report

It is date/time

Was this reply helpful? Yes No
ndionysiadis 68 on at

Like (0)

Report
I've made it with this code:

Patch( expenses, ThisItem, {Submitted: Now()} )

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@ndionysiadis ,
That is exactly what I posted in my first response

Was this reply helpful? Yes No
ndionysiadis 68 on at

Like (0)

Report

I can't mark it as solution, why?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@ndionysiadis ,

I assume you managed to do so (it is now marked)

Was this reply helpful? Yes No