Answered

How to read a DATE with a Gallery

(0) Share

Report

Posted on by Crios29

Hi everyone,

I need your help, I'm trying to create a gallery from a Excel-Online, in the column "Report Sent", I have Date information, the issue is when PowerApps reading with a gallery this information...

appear like this:

PowerApps Galley.JPG

What should I do with this problem? I tried change the format to "DateTimeFormat.LongDate", but nothing happens, thanks four time and help.

Best Regards,

Carlos

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Crios29 ,

If you are using Excel, consider storing it as text, writing as (format depending on your region)

Text(YourDateValue,"dd/mm/yyyy")

and reading as

Text(DateValue(ThisItem.YourDateField,"dd/mm/yyyy")

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Crios29 :

Date calculation in Excel is a form of sorting dates into a series, increasing by 1 every day, so that the date can be stored as a serial number that can be used for calculation. By default, the serial number of January 1, 1900 is 1, and the serial number of January 2, 1900 is 2, and the serial number of January 1, 2008 is 39448. This is because it is 39,448 days from January 1, 1900.So, using this principle, you can restore these floating-point numbers to date and time.

Text( DateAdd( Date(1900,1,1), Int(Thisitem.'Rpt Sent'*24*60),Minutes), DateTimeFormat.LongDateTime24)

Or

Text( DateAdd( Date(1900,1,1), Int(Value(Thisitem.'Rpt Sent')*24*60),Minutes), DateTimeFormat.LongDateTime24)

Best Regards,

Bof
Crios29 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Bof for your explanation, It works perfect!!

Best Regards,

Carlos