Answered

Date field passing 13 digit figure

Like (0) Share

Report

Posted on 4 Jan 2024 00:30:46 by CU17121522-0

I have an excel database as the source document for a power app. Folks can enter new data in the power app and it populates into the excel. Originally, the date field when entered in Power Apps passed through correctly in the format of mm/dd/yyyy.

Now if I try to view data in a power app gallery a numeric date such 45344 instead of 2/22/2024 displays. I thought it was an excel issue so I reformatted excel. The dates showed up correctly in excel but still not in Power App. I tried a few other methods but now the date is displaying numbers like 1706680800000 and 1709186400000.

Not sure, where I may have messed up. I’m still fairly new to Power Apps so troubleshooting isn’t my forte.

Below is the Patch function I’m using to tie two Power App forms together to pass data back to excel. Not sure if that is where the issue may lie.

T_EntryData is the table the information is submitted to

varFormData is a variable created so that in the gallery when you pull up data as either “view” or “edit” the individual forms display in either view or edit mode

BasicEntryForm first form screen that data is entered

TimelineEntryForm second form screen data is entered

ResultScreen is a screen after submission that allows user to choose if they want to create a new entry or go to the home page

Categories:

Dataflows

All responses (3)

Answers (1)

v-mengmli-msft on 04 Jan 2024 at 07:23:07

Like (0)

Report
Re: Date field passing 13 digit figure

Hi @BlueAndOrange24 ,

When we open this setting in PowerApps:
The date column in excel is automatically converted to date format, I'm not sure what happened to your PowerApps or Excel table. But there's a way to turn it into a date.
Text(1706680800000,"[$-en-US]mm/dd/yyyy")
CU17121522-0 10 on 04 Jan 2024 at 06:29:35

Like (0)

Report

Re: Date field passing 13 digit figure

Thanks! So this solved one issue in that figures such as 45344 are now displaying as mm/dd/yyyy in the gallery.

I'm not sure though why new dates that are added are still defaulting to longer 13 digit figures like 1706680800000?
Verified answer

v-mengmli-msft on 04 Jan 2024 at 01:33:09

Like (0)

Report
Re: Date field passing 13 digit figure

Hi @BlueAndOrange24 ,

Please go back to previous format which shows 45344 and use the following formula:
Text(DateAdd(Date(1900,1,1),Value(ThisItem.DateColumnName)-1,TimeUnit.Days),"mm/dd/yyyy")

Best regards,
Rimmon