Category Archives: Logic Apps

Execute Actions in ODATA Entities & CALLING IN MICROSOFT Flow/Power Automate/Logic Apps

Requirement –

  1. Developing & adding actions on OData entities of Microsoft Dynamics 365 finance and operations
  2. Consuming and calling Data entity action in Microsoft Flow or Logic Apps Or Microsoft Power Automate

Development-

  • Create or develop a custom data entity. Read More:
  • Add a new method in your custom data entity by using Attribute -SysODataActionAttribute & SysODataCollectionAttribute
[SysODataActionAttribute("demoExecuteActionListParm", true),
        SysODataCollectionAttribute("InventSiteIdList", Types::String),
     SysODataCollectionAttribute("return", Types::String)]
    public str demoExecuteActionListParm(List InventSiteIdList)
    {
				str	siteCommaSeperated;
				List list = new List(Types::String);
				ListEnumerator  ListEnumerator;
				ListEnumerator = InventSiteIdList.getEnumerator();
				while (ListEnumerator.moveNext())
				{
          siteCommaSeperated += strFmt('%1, ', ListEnumerator.current()) ;
				}

				return '200 OK:Testing Of Odata Entity ExecuteAction has been completed!! Values = ' + siteCommaSeperated;
    }
  • Build and synchronize your project
  • Test your flow and get response successfully.

D365 FO & MS Forms Pro Survey Integration : Send & Save Survey Responses using Microsoft Power Automate/Microsoft Flow/Azure Logic Apps

  • Objective – Microsoft Dynamics 365 (Finance & operations) & Forms Pro Survey Integration : Send and Save Survey Responses using Microsoft Power Automate/Microsoft Flow/Azure Logic Apps.
  • Scenario – Organisation wants to send Employee Satisfaction Survey to their employees via email. Employee will complete the survey . Survey Responses should be store and save in Microsoft Dynamics 365 Finance & operations.
  • Technologies/Products – Microsoft Form Pro(Free 30 Days Trial), Microsoft Dynamics 365 Finance & operations, Microsoft Power Automate(Microsoft Flow/Azure Logic Apps).
  • Prerequisite – Before moving ahead individual must go and see my old post on Microsoft Forms i.e. Microsoft Forms : Create a Survey Form From Scratch. Individual should have knowledge of Microsoft Power Automate(Microsoft Flow/Azure Logic Apps) & Dynamics 365 Finance & operations development.
  • Send Survey – Login to Microsoft Power Automate/Microsoft Flow/Azure Logic Apps. Create a Microsoft Flow for sending Employee Surveys to the employees of the company . In this scenario i am using a custom data entity of Employee master which is returning fields – Employee Code & Employee Email, Employee. You can use your own data entity as per your requirement and business need. I am reading all the Employee records and sending surveys in their email. You can add more conditions as per your business need. For demonstration purpose i am keeping things simple.Please refer below flow for your reference.
  • Storing and saving Survey responses – Create a Microsoft Flow for Storing and saving Survey responses in Microsoft Dynamics 365 Finance and operations using D365 FO custom data entity and Microsoft Flow Fins and ops connectors.Please refer below flow for your reference.

Cheers, piyush adhikari +91-7995802472 & piyushadh@gmail.com

Microsoft Forms : Create a Survey Form From Scratch

Introduction

Microsoft Forms is online application & surveys creator tool which helps you to create surveys, quizzes & polls. Microsoft Forms also comes with Microsoft Forms Pro version with many more integration capabilities and features as comparison to basic version.With Microsoft Forms Pro, you can create and send surveys and receive survey responses in Dynamics 365 Applications along with other Dynamics 365 data. Microsoft Forms can be easily integrated and used with applications like Microsoft Flow, Microsoft Power Automate & Microsoft Azure Logic Apps.

Steps To Create a Survey From Scratch

  • Under My Forms, click on New Pro Survey
  • Input your survey title and its description.
  • Add new rating question.
  • Fill question and its description
  • In the end, your Microsoft Forms Preview Should look like this.
  • Click on Send to see sharing options
  • You can send Microsoft Forms via email or you can configure it in Microsoft Flow / Azure Power Automate or You can share Microsoft Forms Link or QR Code. There are so many options

D365 FO/Logic Apps: REST Service For Accepting JSON & Inserting Records Into A Table

LogicApps

Requirement

Third party Vendor wants to push records in D365 Finance and operation by providing input in a JSON format.

JSON Format:

1

Purpose

The purpose of the document is to provide all the necessary steps of developing a REST web service in Logic Apps which will accept JSON message as input. Parse of JSON string will happen in Logic Apps & records will inserted into a table of D365 Finance and operation environment using data entities.

Perquisites

  1. Logic Apps subscription is required
  2. D365 Finance and operation development environment.
  3. Documents related to JSON schema and format should be shared with developer
  4. D365 Data entities should be accessible from outside. In my case I have 2 tables and 2 data entities of both the tables. Tables Name are OrderHeader & OrderLines.23

Steps

  1. Generate the JSON schema by using URL https://jsonschema.net/ using JSON sample4
  2. Create a new Logic Apps from blank template.
  3. Add a trigger of type “REQUEST” – When a HTTP request is received and paste the JSON schema created in step 1 into the section Request Body JSON Schema5
  4. Add a new step and use the new action of type Data Operation – Parse JSON.6
  5. (In case you require) Add a new step for initializing a variable. I am using here Initialize variable action .I am using it for line number counter later.fff
  6. Add a new step by using control – For Each7
  7. Add a new step by using action “Create record”-Dynamics 365 for fin & ops. Provide D365 environment URL , data entity name & credentials. In this example I am using entity OrderHeader.This step should be inside “For Each” loop and we will insert Orderheader data.89
  8. After inserting record into OrderHeader entity , we will fill details by using OrderLine Entity.Flow is mentioned below1011
  9. Save your flow
  10. Copy the HTTP POST URL12
  11. For testing visit website https://apitester.com/13
  12. Records are inserted14

cheers

piyush adhikari 🙂