cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Using button to update date and time

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 

 

Capture.PNG

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: Using button to update date and time

@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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Highlighted
Community Support
Community Support

Re: Using button to update date and time

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:4.JPG

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
Highlighted
Super User
Super User

Re: Using button to update date and time

@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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Highlighted
Regular Visitor

Re: Using button to update date and time

@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.

 

 

Highlighted
Community Support
Community Support

Re: Using button to update date and time

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:4.JPG

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Super User
Super User

Re: Using button to update date and time

@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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Helper IV
Helper IV

Re: Using button to update date and time

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. 

Highlighted
Regular Visitor

Re: Using button to update date and time

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

Highlighted
Regular Visitor

Re: Using button to update date and time

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
Highlighted
Regular Visitor

Re: Using button to update date and time

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 

Highlighted
Super User
Super User

Re: Using button to update date and time

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.

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,127)