SSRS – How to handle multi tenants in single instance?

Problem Statement: We have different SQL databases for different tenants(or clients), and we want the same SSRS report to fetch data from different databases based on the user who is executing the report. To achieve this, we can have a data source that is dynamic by using an expression-based connection string. Below is a quick explanation… Continue reading SSRS – How to handle multi tenants in single instance?

Sort the PowerApps data using the GPS Location

Let’s learn today to sort the data of PowerApps based on the current GPS location. In the below example, we are having Microsoft Dynamics CRM 365 as the database of the PowerApp. This PowerApp was basically developed for one of our client requiring a mobile application that will be used by their Customer care department… Continue reading Sort the PowerApps data using the GPS Location

Waiting workflows using parallel wait branches in Microsoft Dynamics 365 CE/CRM

Waiting workflows in dynamics 365 are best suited in situations when it is required by the process to wait for a specific period of time duration before execution. Basically, in waiting workflows, there has been always confusion between “Timeout” and “Wait” conditions. This is now pretty much clarified with one of our below requirements in… Continue reading Waiting workflows using parallel wait branches in Microsoft Dynamics 365 CE/CRM

Connect to an API from the PowerApps using the custom connector

In many scenarios, we need to call the APIs or services that are not available as the inbuilt connectors of the PowerApps. In that case, you can create your own custom connector with the required triggers and actions. Creating a custom connector is a very smooth process. What you need is only the correct API… Continue reading Connect to an API from the PowerApps using the custom connector

Workflow Tools in Microsoft Dynamics CRM 365 CE / CRM

There are some tasks in Microsoft Dynamics CRM, which are to be executed either using a plug-in or a custom workflow. This may require to be given a lot of time in writing the code. So, prior to writing a code, one should always look for a No-code/Low-code solution in the “Dynamics-365-Workflow-Tools” of GitHub. The “Dynamics-365-Workflow-Tools” is a… Continue reading Workflow Tools in Microsoft Dynamics CRM 365 CE / CRM

Make Microsoft Azure Function App editable or read-only

There are basically two ways to create and publish the Function App in the Microsoft Azure. One of the ways is to create the Function App directly in the Microsoft Azure and publishing it from there itself. The second way is to create the Function App in the Visual Studio and publishing it from the… Continue reading Make Microsoft Azure Function App editable or read-only

Missing Activities tab in the Social Pane of Microsoft Dynamics 365 CE / CRM form

Many times, it is noticed that the Activities tab is not visible on the custom entity forms. I also faced the same issue. In one of the forms of a custom entity, the Activities tab was not visible in the Social Pane. So, I changed the Activities Tab Properties of that form as shown in… Continue reading Missing Activities tab in the Social Pane of Microsoft Dynamics 365 CE / CRM form

Personal and Organization Email Templates in Microsoft Dynamics 365 CE / CRM

I was not aware of something called personal email templates until I got the below warning while exporting one of the solutions in Dynamics 365. Later by analyzing the missing component, I was able to figure out that if a personal email template is used in any of the components in a solution like a… Continue reading Personal and Organization Email Templates in Microsoft Dynamics 365 CE / CRM

Azure FunctionApp Error: The binding type(s) ‘serviceBusTrigger’ are not registered[SOLVED]

At times we are stuck with issues which look very clear but takes everything out of you to resolve them. Recently, I had faced one of them during the deployment of one of my FunctionApp at Azure. Actually, I had to deploy a FunctionApp from the VisualStudio. I deployed it successfully but while selecting the… Continue reading Azure FunctionApp Error: The binding type(s) ‘serviceBusTrigger’ are not registered[SOLVED]

Send the CRM portal invitation code to multiple contacts from Dynamics 365 Customer Engagement / CRM

There are generally two ways how one can register to the CRM Portal. The first way is by clicking on the Sign in -> Register from the top right corner of the CRM Portal landing page. Once registered, contact will be created in the Dynamics 365 CE. This process is to be followed when an external… Continue reading Send the CRM portal invitation code to multiple contacts from Dynamics 365 Customer Engagement / CRM

Upload document to SharePoint from Microsoft D365 CE using C# Web API & manage SharePoint document metadata

The integration of Microsoft D365 CE with SharePoint has enabled the document management in SharePoint precisely in the form of folders and subfolders, in a structured way. Today in this blog, let’s learn how we can upload the documents in SharePoint from the D365 CE using the Dot Net c# web API code with a… Continue reading Upload document to SharePoint from Microsoft D365 CE using C# Web API & manage SharePoint document metadata

Sorting, Filtering & Searching features of PowerApps

This blog is intended to explore a quick idea on the basic operations like sorting, filtering and searching of data in PowerApps. Please know: In all the below examples, we are taking D365 CRM tables as the data source. SORTING In PowerApps, we can view the records in a particular sequence using the Sort or… Continue reading Sorting, Filtering & Searching features of PowerApps

Apply common styles for all the screen components in PowerApps

It is fun to play with the styles applied for the screen components in the PowerApps. This seems to be like the one we achieve using the cascading style sheet in the HTML files. If same font size, font weight, color etc. are to be used in the overall canvas app screens then, there is… Continue reading Apply common styles for all the screen components in PowerApps

Handling Dead Letter Queue(DLQ) using Logic App

In our previous blog, we have explained how to handle DLQ using the Azure Functions. Please refer: https://www.inkeysolutions.com/blogs/handling-dead-letter-queuedlq-using-azure-functions/ Lets now learn how to read the messages from the DLQ using the Logic App: First and foremost, we need to identify the message received in the Dead Letter Queue. So, the trigger step in the Logic… Continue reading Handling Dead Letter Queue(DLQ) using Logic App

Handling Dead Letter Queue(DLQ) using Azure Functions

Microsoft Azure Service Bus is a secure platform for transferring the messages across various platforms and applications. This is a reliable service for asynchronous data transfer using messages. Queues are one among the data structures used while transmitting the data across the cloud. Messages are stored in the queue until processed at the receiver’s end.… Continue reading Handling Dead Letter Queue(DLQ) using Azure Functions

Send data to the Microsoft flow from the PowerApps and receive the response from the Microsoft flow

The PowerApps is used to build the business apps that can be run in a browser or phone or tablet and the Microsoft flow is used to automate the workflows across the multiple applications and services. Using Microsoft flow in the PowerApps is creating wonders in the business world, making almost everything possible with just one click on the… Continue reading Send data to the Microsoft flow from the PowerApps and receive the response from the Microsoft flow

Power BI > Copy Visuals between pbix files – II

Power BI has been growing day by day with the new features that Power BI team is bringing every month. There was a time when we used to face difficulty whenever it was needed to create same designing for multiple reports but with different datasets, because we couldn’t just copy paste the visual from one… Continue reading Power BI > Copy Visuals between pbix files – II

Debug the Azure Functions locally

Today, the majority of the business have based their roots with Azure. Above all the benefits, the main attraction of the Azure functions is that it helps in the simplification of developing the applications. They can also be debugged locally to identify the errors or to know the sanity status of the function. This can… Continue reading Debug the Azure Functions locally

Power BI > Conditional Formatting the Table > Use Case

Microsoft has released a very exciting feature – Conditional formatting by Field Value. Hence, we plan to explain how we took it’s best use with an example. There are times when we want to conditionally format a field that returns both text values and decimal numbers. To understand this better, let’s take some sample data… Continue reading Power BI > Conditional Formatting the Table > Use Case

Add an external assembly as a reference in the Azure function

Let’s learn today, how to add an external assembly as a reference in an azure function with a small example. This will help you to reuse the already developed functionalities (i.e.,) if there is a requirement that some of the functionalities are needed inside the azure function, which are already developed in any of the… Continue reading Add an external assembly as a reference in the Azure function