Change based alerts using Microsoft Flow

Rob showed how to make Date Based Alerts using Microsoft Flow. So this is a great start into the future of the still missing AX alerts. But of course we want change based alerts for example to be informed about a sales order that has been processed. It does not take to long to find out that this is still not possible in the way it has been in the past. However you can get a message once the sales order reaches a certain status:

You see that the sales order is hard coded and once the sales order status has changed, you will receive an email every day. So why not use your Android Flow App to disable or delete the Flow?


Mass changes to Number Sequences in Dynamics 365 for Operations

Get Microsoft Dynamics Office Add-in for Excel 2016

Open Number sequences in Excel

In D365fO go to Organization administration > Number sequences > Number sequences

Press Office Button > Open in Excel

Add format field to Excel

In Excel add the Format field. (Note: add the Name Field as well! Otherwise it will be reset.)

Edit data

Change the format as desired (e.g. remove the dash using excel search & replace)


Press Publish

Advanced Filter/Sort in D365 1611 (November 2016)


  • I want to filter the released products by “Tracking dimension group”
  • In AX 2012 R3 I right-clicked on the field I wanted to search by, selected “Filter by field” and added entered the search-text.

Steps in D365

What doesn’t work

  • A right mouse click doesn’t allow me to filter.
  • The filter tab doesn’t allow me to filter by “Tracking dimension group”

Use “Advanced Filter/Sort”

  • This does not differ from AX 2012, but the shortcut of AX 2012 is sorely missed
  • Open “Advanced Filter/Sort”

  • Add Tables

  • Add filter field

  • Hey presto!