Answered

add timestamp to an already created item

(0) Share

Report

Posted on by roncam

hi,

I already created an item in an sp using powerapps and now I need to create two button to insert the start time and end time to this same item.

can you help me please ?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

ChrisRoxor 28 on at

Like (1)

Report
Copy link

Link copied!

Do you want to insert the current time/date or do you want a date picker to insert a chosen date to overwrite or add to the sharepoint list?

Was this reply helpful? Yes No
roncam 58 on at

Like (0)

Report
Copy link

Link copied!

insert current time

Was this reply helpful? Yes No
ChrisRoxor 28 on at

Like (1)

Report
Copy link

Link copied!

You can use the Now function to pull the actual date/time and insert where needed.
See more here:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-now-today-istoday

For example, you could have a text input field with it's default set to:
If(ButtonClicked, CurrentTime, Parent.Default)
This ensures you get the fresh details, but that it will show any preentered details that might be present beforehand.

Then the button OnSelect properties
UpdateContext({CurrentTime: Now()});UpdateContext({ButtonClicked: True})

Then whenever you click out, you can update the ButtonClicked to False or Blank() to cancel it out.

I'm sure there might be a "prettier" way but it should work for you.

Was this reply helpful? Yes No
roncam 58 on at

Like (0)

Report
Copy link

Link copied!

i would like to have a button called "Start" when pressed it will update the record with now() time under a particular column in sp and another button named "End" and when pressed will insert the Now() time in another particular column in sp.

Was this reply helpful? Yes No
roncam 58 on at

Like (0)

Report
Copy link

Link copied!

obviously updating the current record

Was this reply helpful? Yes No
ChrisRoxor 28 on at

Like (1)

Report
Copy link

Link copied!

Okay so you're trying to just update directly in sharepoint, and not in a text input field.

You need to use the Patch function in this case:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

Syntax:
Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ])

So you'd use BaseRecord as the current field to update, example ThisItem.Record1 and in ChangeRecord1 you'd put Now()

All of this should of course be on the button OnSelect properties

Was this reply helpful? Yes No
roncam 58 on at

Like (0)

Report
Copy link

Link copied!

ThisItem is not working

Was this reply helpful? Yes No
Verified answer

ChrisRoxor 28 on at

Like (1)

Report
Copy link

Link copied!

You need to have a selected item before you can modify it. Generally if you have a gallery edit page you would pick the item through the Gallery selection page, and then ThisItem should work.
If you need to run it as a standalone button without already having pulled the relevant row from SharePoint, you would need to use a function to search by ID or another column with a unique value, to then patch in the now() value.

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

Like (0)

Report
Copy link

Link copied!
Hi @roncam,

How do you create a new record within your SP list? Using SubmitForm function or Patch function?

Could you please share more details about the data structure of your SP list?

Based on the needs that you mentioned, I think the Patch function could achieve your needs. If you want to update an existing record using Patch function, you must find the record you want to update firstly.

I have made a test on my side, please take a try with the following workaround:

Set the OnSelect proeprty of the "Start Time" button:

Patch( "YourSPList", LookUp("YourSPList", ID = "List Item ID"), /* <-- Find the existing record you want to update based on List Item ID*/ { StartTimeColumn: Now() } )

Set the OnSelect proeprty of the "End Time" button to following:

Patch( "YourSPList", LookUp("YourSPList", ID = "List Item ID"), { EndTimeColumn: Now() } )

More details about the Patch function and LookUp function in PowerApps, please check the following article:

Patch function

LookUp function

Best regards,

Kris

Was this reply helpful? Yes No