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)

Sort by

Verified answer

WarrenBelz 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!
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 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

It is date/time

Was this reply helpful? Yes No
ndionysiadis 68 on at

Like (0)

Report
Copy link

Link copied!
I've made it with this code:

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

Was this reply helpful? Yes No
WarrenBelz 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ndionysiadis 68 on at

Like (0)

Report
Copy link

Link copied!

I can't mark it as solution, why?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@ndionysiadis ,

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

Was this reply helpful? Yes No