Answered

Unable to Submit Date and Time to SPO List from DataCard

(0) Share

Report

Posted on by lardo5150 Microsoft Employee

@RandyHayes if you remember, you helped me with this date and time.

Per my last post, I took your advice and removed the datacard, then put it back.

I then removed the dropdown and put in labels so I could make it so the users can't change the time, and fix the formatting I was having with the numbers.

So far this is working great....until I go to submit the time to the SPO List.

I found the way I have it now, the form would work, but it would not post the date/time.

I changed the field to true for required, just messing around, this caused it to error. so I am going to change that back to false.

Since I moved away from the dropdown boxes, I think my formula is off. I changed it to represent TEXT instead of value, but was still not posting.

Here is the formula that you gave me, but I modified for the text boxes.

DateValue1.Text +Time(If(AMPMValue.Text = "PM",12,0) +Mod(Text(HourValue1.Text),12),Text(MinuteValue1.Text),0)

so everything gets submitted to the SPO list, EXCEPT the date and time.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@lardo5150

If you were making the date and time not user editable, then what would you be submitting back to your datasource??

Are you trying to submit the current date and time when the item is created and want to no longer (after created) let the user edit? Is that the plan?
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Exactly. I have it setup the same way before where we would default the drop downs to the current date and time that the user is creating that record.
Before they could change it if they needed too. Management does not want that.
So now, when they open that screen to create the case, it still defaults to the current date and time.
I just can't get it to submit to the SPO List.
The column AssignmentTime in the SPO list is a Date/Time column.
Now that it is text, do we need to do some dateformat function?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@lardo5150

Yes, so if you want to set the time and date in that column on creation of the record, then this would involve the Update property of the datacard - HOWEVER, when you make a control type view only, the datacard no longer will have an Update property.

So, that means:

1) Perform another update action after the form is submitted. This is never a good option!

2) Provide the defaults as part of the Item record. This is good, but, if the problem is this...if the datacard in the form does not have an Update property, then there is no way that it will interact with the Update/Submit action.

So that's a no-go.

3) Let the form do the setup for you:

- Add your field to the form and change the control type to View (you have already done this)

- Unlock the DataCard

- Go back to Edit Fields and Add (again) the date time field. Do NOT change the control type. Leave it editable.

- Unlock that new card and go to the Update property and set it to: Coalesce(Self.Default, Now())

- Set the Visible property of that new data card to false

That (#3) will give you the ability to set the date when submitted the first time, and from that point forward, only view it.
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

ok, let me give this a shot in the morning and i will ping you if any issues.
Verified answer

lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

So when I did it that way, the date never changed from the default.
What I ended up doing was something similar.
I added the two Assignment fields.
Set the one up like we used to have it. But made visible to False.
Set up the other assignmenttime field, but changed it to view and made text boxes to display the current time.
Now, when you pull the screen up, they see the field with the current date and time, that is just viewable.
The other one is hidden and does the update!
Thanks for leading me this way!