Using button to update date and time

[kemal_aljic]

Dear all,

I have created sharepoint list with 6 diferent colums containing date and time , i have connected list with the app 

so my app has 6 data cards with date and time and i would like to use buttons to update date and time stamp.

I went thru some older post and i have used following code as on select button .

UpdateContext({DateNow: Now()})

On the actual data card i have used following code first on default and later one on update fields.

 If(IsBlank(DateNow), ThisItem.EndDate, DateNow)

In practice each column in one record will be updated only once and this timing will not change , when i was using default field i was updating same date column for other records and this was an issue. Than i have used same code on update field and i have had similiar issue where current time was updated each time when record was saved. 

Basicly i need solution where button will update data card only once and it will update it only for one record? 

Any suggestions? Thank you 

[RandyHayes · Accepted solution]

@kemal_aljic 

If I understand your post correctly, you are having an issue that more than the current record will be changed with the DateNow value.  I don't believe you are stating that *all* records are being changed, but instead that if your button is pressed, the date changes in the current record, but then any subsequent records are incorrect.

If this is the case, then I can certainly understand that from your formula.  You are relying on the DateNow variable to be blank to trigger your logic.  This will only happen initially and potentially unreliably.  The problem would be that you should be setting your DateNow variable back to blank are the record is submitted.

This will be an issue as there is technically no blank date value.

What I would recommend is that you augment your DateNow variable with another variable to maintain the state.

Consider this formula in your OnSelect of the button:

UpdateContext({DateNow: Now(), useDateNow:true})

Then, use this in your Default property:

 If(useDateNow, DateNow, ThisItem.EndDate)

Then, on your OnSuccess action of your form, use the following formula:

UpdateContext({useDateNow:false})

This will give you a better variable to "key" off of as a Boolean variable will work well in all cases.

I hope this is helpful for you.

[kemal_aljic]

@RandyHayes,

Yes , with previous solution if i use date now button on certain column (data card) i will update visible record (data card) as well as same column (data card) in other records in the table regardless if they are blank or not. I have applied your formulas and so far i dont have issues i am only updating visible record witch was my intetion.  Thank you for your assistance , much appriciated.

[v-xida-msft · Accepted solution]

Hi @kemal_aljic ,

Have you solved your problem?

Based on the issue that you mentioned, I think this issue is related to that the DateNow context variable has not been reset to blank when you submitted a new record.

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

Set the OnSuccess property of the Edit form to following:

UpdateContext({DateNow: Blank()});  /* <-- Reset the DateNow context variable to blank value when you submitted a new record */
Back()

Set the OnSelect property of the "Update" button to following:

UpdateContext({DateNow: Now()})

Set the Default property of the Date time field data card to following:

If(IsBlank(DateNow), ThisItem.ParticipateTime, DateNow)

Set the Update property of the Date time field data card to following (remain its original formula😞

DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)

Please also take a try with above solution, check if the issue is solved.

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,

[RandyHayes]

@kemal_aljic 

The suggestion @v-xida-msft has put out will work as well.  My suggestion was based on the issue that assigning blank sometimes has results that are not expected.  In my example, we were testing a true/false condition, so assigning a boolean would always work.  The method of assigning blank to a DateTime variable and testing that condition will work as well  -for now.

[SandraAkujobi]

I am having similar issues as well, I've also created two buttons as I have two date fields and I want that when the button has been clicked the time and date are present on the respective date field, I've been following the formulas posted on here but the button is still updating the other date field, I am not sure if I quite understand. 

[sachisha_1]

Hi im also having the same problem. in my case there are few fields and seperate buttons to update date and time. when ussing the following formulas all fields are updated with same value. can you help me to solve this issue

[sachisha_1]

Hi im also having the same problem. in my case there are few fields and seperate buttons to update date and time. when ussing the following formulas all fields are updated with same value. can you help me to solve this issue

[sachisha_1]

Hi ,

 i have few date and time fields to update once the task is start and at the finish of the task. When i use the formuls mentioned you guys in the thread its not working. when click second button first field also updated with the last time. how can i solve this issue.

@RandyHayes@kemal_aljic  SandraAkujobi 

[RandyHayes]

Hi @sachisha_1 

Welcome to the forum.

Typically you would want to create a new post and provide a link reference to perhaps another topic(s) that was similar.  That way your post is fresh and new at the top of the list for people to respond to.  Also because this particular topic is already accepted and closed.

As for your problem, you'll also need to supply some more detail on what formulas you are using and particularly (based on the photo) what the error is that you are seeing. 

My recommendation would be to post a new topic, include as much detail on your formulas and errors, reference this post via a link, and @ mention anyone (like myself or others) that you feel would be helpful to your scenario.  That way it will be top-of-list, will send notices to anyone you @ mention and there will be good context to solve your particular problem.