Unanswered

date/time field will not update when editing an item in sharepoint.

(0) Share

Report

Posted on by rbtgrp

I have used powerapps to create a form to conduct a time study. Users click buttons to record time stamps with a now() function at different steps in their process and then again when completed and I am using a calculated field to determine the time it takes to complete their given process.

The most recent study I have conducted involves a process that users may need to pause and return to at a later time. This does not seem to work. If users edit the record, Powerapps can update text and choice fields, but the date/time field will not update. Is there something that sets this apart?

Categories:

Building Power Apps

All responses (12)

Answers (0)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rbtgrp ,

Are you referring to a Calculated field in SharePoint - if so these do not work consistently with Power Apps and should be avoided. Instead, do the calculation in Power Apps. If this is not the case, what does not update ?

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
rbtgrp 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for responding.

I will start doing the calculated field in Power Apps, but do not think that is the issue here. There are 4 steps on my form, so for example someone starts the first step and then submits. The item in sharepoint will have the correct timestamp for step 1 and then steps 2, 3, and 4 will be blank. If I open and edit the form and click the buttons for steps 2, 3, and/or 4 and then submit nothing updates. Steps 2, 3, and 4 remain blank.

I am relatively new in using Power Apps, so there may be something very simple that I am missing.

Thank you.
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@rbtgrp ,

Do you have separate date fields for steps 2, 3 & 4 and what are the buttons doing OnSelect ?
rbtgrp 12 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
Yes, there are separate date fields.

First button:
Set(step1start,Now());

Next button
Set(step1stop,Now());
Set(step2start,Now())

and so on.
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@rbtgrp ,

That is setting Variables - where are you writing the data to SharePoint ?
rbtgrp 12 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
I have been hacking this together based on things i find online so apologies if the responses do not make sense.
The only other field I have changed on any of the timers is adding seconds to the update variable on the datacard. =DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), Value(SecondValue1.Selected.Value))

And then have a submit button with OnSelect of SubmitForm(SharePointForm1);

Thank you
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@rbtgrp ,

OK - a better question is how are those variables changing the values on the form you are submitting ?
rbtgrp 12 on at

Like
a
(0)

Report
Copy link

Link copied!

I appreciate your patience, but I suppose I do not understand the question. Submitting the form is creating a new row on the sharepoint list. The first time the form is submitted, the columns (step1start and step1stop for example) should have the date and time written to them if the corresponding button was clicked on the form. The expectation was that when returning to the form and editing, any of the buttons that weren't previously clicked would be able to be clicked to update the form with the additional starts and stops.
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@rbtgrp ,

Looking back, if you have this on the Update of the Data Card

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

and you are then submitting the Form, it certainly should write that field to the List. How does the Variable come into this and does the User select the date and times themselves ?
rbtgrp 12 on at

Like
a
(0)

Report
Copy link

Link copied!

the variable just the name of the datacard. Based on the question, perhaps what i'm doing with that is unnecessary. I have hidden everything from the user except the button, so all they are doing is clicking the button to set the timestamp.

And to clarify, the form works perfectly when it is initially used. The problem occurs if a user saves or submits and then reopens the form. For some reason when it is reopened by editing the row, the date/time columns cannot be changed. This is in contrast to the title field(text) and a few other choice columns that I have set up as radio buttons. Those can all be changed and updated using the form.