Answered

Lookup function date shows as UTC time zone

(0) Share

Report

Posted on by SP-20081452-0

I have a lookup function in a PowerApp that pulls the date shown in a Sharepoint list. Unfortunately the date from the list is shown in UTC time (YYYY-MM-DDTHH:MM:SSZ). Anyway to have the date display as the local date MM-DD-YYYY HH-MM in the app without changing the Sharepoint list format? Essentially removing the 'T', the 'Z' and the 'SS' from the original UTC time and converting to whatever the local time is for that user? Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,729 Most Valuable Professional on at

Like (0)

Report

You can use a Text() function around the value pulled from SharePoint to format it however you want it to appear. Text function - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
SP-20081452-0 21 on at

Like (0)

Report

@Pstork1 Thanks, my text function is already pulling the data from a sharepoint list:

LookUp('Sharepoint_List', Author.Email=User().Email && Active = true).Date

So, I'd need to somehow add this code around this function? A bit above my head at present (newbie here).

Was this reply helpful? Yes No
Verified answer

Pstork1 68,729 Most Valuable Professional on at

Like (0)

Report
The following will reformat the lookup as a Date. If you want to adjust the date/time from UTC to the local timezone then you also need to use TimeZoneOffSet()

Text(LookUp('Sharepoint_List', Author.Email=User().Email && Active = true).Date,"mm/dd/yyyy")

With TimeZoneOffset

Text(DateAdd( LookUp('Sharepoint_List', Author.Email=User().Email && Active = true).Date, −TimeZoneOffset( LookUp('Sharepoint_List', Author.Email=User().Email && Active = true).Date), TimeUnit.Minutes ), "mm/dd/yyyy")

Was this reply helpful? Yes No
SP-20081452-0 21 on at

Like (0)

Report

Thanks @Pstork1 unfortunately your first line of code didn't seem to make a change, date is still showing up as:
2024-04-03T17:57:20Z

Was this reply helpful? Yes No
Pstork1 68,729 Most Valuable Professional on at

Like (0)

Report

Can you provide a screenshot of where and how you are using the code when doing the lookup?

Was this reply helpful? Yes No
SP-20081452-0 21 on at

Like (0)

Report

Sorry, my bad. Turns out the field in Sharepoint wasn't a data field. Using DateTimeValue instead worked great!

Was this reply helpful? Yes No