Answered

Date format does not appear correctly in Card

(0) Share

Report

Posted on by J_Taylor

206

I have a DetailForm where it draws data from a Gallery (standard auto-build). One value is a date, but shown as a number (e.g. 39109). I am trying to get it to appear as a normal date (27/01/2007). However, everything I do either displays nothing or displays the wrong date (01/09/3910).

The item is in a card:

The card has the following properties:

The Value has the properties:

The "Default" was initially "Parent.Default" with the resultant value being 39109.

I attempted to change the "Default" to "DateValue(Parent.Default,"en-GB")", but I believe "Parent.Default" is formatted as a number, so had an error. So, I changed it to DateValue(Text(Parent.Default),"en-GB") and the result was 01/09/3910.

What am I doing wrong here? How do I get it to show "27/01/2007"?

Thank you for your assistance.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @J_Taylor ,

Where does your date come from?

Best Regards,

Wearsky

Was this reply helpful? Yes No
J_Taylor 206 on at

Like (0)

Report
Copy link

Link copied!

A SharePoint List.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @J_Taylor ,

What the data type of the column?

TestDate column in the image is a Date column.

Best Regards,

Wearsky

Was this reply helpful? Yes No
J_Taylor 206 on at

Like (0)

Report
Copy link

Link copied!

I believe it is a number.

From SharePoint:

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @J_Taylor ,

What column do you use to save the date?

Best Regards,

Wearsky

Was this reply helpful? Yes No
J_Taylor 206 on at

Like (0)

Report
Copy link

Link copied!

The SharePoint column is saved as a number. It doesn't appear that I can change it to a date:

I imported the List from an Excel table. I'm not sure if that explains why I can't change it.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @J_Taylor ,

So the root cause is because you saved the date in the wrong column...

The number column of the sharepoint list cannot be converted to a date column.

Please re-import the data in Excel into the list.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
J_Taylor 206 on at

Like (0)

Report
Copy link

Link copied!

Thank you, @v-xiaochen-msft, for your help in solving this problem. I am only very new to all of this. Are you able to advise me on a method to do this (re-import data to the SharePoint List)? The only way I know how to do it is delete the old List and create a new one. Is there a better way?

Was this reply helpful? Yes No