Answered

Time Column

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I have a dataverse table which is created from a dataflow which gets data from a CSV file. I have 2 time columns in the csv file and they show the times in 24hour format, however when they come into the dataflow they are converted to 12hour and I can't seem to find where to convert them back? and on top of that when they land in the dataverse table they are in text format !!

I am using them in powerapps gallery where I need to do some calculations based on the times so need them in 24 hour

TIA

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Guido Preite 1,490 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Dataverse has not a time column, this is the reason they got imported as text, you can eventually use a Date&Time column and select a fixed date before doing the import.

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Thanks @GuidoPreite yes I've realised that but how can I change the time field to 24 hour in the dataflow I can't see anywhere to do that?

Was this reply helpful? Yes No
Gowri Halan 262 on at

Like (0)

Report
Copy link

Link copied!

@vffdd When you have created clumn as Date time Dynamics Stores the value in UTC in Data Base. But in the front end it is displayed based on the user setting. You can check you setting like below screenshot.

Was this reply helpful? Yes No
Verified answer

vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

thanks @gowrihalan04 I was actually able to do it at the transform data stage by transforming it to text/locale it seemed to work and gave me the numbers I needed !

Was this reply helpful? Yes No