News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Portal Time Span datat...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

Portal Time Span datatype field to show days, hours, min

(0) Share

Report

Report

Posted on by Prathibha Lakhotia

49

value of datatype- timespan

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Haig Liu Microsoft Employee on at

Like (0)

Report

Portal Time Span datatype field to show days, hours, min

Hi Prathibha Lakhotia,

There is no OOTB way to display the data you describe;

the general practice is to use a workflow to convert the minutes into the corresponding format for display in a text field:

https://d365demystified.com/2021/02/28/duration-field-in-dynamics-365-converts-hours-value-to-days-in-dynamics-365-flow-workaround-to-convert-in-hours-and-mins/

In addition to the workflow, we can also create multiple calculated fields to record the number of days, hours and remaining minutes,

and finally use the CONCAT function to join the first three fields to display in the final field.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
Please feel free to contact me if you have any further questions.
Regards,
Haig

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans