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!