Posts

Showing posts with the label CDS

Convert an Array to comma separated string in Power Automate

Image
Many times when we have an Array in Power Automate and we want to make it comma separated string in such cases we use loop to iterate each element in an array and append comma, we can avoid this loop and create desired string by using Join function available in Power Automate. My blog will guide you how you can achieve the same. Note : I am using hard code array in my blog, but you can use dynamic array as well Steps: Initialize a variable of type array with [ 'a', 'b', 'c', 'd', 'e' ] as its element. Add a new Compose step and use join function ( join (variables('Array 1'),',') ) to make array a comma separated string as shown below. Join function accepts 2 parameters, first parameter as Array in my case its Array 1 (variable) and second parameter as delimiter in my case I passed ‘,’ as we want to make comma separated string but you can use any delimiter and create your own string. Now, save and execute the flow and check if it ...

Send a notification on Microsoft Teams when a record is created or Updated or Deleted in D365 CRM using Power Automate

Image
Steps involved in Power Automate: Select trigger, in my case I used CDS connector (Current Environment) when a record is created, updated or deleted. Select trigger condition, in my case I used Update. Select entity name, in my case I used Opportunities. Select Scope, Organization. Add new step to flow. Search Microsoft Teams and select Post a message. Select Team where you want to post a message. Select Channel from team where you want to send a notification. Enter Message in message box. Click Save and check teams. Congratulations! You have successfully created the required flow Hope this helps!!!

Trigger an Email when account is created in D365 CRM using Azure Logic App

Image
Click here to see, how to create Azure Logic App Search for common data service and select trigger as When a record is created . Select Environment, Entity Name, Scope. Click on new step. Search office 365 outlook and click on Send an email . Now, fill in the required data. Once, all the details are filled in send email connector as shown above, click save. Now, create a new account record in D365 CRM. In my case, I created account with name Tejesh Enterprise . An email will be triggered to the person with the details specified in connector. Hope this Helps!

Connect D365 CRM CDS Database From SQL Server

Image
Connect D365 CRM CDS Database from SQL Server Many times, we feel like why I can’t access D365 CRM Database directly from MS SQL Server, so here is my blog that will guide you on how you can connect D365 CRM CDS Database using MS SQL Server. Steps to enable D365 CRM CDS Database to make it connect from MS SQL Server: Login to https://admin.powerplatform.microsoft.com/ using administrator credentials. In Environment section, click on your environment for which you want to enable D365 CRM CDS for MS SQL Server. (In my case I am clicking on DemoEnvironment as shown below.) When Environment opens click on settings in header. Settings page will open, Click on Product and then click on Features. When features Page opens enable TDS Endpoint (Preview) and click save. Now, we have successfully enabled D365 CRM CDS to connect it from MS SQL Server. Steps to Connect CDS Database from MS SQL Server: Open MS SQL Server. In connect to SQL Server Window enter Server name (It will be your D365 CRM UR...