Almost impossible time behaviour!

(0) Share

Report

Posted on by DavidMullett

Right so I have a calendar date selection with time.

Set two variables to pick up time like dd/mm/yyyy 08:00:00 etc

Hit confirm on the form to add it to a SP List and One time sticks, the other doesn't even though they are the same!

Code to set the variables:

Set(
 startTime,
 DateTimeValue(Text(selectedDate,DateTimeFormat.ShortDate) &" "& TimeValue(ddTimeFrom.Selected.Value))
 
);

Set(
 endTime,
 DateTimeValue(Text(selectedDate,DateTimeFormat.ShortDate) &" "& TimeValue(ddTimeTo.Selected.Value))
);

Then this is the confirm code for the specific date/time bits.

CheckOutFrom: startTime,
CheckOutTo: endTime,

At this point in the preview the startTime and endTime are calling back this:

startTime = 14/02/2022, 08:00:00

endTime = 14/02/2022, 18:00:00

However, when I look in the SP list they come through as this when the column are set to Date and display Time

startTime = 14/02/2022, 12:00 AM

endTime = 14/02/2022, 06:00 PM

How can that be??

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

DavidMullett 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Don't worry, sorted it.

If anyone has a similar issue one SP column had a default value set in the settings of the column which wasn't turned on when you click --> Edit Settings. You have to go to 'List settings' then the column to see the default setting. Weird that the default setting for date was overwritten but the time wasn't!