Skip to main content

Integrate Business Events with Applications using MS Power Automate Flow in D365 FO

Integrate OOTB or Customized Business Events with Applications using MS Power Automate Flow

Dear Consultants,

Based on requirements, we choose integration techniques. Today, we'll discuss the methods we use to trigger a call based on process in D365 FO.

Blog for Pre Process before consuming Customized Business Event : Customized Business Event in D365 FO

Requirements:

  • New employee is getting on board.
  • The outside system should know the on-boarding process has initiated.
  • Dependent processed will trigger based on ERP event
  • CRUD operation should be available using Data entity framework.

Pre- requisites:

  • Data Entity should be available
  • Business Event should be available
  • Permission to create and manage flow should be available on Power Portal.

 

 

Steps:

1) Navigate to Business Events Catalog

Article content

2) Search your OOTB / Customized Business Event & Download the schema

Article content

3) Login to https://make.powerautomate.com/

4) Create a flow

Article content

5) Add a Trigger Event Action for Fin & Ops [Dynamics 365]

Details: Insert a new step in the flow, then search for Fin Ops. In the trigger section, select the business event trigger.

 

Article content

 

Article content

Category must match D365 FO.

Article content

6) Add New step of Data Operation and then select Parse Json. Now Paste the Downloaded json [step 2] and click Generate from sample button.

Article content

You will later see a file generated like this.

Article content

7) Run the Executor from D365 FO or Flow. If the connection works, you’ll see results based on the business event linked to your source. For example, connecting to a data entity will display sample results from that entity in Flow.

Article content

The flow can be used further to automate the processing by adding more steps.

 

Hope you find this blog helpful!

Shayan Arshi

Comments

Post a Comment

Popular posts from this blog

Update record set using update_recordset in d365 F&O | AX 2012 using X++

Hello Devs! One the most common condition that we being a developer faces is to update existing records set that is mostly done on report level when we need to add new fields in the Temporary table and we don't wants to make extensions on class level. Here is a small piece of code that will assist you in updating existing record sets.  update_recordset custAgingReportTmp                 setting                 CMTCustInternalCollector = hcmWorker.PersonnelNumber,                 PaymDayId                         = custTable.PaymDayId,                 PaymTermId                       = custTable.PaymTermId,                 CashDisc      ...
1 comment
Read more

Import DB backup from .BacPac file in D365 F&O using CMD

Hello Devs! This is one of the most quickest way to import DB from .Bacpac file. Bacpac files are those which are generated from Tier 2 or higher environments as a DB backup.   Alternate Approach ----> Using wizard Prerequisites: 1) Access to LCS folder Asset library --> Database Backup Incase you don't see the folder ask your project owner to give you the access. Step 1:  Download the file and save it in local non-user directory.  Step 2: Download SqlPackage.Exe.  Download link :  https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver15 Extract it and Open CMD as admin.  Step 3 :  Navigate to directory where you have extracted the SqlPackage.Exe folder using cmd and execute the command. In my case the command look like this, C:\SqlPackageExe>SqlPackage.exe /a:import /sf:C:\DB\AFP-D365-UATbackup.bacpac /tsn:LOCALHOST /tdn:AxDB /p:CommandTimeout=6000 /TargetEncryptConnection:False Note: You can repla...
Post a Comment
Read more

Upload and Download file to BLOB storage Account in D365 F&O using X++

Hello Devs! This blog will be a source of help for many Devs who are working on Azure Blog Storage account. We normally use azure blob storage account to hold thing that need to be further processed and stored on cloud. Scenario:  We have been asked to * Upload file to azure * Download file from azure "We will be using Share File Management technique" Case #1 : Uploading File to Azure  Note : Here we are using  PurchParameter  table to extract urls and other folder related details you can use your own folder name to access the azure blob folder Further, Credential details have already been extracted i.e vault key,authorization key and has been stored in our custom table and extracted from d365 through azure parameters  storageCredentials  = new Microsoft.WindowsAzure.Storage.Auth.StorageCredentials(SystemParameters::find().CMTStorageAccountName, purchParameters.CMTTankKeyVaultSecret); Or alternatively, CloudStorageAccount storageAccount = ...
1 comment
Read more