PowerApps allows the use of Excel workbooks as data sources, and they can be located on a Microsoft account’s OneDrive instance or Onedrive for Business (OfB) using an organisational (work / school) account. Different connectors are available to support these two scenarios: Excel Online (Onedrive) Excel Online (Business) I wanted to connect to an Excel…
Where is the user provisioning tool on D365FO dev VMs?
Something so simple, but something that I always have to find when I have a new dev VM: where is the location of the user provisioning tool? C:\AOSService\PackagesLocalDirectory\Bin\AdminUserProvisioning.exe I’ve never found a concise post listing this location. Time to change that!
Storage and display of dates and times in Dynamics 365 for Finance and Operations (D365FO)
The D365FO platform is designed to be a multi-region solution, implying that it can be implemented across multiple time zones. To support this, the platform has built in functionality to rationalise the storage and display of date time values. Platform and SQL Server data types The D365FO database can store date / time values in…
D365FO 10.0.x: where has the Trace menu item gone?
AX7, Dynamics AX and Dynamics 365 for Finance and Operations (D365FO) have an in-application trace feature that allows users with either sysadmin or “System Trace User” roles assigned to capture an ETW log of system events from the AOS instance they’re attached to. Up to version 8.1.3, this could be found at the following location:…
Building an IoT temperature sensor with a Raspberry Pi
Whilst away on holiday earlier in the summer, I decided that I’d investigate how to put together an IoT device based on a Raspberry Pi to gather environmental data, initially temperature only but then moving on from there as I become more familiar with putting the hardware together. I found a tutorial online, and ordered…