Yesterday I saw that there is a new (new to me at least..!) type of column (formerly attribute) which you can create in any customizable table (formerly entity) which can be used to upload file. You can create multiple file type columns in a table and upload one file in one column. I create a... Continue Reading →
CDS Custom API Preview : How to create CDS Custom API
CDS Custom API Preview (An extension of custom action): How to create CDS Global Custom API CDS have workflow custom action which helps create a new plugin messages and we can register plugins on those custom message and execute any logic server side. Alternatively in such workflow custom actions we can write UI workflow like... Continue Reading →
How to Secure Secrets in Logic app editor and run history using ARM template, key vault and secure input
Logic apps are great at orchestrating integrations with UI based workflows and supports over 200 connectors, so it become 1st choice for many integration scenario. One of the most common scenario is when we want to use some secure parameters (like username, password etc) in logic app, it become important to secure such secrets properly... Continue Reading →
How to enable app insights in azure app service (Web app)
App insights is very powerful logging and monitoring azure service which help us keep track of traces, logging and exceptions of our web app. App insights have many more powerful feature, we'll focus on understanding how we can enable application insights in our webapp and check our traces/logs/exceptions :- Step 1: Create a App service... Continue Reading →
Upload a file to Azure storage account using .NET Core Console Application
Step1: Open Visual studio and create a new .NET Core solution Step2: Open cmd and navigate to the directory of your project using below command: cd C:\Users\vishkuma\source\repos\ConsoleApp20\ConsoleApp20 Add nuget package to Azure storage using below command: dotnet add package WindowsAzure.Storage Add Microsoft.Extensions.Configuration.Json Nuget package by executing below command in cmd dotnet add package Microsoft.Extensions.Configuration.Json You'll... Continue Reading →
How to Populate Multi-Lookup attribute in CE using Azure data factory
While trying to sync data from sql staging db to CE, I faced an issue in populating the multi-lookup columns. In our demo scenario, we will import data from sql to CE in contact entity in following columns: FirstName, LastName, Email, Company. Here Company is multilookup of contact and account entity both. Let's suppose we... Continue Reading →
Assign Security Role to team and user through rest api in MS CRM
Today i needed to assign security role to team and user using rest api through postman: Below is the sample request:- Assign role to team Method : Post Url: https://yourceinstancename.api.crm9.dynamics.com/api/data/v9.1/teams(teamguid)/teamroles_association/$ref Body: {"@odata.id":"https://yourceinstancename.api.crm9.dynamics.com/api/data/v9.1/roles(roleguid)"} 2. Assign role to user Method : Post Url: https://yourceinstancename.api.crm9.dynamics.com/api/data/v9.1/systemusers(systemuserguid)/systemuserroles_association/$ref Body: {"@odata.id":"https://yourceinstancename.api.crm9.dynamics.com/api/data/v9.1/roles(roleguid)"} Just replace yourceinstancename, teamguid , systemuserguid , roleguid as per your... Continue Reading →
How to publish webjob from azure devops to azure app service using Azure app service deploy task
So the other day i was trying to publish azure webjob from devops release pipeline using "Azure app service deploy" task which is oob task available in azure devops to deploy code to azure app service. Now this activity by default publish to wwwroot directory in app service which works pretty well when you want... Continue Reading →
Building EMI calculator with Microsoft Power Apps (Canvas Apps)
Building EMI calculator with Microsoft Power Apps In last posts ( Power apps : Understanding What it is and why to use it? and  Types of Power apps: Canvas Apps and Model Driven Apps, Which to choose? ) i discussed about what is power apps and types of power apps. Now as doing practical is great way... Continue Reading →
Query D365 ce using fetch xml in azure logic app (without cds connector)
In azure logic app we have oob connector for cds (common data services) which does most of the task but have certain limitations. We know that fetchxml is much more powerful in terms of aggregation and joins. Also using below approach you can handle the cases where you just want to update dynamics fields in... Continue Reading →