Use New Scheduled Board for Dynamics 365 Field Service | Personal and Org Level

Now, the New Schedule Board is now in GA. And here’s how you can turn it on for yourself.

Here’s the old one which you have –

Enable New Schedule Board for Yourself

Here’s how you enable the new Schedule Board for Dynamics 365 Field Service

  1. Navigate to the Schedule Board itself like you would do generally. And you’ll find the New Schedule Board button to turn on.

  2. And in a moment, the new Schedule Board is available to you.
    Note that this is only available to you and not for others.

  3. Everyone else will continue to see the old board unless they turn it on themselves.

Enable New Schedule Board for your Org

Now, if you have only enabled the Schedule Board for yourself and after you found it useful and exciting, here’s how you can enable it for the Org as well which is turned off by default –

  1. Navigate to the Resource Scheduling App in your D365 Field Service environment.

  2. In the Resource Scheduling App, you’ll change the Area to Settings as shown in the bottom and then, go to Administration and look for Scheduling Parameters.

  3. Here, you’ll find the setting to turn on the New Schedule Board which is turned off by Default.

  4. You can turn it on and Save the record itself.

  5. After it is turned on, all the Users will see the new Scheduled Board. Also, no will see the toggle to turn it off for themselves since you turned it On for the entire Org.
    The button to toggle between Old and New Schedule Board will be missing.


Here’s the official Microsoft Documentation on the new Schedule Board – https://docs.microsoft.com/en-us/dynamics365/field-service/preview-schedule-board?WT.mc_id=DX-MVP-5003911

Hope this helps!

Here are some Power Automate posts you want to check out –

  1. Showing Sandbox or Non Production Apps in Power App mobile app
  2. Create a Power Apps Per User Plan Trial | Dataverse environment
  3. Install On-Premise Gateway from Power Automate or Power Apps | Power Platform
  4. Co-presence in Power Automate | Multiple users working on a Flow
  5. Search Rows (preview) Action in Dataverse connector in a Flow | Power Automate
  6. Suppress Workflow Header Information while sending back HTTP Response in a Flow | Power Automate
  7. Call a Flow from Canvas Power App and get back response | Power Platform\
  8. FetchXML Aggregation in a Flow using CDS (Current Environment) connector | Power Automate
  9. Parsing Outputs of a List Rows action using Parse JSON in a Flow | Common Data Service (CE) connector
  10. Asynchronous HTTP Response from a Flow | Power Automate
  11. Validate JSON Schema for HTTP Request trigger in a Flow and send Response | Power Automate
  12. Converting JSON to XML and XML to JSON in a Flow | Power Automate

Thank you!

Upload documents more than 50MB to SharePoint in Dynamics 365 | Quick Tip

Currently, Dynamics 365 SharePoint Integration document limit is 50MB.

And if you try to upload a Document greater than 50MB, it’ll give you the below error –

So here’s what they mean by directly uploading to SharePoint, in case you are new to Dynamics and don’t know if you can access SharePoint directly from Dynamics.

Quick Tip

Here’s how you can upload larger files greater than 50MB –

  1. In the Documents tab, you’ll see the

  2. This will take you to the SharePoint location in the new tab which this Document folder points to –

  3. And you can choose to upload your file –

  4. And your file will be uploaded even if it’s larger than 50MB

  5. And the same will be reflected in Dynamics’ Document grid on the record as well.

Hope this was helpful! Here are some more Dynamics 365 posts which you might be interested in –

  1. Enable SharePoint Online integration Dynamics 365 | Power Platform Admin Center
  2. Dynamics 365 Storage Utilization | Dataverse Storage | Power Platform Admin Center
  3. Use Hierarchy in Roll Up Fields in Dynamics 365 CRM
  4. Filter records in a View owned by a Team you are a member of | Dynamics 365 CRM
  5. Get GUID of the current View in Dynamics 365 CRM JS from ribbon button | Ribbon Workbench
  6. Dynamics 365 App For Outlook missing on SiteMap in CRM? Use shortcut link [Quick Tip]
  7. Import lookup referencing records together in Dynamics 365 CRM | [Linking related entity data during Excel Import]
  8. Excel Importing Notes (Annotation) entity in Dynamics 365 CRM
  9. Enable/Disable the need to Approve Email for Mailboxes in Dynamics 365 CRM CE
  10. Call Azure Function from Dynamics 365 CRM using Webhooks
  11. Show Ribbon button only on record selection in Dynamics CRM
  12. Accessing multiple occurrences of a field in Business Process Flow using JS in D365 CRM

Thank you!!

Pinning Records in Dynamics 365 CRM in Unified Interface [Quick Tip]

A small but super useful feature is to be able to access pinned records which you frequently visit / need to visit.

Pinning Records

Here’s how you pin records in Dynamics 365 CRM –

  1. In your left-hand-side of the navigation pane, you’ll see Recents and Pinned section.
    Right away, no records are pinned. You can pin records from Recent items only at this point.

  2. If you expand the Recents section, you can hover over the records to find the pin appear on the records which you want to pin.

  3. Once you pin them, they’ll appear in your Pinned area. Since you Recent records would change over time as you continue to access different records.

  4. In case you want to remove this, you can also unpin by clicking on the unpin icon as shown below

  5. Good thing is that pinned records are available all other Apps as well.
    So you could be in any App and you’ll retain all the Pinned items

Hope this was helpful! Here are some more Dynamics 365 posts which you might be interested in –

  1. Use Hierarchy in Roll Up Fields in Dynamics 365 CRM
  2. Filter records in a View owned by a Team you are a member of | Dynamics 365 CRM
  3. Get GUID of the current View in Dynamics 365 CRM JS from ribbon button | Ribbon Workbench
  4. Dynamics 365 App For Outlook missing on SiteMap in CRM? Use shortcut link [Quick Tip]
  5. Import lookup referencing records together in Dynamics 365 CRM | [Linking related entity data during Excel Import]
  6. Mailbox Alerts Hide/Show behavior in Dynamics 365 CRM
  7. Excel Importing Notes (Annotation) entity in Dynamics 365 CRM
  8. Enable/Disable the need to Approve Email for Mailboxes in Dynamics 365 CRM CE
  9. Call Azure Function from Dynamics 365 CRM using Webhooks
  10. Show Ribbon button only on record selection in Dynamics CRM
  11. Accessing multiple occurrences of a field in Business Process Flow using JS in D365 CRM

Thank you!!

Use Hierarchy in Roll Up Fields in Dynamics 365 CRM

Here is the use of Use Hierarchy in Dynamics 365 CRM Roll-up Field’s Use Hierarchy option when defining the logic of the Roll-up fields.

Scenario

Let’s consider this out-of-the-box scenario where an Opportunity Rolls up Est. Revenue to the Account it is tagged to. Also, that Account also has another Account set in the Parent Account field.

So, the hierarchy here is Account (Parent Account) -> Account (child Account) -> Opportunity

Now, our demonstration of Use Hierarchy will show where does the Open Revenue (field on the Account) should Roll up from it’s own Account or from the Opportunity of the child Account’s Opportunity as well.
You’ll see a Hierarchy Icon to all records that participate –


And when you select either of them, you’ll be able to click on View Hierarchy button on the view’s Ribbon


This will show you how the Accounts are arranged in hierarchy


And here’s where you can access your Hierarchy Settings

Let’s see!

Use Hierarchy in Roll Up fields

Here’s how you would see the option to switch between Use Hierarchy in the Roll Up fields in Dynamics 365 –

Use Hierarchy: YES

Now, assuming this is set to Yes and it selects the OOB relationship that defined this hierarchy

  1. Consider the child Account “Alpine Contoso” (This is a child account of “Alpine Ski House Main“)


  2. And this Account Alpine Contoso has it’s own Opportunity worth of $25K


  3. Now, let’s look at the Alpine Ski House Main‘s Opportunity which is worth $30K

  4. Now, the Open Revenue for this child Account “Alpine Contoso” is $25

  5. However, since we are using Hierarchy as YES and selected the relationship between the self-lookup of Account itself, this value will also add up to the Open Revenue of the parent Account “Alpine Ski House Main” is $30K + $25K = $55K


    Here, we saw that the Open Revenue from the child Account too Rolled up to the Parent Account.

Use Hierarchy: NO

Assuming, the Roll-up field is now set to NO to Use Hierarchy, let’s see the difference on the Parent Account “Alpine Ski House Main” itself.

  1. If we look at the Alpine Ski House Main‘s Open Revenue value, it’ll only have $30K


  2. This $30K belongs to it’s own child Opportunity and not child Account i.e. Alpine Contoso‘s Opportunity.

Hope this was helpful! Here are some more D365 posts which you might be interested in –

  1. Filter records in a View owned by a Team you are a member of | Dynamics 365 CRM
  2. Get GUID of the current View in Dynamics 365 CRM JS from ribbon button | Ribbon Workbench
  3. Dynamics 365 App For Outlook missing on SiteMap in CRM? Use shortcut link [Quick Tip]
  4. Import lookup referencing records together in Dynamics 365 CRM | [Linking related entity data during Excel Import]
  5. Mailbox Alerts Hide/Show behavior in Dynamics 365 CRM
  6. Excel Importing Notes (Annotation) entity in Dynamics 365 CRM
  7. Enable/Disable the need to Approve Email for Mailboxes in Dynamics 365 CRM CE
  8. Call Azure Function from Dynamics 365 CRM using Webhooks
  9. Show Ribbon button only on record selection in Dynamics CRM
  10. Accessing multiple occurrences of a field in Business Process Flow using JS in D365 CRM

Thank you!!

Recommendation in Business Rules in Dynamics 365

Here’s a super-useful feature to describe a field in case the user is not sure if they should manipulate the field in any way or not.

In Dynamics 365 Business Rules, here’s how you can add Recommendations based on the condition selected in the Business Rules.

Scenario

Here’s the scenario we will use to demonstrate Recommendation –

  1. If my custom field called as “Context” on the Contact entity says – Customer, then, recommend the User to enter a US phone number in Business Phone field.
  2. Also, if the user choses to Apply the Recommendation, the Preferred Method of Contact will also be set to Phone.

Add Recommendation

Here’s how you can add a Recommendation post you condition in a Business Rule.

  1. In Business Rules, let’s say you will first set the condition.
    Here, I’m setting the value to check is Context = Customer


  2. If the Context field is set to Customer, then, show a recommendation. Here’s how you add a Recommendation


  3. Once you add a recommendation, you can set as to what it should point the recommendation to – In my case, I’m pointing to a Business Phone field.
    Now, the field I chose is Business Phone
    The Recommendation Title is the one that will be shown in bold when Recommendation bulb is clicked.
    The Recommendation Details will describe the Recommendation itself.
    Post this, expand the Details to add the Action to take under the Recommendation


  4. Once you apply the Recommendation Properties, it is also mandatory to add an Action – Else, the Business Rule won’t be enabled.
    In action, I want to set the value Email in the field Preferred Method of Contact.


    And the properties on the right hand side are –
    Preferred Method of Contact field to set to Phone


  5. Once all the changes are applied, you can simply Activate the Business Rule and test the same.

Working

Here’s an example –

  1. On Contact, notice the Business Phone field appears like a normal field.
    Notice the Context field says Marketing Only for now, I’ll update this in the next step.


  2. Now, I’ll select Customer

  3. When I do this, a Bulb appears next to Business Phone, click on it.


    When I click on it – The area will show the recommendation with the Title and the Recommendation I entered in the Business Rule step
    [Notice that the Preferred Method of Contact still says ‘Any’]. This will be changed when I click Apply.


  4. And when I click Apply, the Preferred Method of Contact will be set to Phone.


    Hope this was useful!

Here are some more posts on Dynamics 365 which you might want to check –

  1. Retrieve Metadata of Global OptionSets from Dynamics 365 in Power Automate | HTTP with Azure AD action
  2. Single record and multiple record auditing in Dynamics 365 to Audit record access | M365 Compliance
  3. Enable Plug-in Profiler in Settings area in SiteMap in Dynamics 365 | [Quick Tip]
  4. Disable Recent Records from Dynamics 365 Lookup Control | Model-Driven Apps [Quick Tip]
  5. Language format for Whole Number field in Dynamics 365 CE
  6. Custom Help Pages and Guided Tasks for Unified Interface in Dynamics 365
  7. Make Managed fields Required in Dynamics 365 – Managed Properties Error [Workaround] | D365 CE Quick Tip
  8. Sign up for a Dynamics 365 Project Operations (Lite Deployment) environment and provision a new instance | Power Platform
  9. Form Access Checker in new Power Apps Form Designer | Model-Driven Apps in Dynamics 365
  10. New App Designer for Model-Driven Apps | Power Platform

Thank you!

Disable Recent Records from Dynamics 365 Lookup Control | Model-Driven Apps [Quick Tip]

Let’s take a quick look on how you can disable the Recent Records from a Lookup Control in Model-Driven Apps

Scenario

By Default, here’s how the Recent Records are shown for a Lookup control –

And it’ll show all the Recent Records for the Entity

Form Settings

Here’s how you can disable the same in Form Settings for the Lookup Control –

  1. On the Field’s Properties, Disable this option called – Publish your changes and then check


  2. And then the Recent Option will be gone.

Hope this was useful!

Here are Canvas Power Apps / Model-Driven Apps which you might like –

  1. New App Designer for Model-Driven Apps | Power Platform
  2. Rich Text Control for Canvas and Model-Driven App | Quick Tip
  3. Form Access Checker in new Power Apps Form Designer | Model-Driven Apps in Dynamics 365
  4. How to add Rating Values to Rating Models in D365 Field Service and PSA
  5. Language format for Whole Number field in Dynamics 365 CE
  6. Custom Help Pages and Guided Tasks for Unified Interface in Dynamics 365
  7. Filter records in a View owned by a Team you are a member of | Dynamics 365 CRM
  8. Show custom ribbon button based on Security Role of the logged in User in Dynamics 365 | Ribbon Workbench in XrmToolbox
  9. Duration field in Dynamics 365 converts Hours value to Days in Dynamics 365 | [Flow Workaround to convert in Hours and Mins]
  10. Find deprecated JS code used in your Dynamics 365 environment | Dynamics 365 v9 JS Validator tool | XrmToolBox

Thank you!

Language format for Whole Number field in Dynamics 365 CE

If you create a Whole Number field in Dynamics 365 CE environment, you’ll notice a Format which is available for you to choose i.e. Language among other formats like None, Duration, Time Zone.

Let’s see what the field is and what it stores.

Language

  1. Let’s say you are creating a field on the Contact i.e. Preferred Language.


  2. And, it is represented in the below way – like a Drop Down



  3. Now, if you wonder which all Languages are displayed? Well, the ones which are Enabled for the D365 Organization are displayed in the Drop-down. They simply are set as data and doesn’t affect the record apart from the data value itself.

    So, if you go to the Settings > Languages


    Any other language apart from the Base Language of the Organization which is enabled is considered.


    You’ll find all the Microsoft Locale IDs here: https://docs.microsoft.com/en-us/previous-versions/windows/embedded/ms912047(v=winembedded.10)?WT.mc_id=DX-MVP-5003911

Data

Now, let’s see what the field stores.

  1. I’ve written a short JS to pick what the field has stored as data. When I debugged, here’s what the field holds.
    It stored


  2. Also, if you try to set data which is not enabled i.e. tried to set Language which is not enabled for your Dynamics 365, you’ll see the below validation error which says that the value is out of the allowed range.

Hope this post was useful!

Here are some more posts for Dynamics 365 Customer Engagement / CRM you might find useful!

  1. Custom Help Pages and Guided Tasks for Unified Interface in Dynamics 365
  2. Make Managed fields Required in Dynamics 365 – Managed Properties Error [Workaround] | D365 CE Quick Tip
  3. Sign up for a Dynamics 365 Project Operations (Lite Deployment) environment and provision a new instance | Power Platform
  4. Filter records in a View owned by a Team you are a member of | Dynamics 365 CRM
  5. Duration field in Dynamics 365 converts Hours value to Days in Dynamics 365 | [Flow Workaround to convert in Hours and Mins]
  6. Show custom ribbon button based on Security Role of the logged in User in Dynamics 365 | Ribbon Workbench in XrmToolbox
  7. Form Access Checker in new Power Apps Form Designer | Model-Driven Apps in Dynamics 365
  8. Connecting XrmToolBox to an MFA enabled Dynamics 365 environment | Azure AD
  9. Make On-Demand Flow to show up in Dynamics 365 | Power Automate
  10. Find deprecated JS code used in your Dynamics 365 environment | Dynamics 365 v9 JS Validator tool | XrmToolBox

Thank you!!

Custom Help Pages and Guided Tasks for Unified Interface in Dynamics 365

Formerly, Learning Path – A complete new overhaul for guided help is Custom Help Panes in Dynamics 365



Enable Custom Help Panes

Access your System Settings for enabling this feature in your organization –

  1. Go to Settings > Administration > System Settings. Then switch “Enable Custom Help Panes and Guided Tasks” to Yes if already set to No.


Creating Custom Help Panes

Let’s see how you can configure these Custom Help Panes in your Dynamics 365 CE environment for different environments –

  1. For example, for Contact entity, if you navigate to the Question Mark option on your top navigation bar, a Custom Pane will show up. If the above System Settings is not turned on, it’ll navigate to Microsoft Docs instead.

  2. It’ll expand the Pane as follows. You can then click on the three vertical dots as shown and click on Edit –

  3. Once you Edit, you’ll open the Custom Help Pane editor on which you can start configuring the Help Pane.
    You can Start Editing the Pane. You can start by entering the Title and then move down to add different Help items to the Pane.

  4. Now, I’ve added Title of the Page to Contact Help. You’ll see Save button at the button where you can Save the progress. Now, I’ll go to Insert and add a Section.
    The first item is Insert a Section.


  5. Open clicking Insert Section, I can add a title to it. Now, I’ll label this section as General.
    And it will appear as below.



    Now, you can click inside the General section and can add rest of the items there.

  6. Next, I’ll insert a Link into the General section.


    And I’ll complete the below Info for the Link.


    It’ll appear as below –

  7. Next, I’ll Edit the Pane again. And select Coachmark.


    And add Coachmark details as follows –


    Now, you can drag to where the Coachmark should be highlighted when clicked.

    Now, when you click on the generated Link, the coachmark will prompt.


  8. Next, let’s insert a Balloon.


    Enter details on the Balloon like the Link title, actual Title as it should appear on the Balloon and the Details it should read out. Finally, drag the Balloon to the element.


    And here it drag it to a relevant field.


    And finally, when the link is clicked in the Pane, the Balloon will appear as below.







  9. Next, Let’s insert a Video.


    And enter the URL of the video and set preferences accordingly.


    Once Inserted, it’ll look like below.


  10. Now, the final Items which we will insert here is an Image.


    And it’ll ask me for a Image URL which is accessible over the Internet.


    And it’ll appear as below –





    I’ve also added a YouTube video explaining the above steps in case anything from the above was not already clear –

Help Page record

In Dynamics 365, the Help Page record looks as follows if you do an Advanced Find –


You can even move this between environments within solutions itself. You can test this out in the new make.powerapps.com Solutions and Add an Existing Help Page as shown below –

Hope this was helpful!

Here are more Dynamics 365 CE/CRM posts you might want to check out –

  1. Sign up for a Dynamics 365 Project Operations (Lite Deployment) environment and provision a new instance | Power Platform
  2. Make Managed fields Required in Dynamics 365 – Managed Properties Error [Workaround] | D365 CE Quick Tip
  3. Sign up for a Dynamics 365 Project Operations (Lite Deployment) environment and provision a new instance | Power PlatformFilter records in a View owned by a Team you are a member of | Dynamics 365 CRM
  4. Duration field in Dynamics 365 converts Hours value to Days in Dynamics 365 | [Flow Workaround to convert in Hours and Mins]
  5. Show custom ribbon button based on Security Role of the logged in User in Dynamics 365 | Ribbon Workbench in XrmToolbox
  6. Connecting XrmToolBox to an MFA enabled Dynamics 365 environment | Azure AD
  7. Form Access Checker in new Power Apps Form Designer | Model-Driven Apps in Dynamics 365
  8. Use Rich-Text Control for Multiple Lines of Text in Dynamics 365 CE | Quick Tip
  9. Ribbon button visibility based on a field value in Dynamics 365 | Ribbon Workbench
  10. Find deprecated JS code used in your Dynamics 365 environment | Dynamics 365 v9 JS Validator tool | XrmToolBox
  11. Make On-Demand Flow to show up in Dynamics 365 | Power Automate
  12. Track and Set Regarding are disabled for Appointments in Dynamics 365 App For Outlook message | Demystified

Thank you!!

Make Managed fields Required in Dynamics 365 – Managed Properties Error [Workaround] | D365 CE Quick Tip

On some instances, there are Managed fields in Dynamics 365 CRM (or CE if you want to call it) where we can’t change the required level of the field from Fields i.e. on the database level. And you get the below error –

Here’s an alternative way to do it.

Scenario

Let’s consider this scenario.

  1. Although Microsoft suggests you don’t change the behavior of Managed fields since they are designed with a purpose. However, let’s consider this scenario where you want to make the Parent Account for Lead as required on the form.
    When you try to change the Requirement Level as follows




  2. And while saving this change, you get this error.


    So how do we do it? Let’s see.

Workaround – Business Rule

Now, to overcome this particular scenario you can implement a simple Business Rule to make it required as follows –

  1. If the field can’t be made Required on a database level, you can make it required on the form using Business Rule. Here’s how you create your Business Rule.
    As the Business Rule starts with the condition, here’s the check you need to add in case the field value is not entered.


    The condition I used is as below – Check if Parent Account for lead Does Not Contain Data

  2. If this is True, then go ahead and add a Step for True condition. Add Set Business Requirement Level

  3. And in this, you need to set the Business Required Status to Business Required as show below.

  4. And the result is the Business Rule which looks like in #1 above. Now, save your changes, Publish the Rule, Activate and check.
  5. The result will be that the field is not required once it doesn’t have data forcing the user to enter data for the same.

Hope this was helpful! Here are some more D365 posts which you might be interested in –

  1. Filter records in a View owned by a Team you are a member of | Dynamics 365 CRM
  2. Get GUID of the current View in Dynamics 365 CRM JS from ribbon button | Ribbon Workbench
  3. Dynamics 365 App For Outlook missing on SiteMap in CRM? Use shortcut link [Quick Tip]
  4. Import lookup referencing records together in Dynamics 365 CRM | [Linking related entity data during Excel Import]
  5. Mailbox Alerts Hide/Show behavior in Dynamics 365 CRM
  6. Excel Importing Notes (Annotation) entity in Dynamics 365 CRM
  7. Enable/Disable the need to Approve Email for Mailboxes in Dynamics 365 CRM CE
  8. Call Azure Function from Dynamics 365 CRM using Webhooks
  9. Show Ribbon button only on record selection in Dynamics CRM
  10. Accessing multiple occurrences of a field in Business Process Flow using JS in D365 CRM

Thank you!!

Duration field in Dynamics 365 converts Hours value to Days in Dynamics 365 | [Flow Workaround to convert in Hours and Mins]

This must be one of the most common scenarios Dynamics 365 Users must’ve come across. The Whole Number’s Duration field shows Duration in Days once it crosses 24 hours, it shows the Duration in Days. Like below –

And once you leave the control, it’ll be converted to it’s equivalent Days conversion

But if you click on it, you can in fact see the Hours

However, It’s not ideal to click on the field and check the Hours on the form. Also, this doesn’t work in case the field is seem from a View on the entity. Unfortunately, we can’t change this behavior. So, to have a workaround, I created a new field to store the translated value.

Hope this implementation is useful to you. In case of any better ideas, kindly suggest in the comments and I’ll be happy to update this post in order to serve full purpose. 😊
To understand the core conversion using long division, refer this post – https://www.calculatorsoup.com/calculators/conversions/minutes-to-hours.php

New Single Line of Text Field and a Flow

Let’s look at how the implementation is –

We’ll need to also review the following Logic Apps’ Math Functions to understand how to apply them – https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#math-functions?WT.mc_id=DX-MVP-5003911

Also, to understand how to read data from triggerOutputs(), check this post – Using triggerBody() / triggerOutput() to read CDS trigger metadata attributes in a Flow | Power Automate

  1. I’ve created a new Single Line of Text field called as Time In Hours (cf_timeinhours) which will hold the translated Hours & Minutes. Making the field as Read-Only is recommended so that no one changes it on the form post update.


  2. Now, here’s a Flow (You can configure it either on demand for existing records of on Create/Update of the Duration field which itself to calculate once the value is changed field). Just for example’s sake, my field is on Contact and hence, I’m triggering the Flow on Update of the contact on the change of the Avg Turnaround Time (Whole Number of format Duration) field.


    See, that the Body of the step will have the Avg Turnaround Time field storing the duration in minutes.


  3. First actions is to use Divide to get the Hours. I’m creating a variable called as Divide To Get Hours of type Float.


    Here’s how the div function included above looks like –



    Formula is: div(triggerOutputs()?['body/cf_avgturnaroundtime'],60)
    Explanation: Duration field in Dynamics 365 stores Minutes. First, we divide these minutes by 60 to get the Hours value.
    If you divide 3375/60, you get 56.25. But the Div will give you the Integer value. (The right way to divide to get exact float is to also store the 60 in a variable and then work with variables. See this post https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-receive-decimal-number-result-after-dividing/td-p/195399) However, in this case, we anyway need to 56 part, so this is fine for now.

  4. Next, we’ll multiply the result of the Hours we got from the step above i.e. Divide to Get Hours.


    Here’s how the Mul function looks –


    Formula is: mul(60,int(variables('Divide to Get Hours')))
    Explanation: Now, we multiple the result of the Divide to Get Hours. This will be used to subtract from the actual value of Avg Turnaround Time field.
    Here, we multiple 60 x 56 = 3360 and get 3360

  5. Finally, to get Minutes, we use the third variable that uses a Sub function


    The Sub function looks like below –


    Formula is: sub(triggerOutputs()?['body/cf_avgturnaroundtime'], variables('Number to Subtract From'))
    Explanation: Now, we subtract the result of the Number To Subtract step from the value of the Duration field i.e. Avg Turnaround Time field itself. These will be the minutes.
    Now, to get the minutes we subtract the result of the Number to Subtract from the actual minutes value of the duration field i.e. 3375 – 3360 = 15. These are your minutes!


  6. Final step is to simply arrange it in a String (you can also form the string elsewhere directly and skip the below)

  7. And to make sense of this conversion, I’ll update the field on the record to show what the converted Hours and Minutes is.

  8. Here’s the final result once the Flow runs successfully.

Hope this helps! You might always want to check more Power Automate / Dynamics 365 posts –

  1. Office 365 Outlook connector in Cloud Flows showing Invalid Connection error | Power Automate
  2. FormatDateTime function in a Flow | Power Automate
  3. Formatting Approvals’ Details in Cloud Flows | Power Automate
  4. Trigger Conditions not working in a Cloud Flow? Here’s Why | Power Automate Quick Tip
  5. Read OptionSet Labels from CDS/Dataverse Triggers or Action Steps in a Flow | Power Automate
  6. InvalidWorkflowTriggerName or InvalidWorkflowRunActionName error in saving Cloud Flows | Power Automate Quick Tip
  7. Store ‘Today’s Date’ in a field to use in workflow conditions in D365 CE
  8. Create a Team, add Members in Microsoft Teams upon Project and Team Members creation in PSA / Project Operations | Power Automate
  9. Setting Lookup in a Flow CDS Connector: Classic vs. Current Environment connector | Power Automate Quick Tip
  10. Using outputs() function and JSON Parse to read data from missing dynamic value in a Flow | Power Automate
  11. Run As context in CDS (Current Environment) Flow Trigger | Power Automate
  12. Adaptive Cards for Teams to collect data from users using Power Automate | SharePoint Lists

Thank you!