Answered

Patch date and time, time not showing

(0) Share

Report

Posted on by indhaa

I'm trying to patch date and time to SharePoint List. But the time value is shown as 00:00

let me know what is wrong with the below code

Patch(ExternalAccess,LookUp(ExternalAccess,ID=galID),
{FormStatus:"Access Revoked",
 RevokedBy:LogInUserName,
 RevokedDate:DateValue(
 Text(
 Today(),
 "[$-en-US]dd-mm-yyyy hh:mm AM/PM"
 ),
 "en-GB"
 ),
 
RevokerComment:RevokeComment_2.Text 
});
 
If(IsEmpty(Errors(ExternalAccess)),Notify("Record Has Been Updated Successfully");Navigate(AccessGallery,ScreenTransition.Cover),
Notify("The Process Could Not Be Completed, Record not Added"))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (1)

Report

hi @indhaa try DateTimeValue

Was this reply helpful? Yes No
Abhilash_Swain 901 on at

Like (1)

Report

change DateValue to DateTimeValue

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@indhaa

Change your RevokedDate part of the formula to the following: RevokedDate : Now()

Also, ensure that your column definition for RevokedDate also includes times and not just date.

Your use of the DateValue and the Today() functions will only return dates, not times.

However, at the same time, there is no need to convert a datetime value to a string and then convert it back to a datetime value - which is what you are doing in that formula.

So, just change to the above formula and you should get both date and time in your datasource.

I hope this is helpful for you.

Was this reply helpful? Yes No