PowerApps DateTime input not displaying correctly in SharePoint List

(0) Share

Report

Posted on by cekberg

PowerApps Date Picker format is current set to the following:

Text( Now(), DateTimeFormat.ShortDateTime )

However when records are being saved from PowerApps, Time is being displayed as 12:00 AM on SharePoint List.

powerapps datecard.PNG SP Date display.PNG

Categories:

Power Apps portals

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-yutliu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @cekberg ，

Could you tell me how do you update this field by using datepicker?

Actually, the datepicker will not record time value, it only record date value.

For example, if you use Datepicker1.SelectedDate, it will not represent the date that you selected.

So If you use this to update, the time value is empty, then it will be filled will the default value "12AM".

I suggest you use a datepicker to record date and two drop downs to record time.

I've made a similar test for your reference:

1)set the date picker's DefaultDate: Today()

set the drop down1's Default:Hour(Now())

set the drop down2's Default:Minute(Now())

2)if the date type is datetime, use this formula to update:

Patch(listname,Defaults(listname){fiedname: detepicker1.SelectedDate+Time(dropdown1.Selected.Value,dropdown2.Selected.Value,0)})

if the data type is text, use this formula to update:

Text(DatePicker1.SelectedDate+Time(Dropdown1.Selected.Value,Dropdown2.Selected.Value,0),DateTimeFormat.ShortDateTime)

Best regards,

Was this reply helpful? Yes No
Verified answer

cekberg 11 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the suggestion Phoebe! I found another workaround for the issue.

I created a hidden text card (DateTimeDisplay) that displays:
Text( Now(), "[$-en-US]mm/dd/yyyy hh:mm:ss AM/PM" )

And modified the Update to the visible Date field to include time:
DateTimeValue(DateTimeDisplay.Text)

This properly transmits the output to SharePoint.
Appreciate the help and feedback!

Was this reply helpful? Yes No
cekberg 11 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft ,
After putting this solution in place, I've found that the hidden text card that displays DateTimeValue is only pushing a static value when the page is initially loaded. If a user submits multiple entries from the app, all records have the exact same timestamp. Any suggestion on how I can refresh the DateTimeValue to push the dynamic Now() time value?

Was this reply helpful? Yes No