Unanswered

Date/Time Output to Excel Format

(0) Share

Report

Posted on by DP-23122227-0

I'm at a loss...

The data in the column is formatted as 'DD/MM/YYYY HH:MM'. This means that the form in PowerApps uses (it's poor excuse of) a 'Date/Time Picker'.

I'm using PowerApps to add data in to the column, needing to be the 'current time' at the time the form is submitted'.

I've got as far as using the formula 'Now()' as the default value, but nothing I do seems to format it as above - Instead it comes out as '2024-12-23T22:26:00.000Z'.

How do I change this to be the same as the format above? It's ruining all of the calculations I have going on in the spreadsheet.

Hopefully I've explained that well enough... I'm fairly new to PowerApps and haven't done any proper programming since Visual Basic 6!

Categories:

Using Apps Using Formulas

Connecting to Data

I have the same question (0)

All responses (2)

Answers (0)

Fardy_MADI_2 332 Super User 2024 Season 1 on at

Like (0)

Report
Date/Time Output to Excel Format

Hi @DP-23122227-0,

You can use the Text function to format your date :

Text(Now(), "dd/mm/yyyy hh:mm")

Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up

Was this reply helpful? Yes No
WarrenBelz 151,883 Most Valuable Professional on at

Like (0)

Report

Date/Time Output to Excel Format

Hi @DP-23122227-0

Firstly @Fardy1 is correct if you have your Excel column formatted as Text - the problem there is that all your Excel "calculations" will not work in the concept of date references.

If you have the column formatted as a Date, then Now() should work in your Patch. The fundamental issue though is that Excel is really a "data source of last resort" and you may likely encounter a lot more challenges than this compared with using (for example) SharePoint Lists for your data.

Was this reply helpful? Yes No