Posts

Validate if a particular Financial Dimension is not null in #MSDyn365FO

Image
In this example, I'm just checking if the "BusinessUnit" dimension is not null or empty.

Get the primary index of a table in X++

Image
Simple method gets you the Primary key index of any table:

Start and Stop Azure VMs Using PowerApps, Power Automate(formerly known as Microsoft Flow), SharePoint and Azure Automation - Part 2

Image
Continuing from my previous post , in this one I’ll go through the other two steps of Power Automate(formerly known as Microsoft Flow) and Power Apps. Power Automate(formerly known as Microsoft Flow) This is a simple three-step workflow. I am using the Azure Automation connector to call the Azure Automation runbooks to start and stop the VMs. The Power App initiates the call Is an Azure Automation connector and the action is Create Job Then the status is returned to the Power App. The status is the VM power state which is either “running” or “stopped” Power App Creating the Power App is as simple you can learn more about Power Apps here . I made use of the Create an app feature on the SharePoint which basically created the app for me and I’ve made a couple of tweaks to make it work for me. These are some of the key features of the Power App that I’ve added which brings everything together: Dropdown which filters the list by Product. I have differ...

Start and Stop Azure VMs Using PowerApps, Power Automate(formerly known as Microsoft Flow), SharePoint and Azure Automation - Part 1

Image
I’ve been trying to figure out how I can manage my Azure VMs using PowerApps. There are probably better ways of doing this so I would like to know your ideas too. I'll take you through what I have done. There are four components to this: SharePoint – this has a list of VMs that I want to control from PowerApps   Azure automation process automation with Runbook and module galleries  – I’m using the runbook for process automation Power Automate(formerly known as Microsoft Flow)  – automate VM start and stop by integrating SharePoint and Azure Automation PowerApps – used to build Azure VM Manager This is basically what my end result looks like: I will break it down into different pieces covering each component separately. 1. SharePoint This is simply just a list of machines that are under my Azure subscription which I wish to control from my PowerApps. You can read more here  about how to create a SharePoint list. In the next step, I'm using A...

HardwareStationSamples error RetailSDK Version 10

Image
While running an MSBUILD on RetailSDK in version 10 I came across an error that didn’t make sense because I wasn’t using it at all. This particular HardwareStationSamples solution would not build in the SampleExtensions . After a little bit of research I found out that the reference was in fact a CRT project. The Assembly prefix had changed to the one I had set up in my customization settings in my BuildTools folder hence the dll name was different. I changed it back to Contoso and rebuilt the CRT solution: CommerceRuntimeSamples.sln, under RetailSdk\SampleExtensions\CommerceRuntime I ran MSBUILD once again… no errors this time around.

Use Dev box as a Build Server in #MSDyn365FO

Image
You will need the following information to run the PowerShell script on your development machine: - ProjectCollection: https://yoursourcecontrol.visualstudio.com/DefaultCollection - AosWebsiteName: "AOSService" - VSOAccessToken: "yourToken" - AgentPoolName: "Default" 1. Open up PowerShell in Administrator mode, change directory to C:\DynamicsSDK and run this command: .\SetupBuildAgent.ps1 -VSO_ProjectCollection https://yoursourcecontrol.visualstudio.com/DefaultCollection -AosWebsiteName "AOSService" -VSOAccessToken "yourToken" -AgentPoolName "Default" This will download the Build agent onto your development environment. 2. Now create a build definition for the project .\BuildEnvironmentReadiness.ps1 -VSO_ProjectCollection https://yoursourcecontrol.visualstudio.com/DefaultCollection -ProjectName "YourProjectName" -VSOAccessToken "yourToken" -AosWebsiteName "AOSService" Yo...

Create and add to a blob storage in MSDyn365FO

Image
This post shows how you can create a Azure blob storage and add files using your Azure storage account from D365FO. I have created a job that finds an attachment on a sales order and uploads it to the Azure blob storage just to show how a simple scenario could work. To begin with, you will need to create your storage account. You can have a look at this article on how to create a blob storage account: Create a storage account Once you have created a storage account you will need the connection string. See below: Next thing is the job. I’ve pasted screenshots below: Once you run the above job and file upload is successful. You’ll find a container named ‘mycontainer’ inside your Azure blob storage and a document that you would have attached on the Sales order record.