Debajit Dutta (Former 6x Business Solutions MVP, MCT)

Improving User Experience with Delayed filter or Search in Power Apps

Hello everyone and welcome to my blog. In today’s blog, I will show how you can filter a gallery or perform a search operation only after the user has finished typing in the search text. To explain the requirement, let’s take this scenario. In the below example I am using the Search function of PowerApps …

Improving User Experience with Delayed filter or Search in Power Apps Read More »

{Solved} How to clear a DatePicker control in Canvas apps

Hello everyone and welcome to my blog. In today’s blog, I will show how you can clear a DatePicker control in PowerApps. You might be wondering why can’t I simply set it to Blank()? Well, that is what you need to do. Let’s see what happens when I set the DefaultDate property of the DatePicker …

{Solved} How to clear a DatePicker control in Canvas apps Read More »

How to convert a local datetime to UTC in Power Apps

Hello everyone and welcome to my blog. In today’s blog I will show how you can convert a local DateTime to UTC time. Let’s get started. If you are from traditional programming, you will find constructs like ConvertToUTC or something similar. In Power Apps however, you don’t have any sort of function like that. Rather, …

How to convert a local datetime to UTC in Power Apps Read More »

PowerApps Tutorial: Extracting Dynamic JSON Schema Properties and Values

Hello everyone and welcome to my blog. In this blog I will show how you get the property tag names of dynamic JSON schema and the value of each property. This blog will be helpful for the following scenarions. For this blog, I will go with a very simple example. I have a text input …

PowerApps Tutorial: Extracting Dynamic JSON Schema Properties and Values Read More »

Working with Polymorphic Lookup (multi-table column) in Power Apps: AsType and IsType Functions Explained

Hello everyone and welcome to my blog. In today’s blog, I will show how you can typecast polymorphic lookup columns to specific table types to compare and get the value. For typecasting polymorphic lookup using PowerFx formula, you can use the AsType function. The AsType function is very useful whenever you want to typecast a …

Working with Polymorphic Lookup (multi-table column) in Power Apps: AsType and IsType Functions Explained Read More »

Power Apps canvas apps: Adding Calculated and Dynamic Columns

Hello everyone and welcome to my blog. In today’s blog I will discuss on how you can add a column to a datasource in Power Apps canvas apps. So let’s get started. To add a column to the datasource, you can use the AddColumn function to add a column to the datasource. Let’s start with …

Power Apps canvas apps: Adding Calculated and Dynamic Columns Read More »

How to check if a collection is empty in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog, I will show how can you check if a collection is empty in Power Apps. There are primarily two ways you can check if a collection is empty. The first is using the IsEmpty function. In the below example, the IsEmpty function will initially return …

How to check if a collection is empty in Power Apps canvas apps Read More »

Using && Operator vs. And Function in Power Apps Canvas Apps

Hello everyone and welcome to my blog. In today’s blog we will discuss how you can frame And conditions in Power Apps canvas apps. Let’s get started. If you are coming over to Power Apps from traditional programming, you might be fairly accustomed to using && for And condition operator. Well, Power App does not …

Using && Operator vs. And Function in Power Apps Canvas Apps Read More »

How to get the current visible screen in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog, I will show how you can get the active screen dynamically in Power App. To get the currently visible screen, you need to use the ActiveScreen property of the App object. The ActiveScreen returns a reference to the screen which is currently visible. Based on …

How to get the current visible screen in Power Apps canvas apps Read More »

Using OnError Event in Power Apps: Unhandled Errors Tracing

Hello everyone and welcome to my blog. In today’s blog, we will explore the OnError event of the App object and how it can be used to trace and log all unhandled errors in your Power App. Let’s get started. The App object in canvas apps has an OnError property. And quite surprisingly, while many …

Using OnError Event in Power Apps: Unhandled Errors Tracing Read More »

How to prompt users with Unsaved form changes warning when user try to exit a Power App

Hello everyone and welcome to my blog. In today’s blog, I will show how you can prompt users if they try to exit app without saving the form. So let’s get started. For this example, I have used a simple app where I would edit and create new accounts in DataVerse. My requirement is to …

How to prompt users with Unsaved form changes warning when user try to exit a Power App Read More »

How to query data across hierarchy using Dynamics 365/ DataVerse SDK

Hello everyone and welcome to my blog. In today’s blog, we will discuss about how you can query hierarchical data using SDK in Dynamics 365/ DataVerse Let’s get started. I am going to use Account hierarchy (account -> parent account) relationship for this blog demo. But you can utilize the same learning for any hierarchical …

How to query data across hierarchy using Dynamics 365/ DataVerse SDK Read More »

Create N:N relationship record in Dynamics 365/ DataVerse using client API – Xrm.WebApi

Hello everyone and welcome to my blog. In today’s blog I will show how you can associate records in N:N relationship in DataVerse/ Dynamics 365 using Xrm.WebApi client API’s. Microsoft have introduced Xrm.WebApi sometime back and it was indeed a great step-up from the former ways of performing server side operations using Client API in …

Create N:N relationship record in Dynamics 365/ DataVerse using client API – Xrm.WebApi Read More »

How to build a multilingual canvas app using the new AITranslate function

Hello everyone and welcome to my blog. It’s been sometime since I wrote my last blog. Hence I thought of penning something new and interesting. Whenever we need to roll out enterprise canvas apps across multiple geographies, more often than not, we need to incorporate multilingual capability in our canvas app. Until this time, we …

How to build a multilingual canvas app using the new AITranslate function Read More »

How to display a single delimited string as HTML table in Power Apps canvas apps.

Hello everyone and welcome to my blog. In today’s blog, I will show how you can display a single delimited string in HTML table format. For this example, I will use comma as the delimiter. But the method will work for any delimiter. Let’s start exploring with this phrase – “The,quick,brown,fox,jumps,over,the,lazy,dog“. Quite a famous phrase …

How to display a single delimited string as HTML table in Power Apps canvas apps. Read More »

How to call a Power automate flows from Power Pages portal? Exploring the new integration of cloud flows with Power Pages.

Hello everyone and welcome to my blog. In today’s blog, I will show how you can call a Power Automate flow from Power Pages portal. Invoking Power Automate flows from Power Pages/ Power Apps portals is nothing new. Until this time, we would create a Power Automate flow with HTTP trigger. And invoke the Power …

How to call a Power automate flows from Power Pages portal? Exploring the new integration of cloud flows with Power Pages. Read More »

How to fetch data from Smartsheet in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will show how can query Smartsheet data in canvas apps. The first step is to connect to Smartsheet. Open your Smartsheet and look for the smartsheet url. The URL contain the SmartSheet Id, the portion after https://app.smartsheet.com/sheets. Copy it. We will need it to …

How to fetch data from Smartsheet in Power Apps canvas apps Read More »

How to upload multiple attachments using Attachment control outside of Form in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will show how you can upload multiple attachment from your Power App using the file attachment control If you are not aware on how to use an attachment control outside the form, you can read my blog. Let’s get back to the requirement. I …

How to upload multiple attachments using Attachment control outside of Form in Power Apps canvas apps Read More »

How to programmatically set a selected item in a gallery in Power Apps Canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss on how you can programmatically select a record in Power Apps canvas apps. Many a times we need to select an item in the Gallery based on certain business logic. Additionally you may want to execute formula you have written in the …

How to programmatically set a selected item in a gallery in Power Apps Canvas apps Read More »

How to check if a Power apps canvas app is running on mobile or desktop device

Hello everyone and welcome to my blog. In today’s blog I will show how you can determine if your canvas app is running on a mobile or desktop device. Many a times we need to check whether your Power Apps canvas apps is running on browser or on mobile device. If you search the internet, …

How to check if a Power apps canvas app is running on mobile or desktop device Read More »

How to use an attachment control outside of form control in Power Apps Canvas apps

Hello everyone and welcome to my blog. In today’s blog I will show how you can use a attachment control outside of a form control in a Power Apps canvas apps. In Canvas apps, it is not possible to insert an attachment control on screen from the Controls toolbox. The attachment control is only available …

How to use an attachment control outside of form control in Power Apps Canvas apps Read More »

{Solved} How to reset file attachment control in Power Apps Canvas apps

Hello everyone and welcome to my blog. In today’s blog, we will discuss how to reset a file attachment control in Power Apps In this blog, I will use a fairly complex scenario. I will use a file attachment control outside of form control. If you are not aware of how to insert an attachment …

{Solved} How to reset file attachment control in Power Apps Canvas apps Read More »

How to write multiple conditions inside If block in Power Automate Desktop

Hello everyone and welcome to my blog. This is my first blog of 2024. And wishing all my readers a very happy and prosperous new year. In today’s blog, I will show how you can include multiple conditions inside If condition in Power Automate desktop. Let’s start with an example. I have couple of variables …

How to write multiple conditions inside If block in Power Automate Desktop Read More »

How to enable Switch to Classic option in Power Apps maker portal

Hello everyone and welcome to my blog. In today’s blog, we will discuss how you can bring back the ‘Switch to classic’ option in Power Apps maker portal. If you are accustomed to working in Maker portal, you will see the ubiquitous ‘Switch to classic’ option. The below illustration show the option for a solution …

How to enable Switch to Classic option in Power Apps maker portal Read More »

{Solved} Microsoft Power Apps Webpart in SharePoint showing borders.

Hello everyone and welcome to my blog. In today’s blog I will show how you can get rid of the borders when you insert a Power App webpart in SharePoint. Let’s get started. For this blog, I have created a very simple Power App canvas app and used the Microsoft Power Apps web part to …

{Solved} Microsoft Power Apps Webpart in SharePoint showing borders. Read More »

How to display date and time in specific locale in Power Automate

Hello everyone and welcome to my blog. In today’s blog I will show how you can display date and time in a specific locale in Power Automate. Let’s get started. Power Automate has this wonderful formatDateTime function which can be used to display date and time values in various formats. Today’s date is 10th of …

How to display date and time in specific locale in Power Automate Read More »

How to create a hierarchical Navigation menu in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog, I am going to show how you can create a hierarchical navigation menu in Power Apps canvas apps. To create the hierarchical menu, I will use the Power Platform Creator kit’s Fluent UI Nav component. If you are not aware of Creator kit and unsure …

How to create a hierarchical Navigation menu in Power Apps canvas apps Read More »

How to show Progress bar control in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will show you how to build a progress indicator in Canvas apps using Power Platform Creator kit. In this blog I am going to use the Power Platform Creator kit progress indicator control. If you are not aware of Power Platform Creator Kit and …

How to show Progress bar control in Power Apps canvas apps Read More »

{Solved} Denied with no valid RBAC error while trying to add a certificate or secret in Azure Key vault

Hello everyone and welcome to my blog. In today’s blog we will discuss how to resolve access issues when you try to add a certificate or a secret to Azure Key Vault. Let’s jump to the problem statement. So I was trying to add a certificate to my Azure Key vault. However when I tried …

{Solved} Denied with no valid RBAC error while trying to add a certificate or secret in Azure Key vault Read More »

{Solved} Getting 401 unauthorized error using SharePoint add-in app authentication

Hello everyone and welcome to my blog. In today’s blog we will discuss how to resolve 401 unauthorized error when using SharePoint Add-in app for authentication. If you are not aware of SharePoint Add-in app only authentication, I recommend to go though this Microsoft article. Now coming back to the problem statement. I was using …

{Solved} Getting 401 unauthorized error using SharePoint add-in app authentication Read More »

How to create a People Picker in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I am going to show how to use Power Platform Creator Kit to develop People Picker control. Let’s get started. The first thing we need to do is install the Power Platform Creator kit. You can find the multiple options to install in Microsoft documentation. …

How to create a People Picker in Power Apps canvas apps Read More »

How to display Week day names in a Dropdown in Power Apps based on user locale

Hello everyone and welcome to my blog. In today’s blog I will show a simple technique on how you can display Weekday names in Dropdown inside canvas apps. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to …

How to display Week day names in a Dropdown in Power Apps based on user locale Read More »

{Solved} Nuget is not recognized as internal or external command

Hello everyone and welcome to my blog. Today’s blog is little different from my usual blogs on Power Platform and Dynamics 365. However any developers in Dynamics and Power platform must be familiar with Nuget. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, …

{Solved} Nuget is not recognized as internal or external command Read More »

How to search for emails within a specified date range in exchange/ outlook

Hello everyone and welcome to my blog. In this blog I will show how you can search for emails within a specific date range in Outlook. The technique described shall work if you want to query for emails within a specified date range from Through my blog I share interesting tips and discuss on latest …

How to search for emails within a specified date range in exchange/ outlook Read More »

How to configure layout and add custom sections to SharePoint list form

Hello everyone and welcome to my blog. In today’s blog I am going to show how you can edit the layout of a SharePoint list item form. In this blog, we will cover the following requirements. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power …

How to configure layout and add custom sections to SharePoint list form Read More »

How to change ‘Run Flow’ button text when executing a flow from a SharePoint List item

Hello everyone and welcome to my blog. In today’s blog I will discuss an interesting topic. And that is the ability to customize the Power automate flow panel when you execute a Power automate flow from a SharePoint list item record. In my previous blog I have explained how to create a button column in …

How to change ‘Run Flow’ button text when executing a flow from a SharePoint List item Read More »

How to launch Power Automate flow on click of a button from a row in SharePoint list item

Hello everyone and welcome to my blog. In today’s blog, I will show how you can launch a Power Automate flow using a button from a row in SharePoint list item. The blog should help you to learn the following scenarios. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET …

How to launch Power Automate flow on click of a button from a row in SharePoint list item Read More »

Dialing Into Savings: The Truth About Free Phones and What to Expect

The article entitled ‘Dialing Into Savings: The Truth About Free Phones and What to Expect’ aims to provide objective and informative insights into the hidden costs, benefits, limitations, and considerations associated with free phone programs. By adopting an academic writing style that eliminates personal pronouns and maintains objectivity, this article seeks to present readers with …

Dialing Into Savings: The Truth About Free Phones and What to Expect Read More »

Get DataVerse record URL in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss on how you can frame DataVerse record URL links in your canvas apps. This blog target the following requirements. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client …

Get DataVerse record URL in Power Apps canvas apps Read More »

ROUND, ROUNDUP and ROUNDDOWN in Power Automate

Hello everyone and welcome to my blog. In my blog today, I am going to discuss on how to round off numbers in Power Automate flows. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog …

ROUND, ROUNDUP and ROUNDDOWN in Power Automate Read More »

How to enable logging in Power Apps

Hello everyone and welcome to my blog. Today’s blog is on Trace function in Power Apps and how you can use tracing in canvas apps to debug specific use cases. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please …

How to enable logging in Power Apps Read More »

Power Automate flows with Dataverse triggers stopped executing in environment. Let’s dive to the root cause.

Hello everyone and welcome to my blog. In today’s blog my intention is to go deep and explore the reason why certain power automate flows configured with DataVerse triggers stop executing. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting …

Power Automate flows with Dataverse triggers stopped executing in environment. Let’s dive to the root cause. Read More »

How to get month name, Week day name in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss on how to get the month name and week day name in canvas app Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my …

How to get month name, Week day name in Power Apps canvas apps Read More »

How to merge/ join excel files in Power Automate flow

Welcome everyone to my blog. In today’s blog, I will discuss how you perform join on excel files using Power Automate flow. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog to stay updated. Let’s …

How to merge/ join excel files in Power Automate flow Read More »

How to use Quick find view to search records in DataVerse/ Dynamics 365 programmatically using Web API

Hello everyone and welcome to my blog. In today’s blog I will discuss an interesting topic on how to perform search queries using Quick find view in DataVerse/ Dynamics 365 through WebApi endpoint. In DataVerse, Quick find view drives the results of searching in the search text box of an entity. If we have a …

How to use Quick find view to search records in DataVerse/ Dynamics 365 programmatically using Web API Read More »

How to write plugins in DataVerse using low code PowerFx functions.

Hello everyone and welcome to my blog. In today’s blog I will discuss about a very interesting feature that I came across – Low code plugins in DataVerse. Before I go ahead and get started, please note that this is an experimental feature. You can learn about this in Microsoft Documentation. Through my blog I …

How to write plugins in DataVerse using low code PowerFx functions. Read More »

{Solved} Dynamics 365 App for outlook missing from Sitemap in DataVerse/ Dynamics 365

Hello everyone and welcome to my blog. In today’s blog I will discuss about an issue I encountered while enabling Dynamics 365 App for Outlook in a DataVerse environment. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe …

{Solved} Dynamics 365 App for outlook missing from Sitemap in DataVerse/ Dynamics 365 Read More »

How to enable scrolling for Label in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss how to show scrollbar in label in canvas apps. If you are using Power Apps, it’s almost certain that you have used the Label control. But one problem with the label control is when the text content of the label does not …

How to enable scrolling for Label in Power Apps canvas apps Read More »

Filtering attributes for DataVerse plugins registered on Create – How to execute them for specific field changes only.

Hello everyone and welcome to my blog. In today’s blog I will discuss about filtering attributes for Plugins on Create message in DataVerse/ Dynamics 365. The blog will cover the following topics. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client …

Filtering attributes for DataVerse plugins registered on Create – How to execute them for specific field changes only. Read More »

How to write Plugins on CreateMultiple and UpdateMultiple messages in DataVerse

Hello everyone and welcome to my blog. In today’s blog, I will discuss on how to write plugins on CreateMultiple and UpdateMultiple messages of DataVerse. If you are not aware of the feature, Microsoft have recently released two new messages in the platform. As of the time of writing this blog, these messages are still …

How to write Plugins on CreateMultiple and UpdateMultiple messages in DataVerse Read More »

How to use CreateMultiple and UpdateMultiple messages using DataVerse SDK Client

Hello everyone and welcome to my blog. In today’s blog, I will discuss a preview feature recently release by Microsoft. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog to stay updated. Microsoft has announced …

How to use CreateMultiple and UpdateMultiple messages using DataVerse SDK Client Read More »

How to bypass Power Automate flow execution during DataVerse operations

Hello everyone and welcome to my blog. In today’s blog I will discuss a very interesting topic – how to bypass Power Automate flows during DataVerse operations. When a row is added, modified or deleted in DataVerse, we can add Power Automate flows for these triggers. However if you are performing a batch job using …

How to bypass Power Automate flow execution during DataVerse operations Read More »

How to create Sequential approvals in Power Automate

Hello everyone and welcome to my blog. In today’s blog I will discuss a new preview feature recently released by Microsoft – Sequential approvals in Power Automate You can find the feature release documentation here. In this demonstration I will show how you can create sequential approval from Teams. Through my blog I share interesting …

How to create Sequential approvals in Power Automate Read More »

Understanding Partition Id and Time to live columns in DataVerse Elastic tables

Hello everyone and welcome to my blog. In today’s blog I will discuss about Elastic tables in DataVerse, a preview feature recently released by Microsoft. In this blog we will discuss about two important columns in Elastic tables – Partition Id and Time to live. If you are not aware of elastic tables in DataVerse, …

Understanding Partition Id and Time to live columns in DataVerse Elastic tables Read More »

How to get files of a specific type from a SharePoint folder using Power Automate

Hello everyone and welcome to my blog. In today’s blog I will discuss on how you can fetch files of specific type from a folder using Power Automate. This blog will help you if you have any of the following requirements in Power Automate Through my blog I share interesting tips and discuss on latest …

How to get files of a specific type from a SharePoint folder using Power Automate Read More »

{Solved} The execution of template action ‘Switch’ failed: It is of type ‘Null’ but is expected to be a value of type ‘String, Integer’ – Power Automate flow

Hello everyone and welcome to my blog. In today’s blog I will discuss on how we can workaround issues while using Switch Case in Power Automate flows. If you want to understand how to check for null conditions in switch-case of Power Automate flow, you will find this blog useful. Through my blog I share …

{Solved} The execution of template action ‘Switch’ failed: It is of type ‘Null’ but is expected to be a value of type ‘String, Integer’ – Power Automate flow Read More »

How to get Environment id and flow id in Power Automate flow

Hello everyone and welcome to my blog. In today’s blog we will discuss on how to get the environment id in which the Power Automate flow is executing and also the GUID of the flow Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, …

How to get Environment id and flow id in Power Automate flow Read More »

{Solved} How to fetch more than 256 rows from Excel in Power Automate

Hello everyone and welcome to my blog. In today’s blog I will show how you can fetch more than 256 rows in from excel file in Power Automate. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to …

{Solved} How to fetch more than 256 rows from Excel in Power Automate Read More »

3 Challenges of Using Power Apps New Users Face

Power Apps are recognized as leaders in the realm of low-code app development. To provide small and medium businesses with a platform to develop competent software applications, Microsoft introduced Power Apps.  The article explains the Power Apps, their types, and the downsides of using them for app development.  What Are Power Apps? Launched in 2015 …

3 Challenges of Using Power Apps New Users Face Read More »

How to get SharePoint document library id by library name in Power Automate

Hello everyone and welcome to my blog. In today’s blog I will show how you can get SharePoint document Library Id by Library name, in a Power Automate flow. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe …

How to get SharePoint document library id by library name in Power Automate Read More »

How to check for null or missing object property in Power Automate

Hello everyone and welcome to my blog. In today’s blog, I will discuss on how you can check if an object property is null or missing in a Power Automate flow. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting …

How to check for null or missing object property in Power Automate Read More »

All about how to use comparison operators in Power Automate

Hello everyone and welcome to my blog. In today’s blog, we shall learn about the comparison operators in Power Automate and how to use them in expressions. We will discuss on the following comparison operators. I keep frequently getting requests from a lot of users starting with Power Automate to write content for beginners. I …

All about how to use comparison operators in Power Automate Read More »

Report cannot be displayed. rs processing aborted- Dynamics CRM Reporting error

Hello everyone and welcome to my blog. In today’s blog I will discuss in the detail the problems you may encounter while executing a report from Dynamics CRM and how to resolve the same. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint …

Report cannot be displayed. rs processing aborted- Dynamics CRM Reporting error Read More »

How to Copy to clipboard from Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will show how you can access clipboard in Power Apps canvas apps. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog to stay updated. …

How to Copy to clipboard from Power Apps canvas apps Read More »

How to add an Area to Navigation (sitemap) in Model Driven apps/ Dynamics 365 apps

Hello everyone and welcome to my blog. In today’s blog I will show how to insert a new Area to navigation in a model-driven apps designer. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog …

How to add an Area to Navigation (sitemap) in Model Driven apps/ Dynamics 365 apps Read More »

How to extract numbers from string in Power Automate

Hello everyone and welcome to my blog. Today we will walkthrough how you can extract numbers from a string using Power Automate flows. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog to stay updated. …

How to extract numbers from string in Power Automate Read More »

How to check if a variable is integer or float or decimal in Power Automate

Hello everyone and welcome to my blog. In today’s blog, I will discuss a very simple requirement to check if a variable is an integer or float or decimal. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe …

How to check if a variable is integer or float or decimal in Power Automate Read More »

How to show nested grid of child items in views of Dynamics 365/ Model Driven apps

Hello everyone and welcome to my blog. In today’s blog, I will discuss about an interesting feature related to Dynamics 365 Apps/ Model Driven apps. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog to …

How to show nested grid of child items in views of Dynamics 365/ Model Driven apps Read More »

How to perform DataVerse actions in transaction in Power Automate

Hello everyone and welcome to my blog. In today’s blog we are going to learn on how to execute DataVerse actions using transaction scope in Power Automate flow. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to …

How to perform DataVerse actions in transaction in Power Automate Read More »

String operations using index, FirstN, LastN characters from string in Power Automate

Hello everyone and welcome to my blog. In today’s blog I will discuss the following requirements. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog to stay updated. So let’s get started. I am going …

String operations using index, FirstN, LastN characters from string in Power Automate Read More »

Sort a collection or array of objects in Power Automate with sort order.

Hello everyone and welcome to my blog. In today’s blog I will discuss the following requirements Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog to stay updated. Let’s get started. We will start with …

Sort a collection or array of objects in Power Automate with sort order. Read More »

{Solved} Local images not loading in React application

Hello everyone and welcome to my blog. Through my blog I share interesting tips and discuss on latest releases on Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog to stay updated. In today’s blog I will discuss about a very common problem that you may encounter …

{Solved} Local images not loading in React application Read More »

How to use fetch function to make HTTP requests from Javascript?

Hello everyone and welcome to my blog. In today’s blog I will show how you can make GET and POST requests from Javascript using the fetch function instead of using the very popular XMLHttpRequest. fetch function was introduced way back in 2015 as a modern successor to XMLHttpRequest. fetch returns a Promise and provide a …

How to use fetch function to make HTTP requests from Javascript? Read More »

How to get current user details in Power pages/ Power Apps portals

Hello everyone and welcome to my blog. In today’s blog I will show how to get logged-in user information and use it dynamically in Power Apps portals/ Power Pages. Using Liquid, an open-source template editing language, you can render dynamic content inside the pages. Liquids have objects and using them you can retrieve dynamic information …

How to get current user details in Power pages/ Power Apps portals Read More »

{Solved} Couldn’t add this app. Check your network connection and try again – Error when trying to upload a SPFx component in SharePoint

Hello everyone and welcome to my blog. Today’s blog is on the network connection error you may receive when trying to upload a SPFx component in SharePoint and how to resolve the same. Let’s get started. I have a SPFx list view command control which I want to upload as an App to my site …

{Solved} Couldn’t add this app. Check your network connection and try again – Error when trying to upload a SPFx component in SharePoint Read More »

How to show a loading spinner in canvas apps? The new Spinner control is here!

Hello everyone and welcome to my blog. Today’s blog is on how to show a loading spinner in Power Apps Canvas apps. Traditionally we have used a combination of controls to mimic loading spinner. However it is no longer required. As of the time of writing this blog, Microsoft have announced the availability of Modern …

How to show a loading spinner in canvas apps? The new Spinner control is here! Read More »

{Solved} “There is no available gateway” – Error while connecting to DataVerse from Power BI using Direct Query.

Hello everyone and welcome to my blog. In today’s blog I will show how you can troubleshoot errors you may encounter when creating Power BI reports with DataVerse data using Direct Query option. Without further ado, let’s jump straight to an example. My Power BI Data model has couple of Data sources. If you are …

{Solved} “There is no available gateway” – Error while connecting to DataVerse from Power BI using Direct Query. Read More »

How to bind DataVerse Choices field to a Combobox in Model Driven Custom Pages/ Fluent UI combobox in canvas app

Hello everyone and welcome to my blog. In today’s blog we will walk you through the following scenarios. If you want to know how to bind a regular Combobox canvas app control to the Choices field of DataVerse, you can follow my blog link here. Let’s get started. My DataVerse table Projects has a Choices field – Capability. It’s values …

How to bind DataVerse Choices field to a Combobox in Model Driven Custom Pages/ Fluent UI combobox in canvas app Read More »

How to bind Choices field of DataVerse to a combobox in PowerApps Canvas apps

Hello everyone and welcome to my blog. In today’s blog I show how to display a Choices field of DataVerse in a Canvas app Combobox. If your requirement is to bind the Choices field to Combobox in Model driven apps custom pages or canvas app fluent UI combobox, you can follow the blog link here. …

How to bind Choices field of DataVerse to a combobox in PowerApps Canvas apps Read More »

{Solved} How to populate word template with Dynamic files in Power Automate

Hello everyone and welcome to my blog. In today’s blog I will show how you can Populate a word template in Power Automate with Dynamic files. Below is a word template that I will use for this demo. It has three text template placeholders and I have put appropriate tag and name for each of …

{Solved} How to populate word template with Dynamic files in Power Automate Read More »

How to generate API documentation in Open API 2.0 with SwashBuckle 5.0 and above?

Hello everyone and welcome to my blog. In today’s blog, I shall walk you through on how to generate Open API 2.0 Swagger.json using Swashbuckle 5.0 and above. If you are not aware of SwashBuckle, Swashbuckle is an open source project for generating Swagger documents for Web APIs that are built with ASP.NET Core. If you …

How to generate API documentation in Open API 2.0 with SwashBuckle 5.0 and above? Read More »

{No code} Confirm Dialog onclick of command button in Model Driven Apps/ Dynamics 365

Hello everyone and welcome to my blog. In today’s blog I shall walk you through a new function to show a confirm dialog when a command button is clicked in Model driven apps or Dynamics 365 Apps. And guess what – without writing a single line of code! Without further ado let’s get started. For …

{No code} Confirm Dialog onclick of command button in Model Driven Apps/ Dynamics 365 Read More »

Convert Word document to PDF using Power Automate flows

Hello everyone and welcome to my blog. Today’s blog is how to convert a word document to PDF using Power Automate flow. Without further ado, let’s get started. I have word document uploaded in my SharePoint drive which I shall convert to PDF using Power Automate flow. For this blog, I have created a flow …

Convert Word document to PDF using Power Automate flows Read More »

How to get error message from failed scope in Power Automate flow

Hello everyone and welcome to my blog. In today’s blog I shall walkthrough the steps to get the error message when a prior scope failed in Power Automate flow. Using scopes to mimic Try-Catch behavior in Power Automate is pretty well known and has been aptly documented in quite a few articles. But there are …

How to get error message from failed scope in Power Automate flow Read More »

How to disable MFA when logging in to Power Platform trial tenants

Hello everyone and welcome to my blog. In today’s blog, I shall walk you through the steps to disable MFA in your trial tenants. The steps shown here is valid for any Azure tenant. However remember that disabling MFA for non-trial environments is strictly not recommended. Coming back to the topic, when you provision a …

How to disable MFA when logging in to Power Platform trial tenants Read More »

How to configure Power Fx command button on activity tables in Dynamics 365/ Model driven apps

Hello everyone and welcome to my blog. In today’s blog we shall discuss about Power FX command designer and why a custom command button on activity tables like email, appointment, task or any other custom activity may not be visible. For this blog, I am using a custom activity table ‘Donations‘. Using the command designer …

How to configure Power Fx command button on activity tables in Dynamics 365/ Model driven apps Read More »

How to call DataVerse actions/ custom api directly from Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will demonstrate how to execute Dataverse actions directly from a canvas app. Dataverse actions are great. You can write very complex business logic inside a custom API. Not only that, you can pass multiple input parameters in the request and return multiple response properties. …

How to call DataVerse actions/ custom api directly from Power Apps canvas apps Read More »

Replace missing properties in object or null value in Power Automate flow.

Hello everyone and welcome to my blog. Today’s blog shall focus on the following requirements. This blog will demonstrate how you can achieve above requirement. For this blog, I will use a Flow with Manual trigger. I have a variable varRequest. It’s a JSON array. The first object has three properties – FirstName, LastName and …

Replace missing properties in object or null value in Power Automate flow. Read More »

{Quick tip} Enable multiple screens for custom pages in Model-driven apps/ Dynamics 365

Hello everyone and welcome to my blog. Today’s blog is on how to enable multiple screens for custom pages in model-driven apps. Introduction of custom pages have enabled makers to create customized UI using canvas apps which blends perfectly with your model driven apps. However custom pages by default have only one screen. Below is …

{Quick tip} Enable multiple screens for custom pages in Model-driven apps/ Dynamics 365 Read More »

How to disable navigation on click of Primary column in a Dynamics 365/ Model driven apps view

Hello everyone and welcome to my blog. In today’s blog I will show a no-code approach to disable navigation on Primary column of a table in Dynamics 365 Apps or Model driven apps. In Model-driven apps, for every table whether standard or custom, there is always a Primary column. And a primary column always show …

How to disable navigation on click of Primary column in a Dynamics 365/ Model driven apps view Read More »

How to print a control or screen in PDF format in Power Apps canvas app

Hello everyone and welcome to my blog. Today’s blog is on PDF function in canvas apps and how you can print an entire screen or specific content in a canvas app screen in PDF format. Canvas app has out-of-box PDF function that can be used to export content in PDF format. You can export the …

How to print a control or screen in PDF format in Power Apps canvas app Read More »

Remove controls during print in Power Apps canvas apps.

Hello everyone and welcome to my blog. Today’s blog is on print functionality in Power Apps and how to remove controls from screen you don’t want to print. Sometime back I wrote a blog on how to print in canvas apps. While it’s fairly easy to do in Canvas apps, the issue happens when you …

Remove controls during print in Power Apps canvas apps. Read More »

How to disable Import from excel/ data import for a user in Model driven apps/ Dynamics 365 apps

Hello everyone and welcome to my blog. Today’s blog is on how to disable the data import feature for a user in model-driven apps/ Dynamics 365 apps. Using the data import feature, users can create/ update records in model driven apps, provided they have create, write permission on those tables. However sometimes you may not …

How to disable Import from excel/ data import for a user in Model driven apps/ Dynamics 365 apps Read More »