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 →

October 3, 2020 0

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 →

October 1, 2020 0

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 →

September 10, 2020 0

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 →

March 15, 2020 0

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 →

March 1, 2020 0

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 →

November 5, 2019 1

Query D365 CE from console app using azure ad app using client credentials – (Server to server authentication using azure ad and application user for Dynamics 365 ce)

To query ce from outside ce using webapi, follow below steps:- Prerequisites :- Azure ad application with secret generated (Azure Subscription should be with same Office 365 account as of your D365 instance-you can login to azure using your ce trail instance credentials) (Ref ms docs) 2. Application user created in ce with same... Continue Reading →

November 3, 2019 2

How to add new option set value in global option set using webapi in Dynamics 365 ce

I was trying to found out how we can add a new value to a global option set and below post request can do the same : https://vgrade2.api.crm8.dynamics.com/api/data/v9.1/InsertOptionValue { "OptionSetName": "new_test", "Label": { "LocalizedLabels": [ { "Label": "anewoptionsetlabel", "LanguageCode": 1033 } ] } } Output: { "@odata.context": "https://vgrade2.api.crm8.dynamics.com/api/data/v9.1/$metadata#Microsoft.Dynamics.CRM.InsertOptionValueResponse", "NewOptionValue": 100000005 } Be default it put... Continue Reading →

November 3, 2019 0

New Dynamics 365 certifications exams

You might be knowing that old certifications of dynamics 365, MB2-715 Microsoft Dynamics 365 Online Deployment MB2-716 Microsoft Dynamics 365 Customization and Configuration MB2-717 Microsoft Dynamics 365 for Sales MB2-718 Microsoft Dynamics 365 for Customer Service are going to expire on 30th June, 2019. It's time to gear up for new certifications guys and below... Continue Reading →

June 22, 2019 0

How to enable the new UI navigation in UCI in Dynamics 365 CE

I was trying to enable the new Navigation for UCI in Dynamics 365 CE which make the left hand menu items in sitemap to be expended by default. It is part of UI updates announced in Oct 2018. Details are available at blogs.msdn . This is the UI experience i wanted to enable in my d365 CE... Continue Reading →

January 4, 2019 0

Dynamics 365 CE/Power Platform, PowerApps, Power Automate, Azure by Vishal Grade