In this blog we will see the steps in order to send a automated message via Teams as soon as an Opportunity is created in Microsoft Dynamics 365. Step 1: Go to portal.azure.com and select the Azure Logic App Resource. Step 2: Enter all the details such as the Name, Resource Group, Subscription, Region, etc. required while creating a Logic App. Step 3: Select the Dynamics 365 trigger When a record is updated. Step 4: Select Opportunities entity after setting by the Dynamics 365 CRM connection Step 5: Set the data refresh time as required. Step 6: Select the IF action in the next step and the condition would be status_label=won for true. Step 7: Inside True Block select Post a message in a chat or channel option. You can also handle the condition for False block, but in this case we can leave it blank. Step 8: You can post this message in a Group, Channel or send it as a Personal chat. Step 10: Wait for the trigger successful notification. Step 11: Go to Dynamics 365 CRM and navigate to opportunities entity. Step 12: Open a test opportunity or create one if doesn’t exist and close the opportunity as won. Step 13: As soon as you closed this opportunity you may have received the following message. Hence in this blog we saw how we can send messages on MS Teams using Azure Logic Apps on triggering certain conditions. Hope this helped!

Sometimes after extracting data from certain data sources in JSON format we have to format and make this data easily readable so as to send this data via Microsoft teams or email. In this blog I will format a sample JSON code into a HTML table Since I am not using a data source, I am initializing a variable with data type as array (Create HTML block supports array Variables) and put a sample JSON code in the value section. Now we will convert this JSON piece of code into respective HTML type, to do this we will use Create HTML block, we have to select the array variable we initialized earlier and the type of columns would be custom. Enter Header details, this can be any string value, For Value Field Click on on it, go to expression and type the following expression. item()?[‘Product_ID’] You can replace the “Product_ID” with the name of attribute in JSON string After this we will send this data via email and run the trigger. As you can see the JSON code is converted into readable Email via HTML Hope this blog helped.

In this blog we will copy a list of Account names that exists on our Microsoft Dynamics 365 system and send all these names via email using Azure logic Apps. To start the map select a HTTP request trigger, which would run on demand at the click of the run trigger button. After defining the trigger and an action to list rows from Dynamics 365 and select the entity needed from the drop down. In this case I have selected Accounts. You can also add filters using parameters to limit the data extracted. Initialize a variable in order to store the data, since there are more than one records the data type of the variable should be an array Now for each record (value) found in Dynamics 365 we have to add it to the array, therefore we use a For each loop and append new data to array inside the for loop Next we will use a Send Email block and add the variable which we used to store account names. After this we can run the flow On running the map an email containing all account names in our Dynamics 365 system gets received. Hope this blog helped!!

Wondered How to solve SQL triggered Azure Logic Apps issue of not being able to select your table in dropdown? This blog will help you fix this issue.

Learn how to fetch Salesforce Records in Azure Logic App using two different ways.

Learn how you can easily use SOQL query to fetch Salesforce records in Logic App

Hello everyone in this blog we will see how we can post a message on a teams channel using logic app. Step 1: Go to portal.azure.com and select logic app azure service. Step 2:  Create a logic by filling the details accordingly. Step 3: Select the recurrence trigger for logic app Step 4: Now click on new step and select Ms Teams connector. Step 5: Select Post message on teams options. Step 6: Select your teams channel name and channel and write the message that you want to send. In this way you can post a message on teams. Hope this helps.

Azure Logic Apps is a cloud service that automates the execution of your business processes or workflows. It allows you to use a graphical design tool called the Logic Apps Designer to arrange pre-made components into the sequence you need. There are three ways in which we can create Logic App. Azure Portal – probably the most used form. Visual Studio – probably the favourite tool amongst developers. Visual Studio Code – with is getting more fans every day. Let’s Create logic app using Azure Portal Sign into the Azure Portal with your Azure account credentials. In the Azure portal search box, enter Logic Apps, and select Logic Apps. On the Logic Apps page, select Add. On the Logic App pane, provide the following details and then select Review + Create, and select Create. If you have more than one subscription, select the proper one from the Subscription combo box. On the Resource group, select an existing one or create a new one, but be aware that the Azure Resource group’s name must be unique inside your subscription. On the Logic App Name field, provide a name to your Logic App. Again, it has to be unique and can contain only letters, numbers, hyphens (-), underscores (_), parentheses ((,)), and periods (.). From the existing options, select the region where you want to store your logic apps on the Location field. You can also choose to enable Log Analytics to push the Logic App runtime events into it and help you monitor your workflows. After Azure successfully deploys your app, select Go to resource. Select a blank Logic app. To do that you need to select Blank Logic App under Templates and You can start defining your start building your sequence of tasks.

In order to create logic app using visual studio we should have VS Community edition or greater. Prerequisites Visual Studio 2019, 2017, or 2015 – Community edition or greater; Visual Studio Tools for Azure: In the Visual Studio installer, install Visual Studio (or modify an existing installation). Make sure the Azure development and ASP.NET and web development workloads are selected. Install Azure Logic Apps Tools for Visual Studio 2019 Open your Visual Studio, on the entry screen select the option Continue without code -> Then on the menu, navigate to Extensions > Manage Extensions Select Online and search for Logic Apps The add-in will be listed in the search results section. Click Download to download and install the add-in. You need to close your Visual Studio in order to begin installing this extension.  On the VSIX Installer screen Make sure that the correct version of Visual Studio is selected. Click Install or Modify.  This will download and install the add-in to your version of Visual Studio. At the end select Close.

The Logic Apps designer integrates with the current Azure Resource Group project so you can seamlessly work with resource deployments that include Logic Apps.  Open Visual Studio and on the Create a new project panel, select C# > Azure > Cloud, or select for Azure Resource Group; Select Azure Resource Group from the template list; On the Configure your new project panel, give a proper Project name, Location, Solution name, and leave the Framework as .Net Framework 4.7.2 and select Create. Finally, on the Select Azure Template panel, from the Visual Studio Templates list, select the Logic App template and select OK. This will create an empty Visual Studio Logic App solution. Now on the Visual Studio solution: Right-click on the LogicApp.json file and select Open With Logic App Designer This will open a Logic App Properties window, where you need to: Define the credentials to authenticate on the Azure subscription; Define the Subscription and Resource Group where you want to create these resources; Define if you want the Location to be in the same Region or in an Integration Service Environment (ISE) and click on OK; This will embed the Logic App designer inside the Visual Studio.