Answered

How to Display Seconds in Dataverse Table DateTime Column?

(0) Share

Report

Posted on by Bubufun

Hi everyone,

I'm working on a project, and I'm using Dataverse as the data source for my tables. In my Dataverse table, I have a DateTime column, but it only displays the time down to the minute. I need to display the seconds as well in the Dataverse table to check some specific timing details.

I've tried to change the format and properties of the DateTime column in the Dataverse table settings, but I couldn't find an option to include seconds. Is there a way to configure the display format to include seconds in the DateTime column in Dataverse?

Any guidance or solutions on how to achieve this would be greatly appreciated. Thanks in advance!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-jefferni on at

Like (2)

Report

Hi @Bubufun ,

After searching on the web and doing several tests, I haven't found any way that can achieve your need. There's no option to format a date time column to include seconds. Even calculated columns and formula columns are not supported of doing so.

Sorry about that.

Best regards,

Was this reply helpful? Yes No
Bubufun 49 on at

Like (0)

Report

@v-jefferni It's Ok，Thank you for taking the time to respond to my question. I appreciate your help, even if the issue may not have a solution or support available. Your response was still valuable to me, and I'm grateful for your assistance.

Was this reply helpful? Yes No
jimboer 6 on at

Like (0)

Report

Hi, @Bubufun ,

You can easily use the Dataverse connector within Excel (or Power BI/Power Query).

Was this reply helpful? Yes No