Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / custom field for time ...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

custom field for time of day and data import from excel using flow

(0) ShareShare
ReportReport
Posted on by TylerS.Dev 725

I am in the process of building a custom field for excel import, the source data is decimal in time format (example : 0.524920717594796 , showing as 12:35:53 PM).  I want to build a flow that populates a custom field with this data, my questions is:

1. Should I use decimal as data type for Dynamic 365 field or is there a better option? (I find some article mention using whole number with duration but doesn't really apply to my need)

2. How do I convert this in Dynamic 365 (If I import the data as decimal, how do I format it so that it shows in HH:MM:SS AM/PM format)?

  • TylerS.Dev Profile Picture
    TylerS.Dev 725 on at
    RE: custom field for time of day and data import from excel using flow

    I ultimately decided to pass the data as string and convert it in separate flow as suggested considering there isn't much better option, thank you.

  • Verified answer
    Roma Gupta Profile Picture
    Roma Gupta 725 on at
    RE: custom field for time of day and data import from excel using flow

    Hi Tyler

    I am afraid, there is no OOB way for this. Yes if you really want to store it. You need to have string field & save data. For conversion, you can try for JS/ plugin. I am not really sure when do you want to use this converted data so you need to decide accordingly about the way of conversion.

  • TylerS.Dev Profile Picture
    TylerS.Dev 725 on at
    RE: custom field for time of day and data import from excel using flow

    Hi Roma,

    thanks for the article but it doesn't really answer my question completely.  The source excel file stores time to 16th precision in decimal and dynamic 365 customer engagement only goes to 10th precision so I am looking for the best practice to store this in CRM/365.

    The article provides conversion from time to decimal but the source data is actually decimal, so I need know the best practice to store it first, secondly, should I create another string field and use the decimal to populate time as text or is there another method?  Do I need to write a plugin for this conversion or is there a better OOB way to do this?

  • TylerS.Dev Profile Picture
    TylerS.Dev 725 on at
    RE: custom field for time of day and data import from excel using flow

    Hi Leo,

    I am using Dynamic 365 Customer Engagement, V9 cloud solution.

  • Suggested answer
    Roma Gupta Profile Picture
    Roma Gupta 725 on at
    RE: custom field for time of day and data import from excel using flow

    Hi Tyler

    There is already a thread on NAV & has an answer. See if the links below help:

    community.dynamics.com/.../how-to-convert-time-into-decimal

    docs.microsoft.com/.../dd338899(v=nav.60)

    Regards

    Roma

  • LeoAlt Profile Picture
    LeoAlt 16,329 on at
    RE: custom field for time of day and data import from excel using flow

    Hi partner,

    Are you using Dynamics 365 Nav?

    Best Regards,

    Leo

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans