DateTime displayed incorrectly in gallery lookup

(0) Share

Report

Posted on by RVoller

222

Hi,

I have a gallery that lookups a value in the selected drop down list.

The date displays correctly, but the the time does not and the 'AM/PM' is also incorrect.

Correct display : 17/04/2024 3:30pm

Current display: 17/04/2024 12:00AM

In the gallery, I am using the following to display the date time value.

"Date: " & Text(

DateValue(

LookUp(

'Eden Park Ticket Bookings-DEV',

Fixture = EventDropDown.SelectedText.Value,

'Fixture Date And Time'

)

"dd/mm/yyyy hh:mm AM/PM"

)

Datasource is a datetime field in a sharepoint list.

Kind regards

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RVoller ,

The point is TimeZone .The time in your App is the local time. When the time is saved to SharePoint, it will be converted according to the time zone set by your SharePoint Site. So the time you get is different from the time in the App.

I think this link will help you a lot:

Solved: Not able to capture current date and time in share... - Power Platform Community (microsoft.com)

Best Regards,
Bof

Was this reply helpful? Yes No
RVoller 222 on at

Like (0)

Report
Copy link

Link copied!
Hi,
The time zone is correctly set.
I am trying solution 2 :
RecordCreatedDate:DateAdd(DateTimeValue(Ctime),X,Hours),
I am not sure what ,X, is in the formula. My patch is as follows:
ForAll(
Sequence(12),
If(
IsBlank(varRecord),
Patch(
'Eden Park Ticket Bookings-DEV',
Defaults('Eden Park Ticket Bookings-DEV'),
{Fixture: FixtureTxt.Text},
{'Fixture Details': DescriptionTxt.Text},
{Reserved:"No"},
{'Catering Required':"No"},
{
'Fixture Date And Time': DateAdd(DateTimeValue (
Concatenate(
EventDate.SelectedDate,
" ",
StartDropDown.SelectedText.Value
)
), X, TimeUnit.Hours
)
}
),ColEvent
))
Also, the sharepoint patch is working correctly. The time is saved correctly to the sharepoint list. However, when displayed in the gallery, the only the time is incorrect.

Was this reply helpful? Yes No
RVoller 222 on at

Like (0)

Report
Copy link

Link copied!

Hi,
I updated the gallery lookup and it works:
"Date: " & Text(
LookUp(
'Eden Park Ticket Bookings-DEV',
Fixture = EventDropDown.SelectedText.Value,
Text('Fixture Date And Time',"dd/mm/yyyy hh:mm AM/PM")
)
)
Thank you for your time. It is appreciated.

Was this reply helpful? Yes No
Verified answer

VishalJhaveri 1,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Text('Fixture Date And Time',"dd/mm/yyyy hh:mm AM/PM")

This must definitely work.

Was this reply helpful? Yes No