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

How to delete users from Dynamics 365/ Power Platform

Hello everyone and welcome to my blog. In today’s blog I will discuss about a preview feature that allow you to delete users from Dynamics 365/ Power platform environments. Please note that this is a preview feature. If you have been working from the good old days of Dynamics 365, you will be aware that …

How to delete users from Dynamics 365/ Power Platform Read More »

Configure Address Finder control in Power Apps Canvas apps

Hello everyone and welcome to my blog. In today’s blog, I will show how you can configure the address finder control in canvas apps. So let’s get started with it. Navigate to Power Platform admin center and open your environment. Go to Settings and look for a Features under Product you will find something called …

Configure Address Finder control in Power Apps Canvas apps Read More »

How to get value of Environment variable in Model driven apps/ Dynamics 365 javascript

Hello everyone and welcome to my blog. In today’s blog I will discuss how to get the value of Environment variables of DataVerse in Dynamics 365/ Model Driven apps. I have the following environment variable in my environment and I want to retrieve the value of it in my form script code. To understand how …

How to get value of Environment variable in Model driven apps/ Dynamics 365 javascript Read More »

How to hide fields from Advanced find search in Dynamics 365/ Model Driven Apps {Crm Tips from the vault}

CRM tips from the vault â€“ A series which I have started on request of my blog readers who are quite new to Dynamics 365 and Model Driven apps. In this series I will mostly cover the topics which are quite simple, used in almost every project implementations and more importantly have withstood the test of …

How to hide fields from Advanced find search in Dynamics 365/ Model Driven Apps {Crm Tips from the vault} Read More »

How to hide command bar/ ribbon bar of a form in Model driven apps/ Dynamics 365

Hello everyone and welcome to my blog. In today’s blog, I will show you how to show/ hide the ribbon bar or command bar on a record form dynamically, in Dynamics 365/ Model Driven apps. This is not a very common requirement but here I was having this requirement. The requirement was to hide the …

How to hide command bar/ ribbon bar of a form in Model driven apps/ Dynamics 365 Read More »

{Solved} Key needs to be greater than 0 – Issue with ilmerge

Hello there and welcome to my blog. In today’s blog I will discuss about the error – “Key needs to be greater than 0” error with ilmerge and how to get around that. I had a class library project where I was referencing Microsoft Graph SDK packages to interact with SharePoint. And before I deploying …

{Solved} Key needs to be greater than 0 – Issue with ilmerge Read More »

How to bind a Multiselect choice of DataVerse to a combobox in Canvas apps

Hello everyone and welcome to my blog. In today’s blog I will share a quick tip on how to bind a multiselect choice field of DataVerse in a canvas app combobox. For this demo I have created a table in Dataverse – Report which has a multi-select choice column Category. Below are the choices. I …

How to bind a Multiselect choice of DataVerse to a combobox in Canvas apps Read More »

How to find all contacts whose birthday falls in current month in DataVerse/ Dynamics 365

Hello everyone and welcome to my blog. In today’s blog I will discuss on how to display all contacts whose birthday falls in the current month. While this blog focus on only finding birthdays in the current month, you can use similar techniques to accomplish the following requirements. and in-fact many other similar requirement on …

How to find all contacts whose birthday falls in current month in DataVerse/ Dynamics 365 Read More »

How to cancel all pending approvals in Power Automate flow

Hello everyone and welcome to my blog. In today’s blog I shall discuss on how you can cancel pending approvals in Power Automate flow. If you have been working on Power Automate for sometime now, you must have used the Approvals in Power Automate flow. However when using approvals, lot of time you will end …

How to cancel all pending approvals in Power Automate flow Read More »

How to set expiry/ timeout for Approval flows in Power Automate

Hello everyone and welcome to my blog. In today’s blog I will show how you can set expiry time for your approval flows in Power Automate. If you have worked with Power Automate, you have most likely used Approval flows. What if there is a requirement to set a time limit or expiry period for …

How to set expiry/ timeout for Approval flows in Power Automate Read More »

How to cancel all running instances of Power Automate flow using PowerShell

Hello everyone and welcome to my blog. In today’s blog I will discuss an interesting way to cancel all running instances of a Power Automate flow in Bulk using Power Shell. So let’s get started. Here is my Power Automate flow which currently have few running instances. My intention is to cancel all the running …

How to cancel all running instances of Power Automate flow using PowerShell Read More »

How to disable ESLint validation error -Variable is defined but never used when building a PCF component

Hello everyone and welcome to my blog. In today’s blog I will discuss on how to resolve an error I faced recently when creating a PowerApps component framework (PCF) control in visual studio code. The blog focus on Power Apps Component framework (PCF) control development but the solution shall work for anyone receiving the ESLint …

How to disable ESLint validation error -Variable is defined but never used when building a PCF component Read More »

How to create hyperlink with dynamic URL in Power Automate emails.

Hello everyone and welcome to my blog. In today’s blog I will discuss about on how to create hyperlinks with dynamic URL while sending an email in Power Automate. Let’s first understand the problem statement. Below is an instant flow I created for this demo. I have created a variable varHyperLink with has the value …

How to create hyperlink with dynamic URL in Power Automate emails. Read More »

How to set a lookup value in Dynamics 365/ Model Driven apps using javascript

Hello everyone and welcome to my blog. In today’s blog I will show on how to set a lookup field value in Dynamics 365/ Model Driven apps using javascript. Lookups in Dynamics 365 model driven apps are essentially arrays. Each array object should have the following three properties. In my example I want to set …

How to set a lookup value in Dynamics 365/ Model Driven apps using javascript Read More »

CountRows function returning zero for DataVerse tables – Power Apps Canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss a peculiar behavior with the CountRows function. Below is an example where I am using the CountRows function to show the total number of customers. Quite strangely, the function returns zero as you can see from the below screenshot. This is quite …

CountRows function returning zero for DataVerse tables – Power Apps Canvas apps Read More »

How to Calculate difference between two dates in Power Automate

Hello everyone and welcome to my blog. In today’s blog we will discuss on how to calculate the difference between two dates in Power Automate. Sometime back I have written a blog which show how to substract two date time objects and then calculate the difference. Infact most of the blogs available on this topic …

How to Calculate difference between two dates in Power Automate Read More »

{Solved} Password is incorrect – Error when importing certificate in windows server 2012/ 2016

Hello everyone and welcome to my blog. In today’s blog I will share a tip on how to get rid of ‘Password is incorrect’ error when you try to import a certificate .pfx/ .pkcs12 file in your windows server. So here goes the problem statement. I had a .pfx file which I created using OpenSSL. …

{Solved} Password is incorrect – Error when importing certificate in windows server 2012/ 2016 Read More »

How to create an array of characters from a string in Power Automate

Hello everyone and welcome to my blog. In today’s blog I will discuss show how you can create an array from string in Power Automate. Suppose I have the string Microsoft. I want to create an array out of the string, basically to return an array – [“M”, “i”, “c”, “r”, “o”, “s”, “o”, “f”, …

How to create an array of characters from a string in Power Automate Read More »

{Solved} Unable to export Power Automate Flow as package (.zip)

Hello everyone and welcome to my blog. In today’s blog I will discuss on a rather peculiar issue faced when you try to export a Power Automate flow. Traditionally whenever I would want to export a Power Automate flow, I shall select the flow and then choose the Package (.zip) option. However lately I observed …

{Solved} Unable to export Power Automate Flow as package (.zip) Read More »

How to retrieve a user’s timezone from DataVerse in a Power Automate flow

Hello everyone and welcome to my blog. In today’s blog, I will show you on how to get the timezone details of a user from DataVerse in a Power Automate flow. Before we get started with the Power Automate flow, it’s important to understand the tables in DataVerse which we will use in the Power …

How to retrieve a user’s timezone from DataVerse in a Power Automate flow Read More »

How to display DataVerse Lookup as Dropdown in canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss on how to display a lookup column of DataVerse as a Dropdown in Power Apps canvas apps. Account has a contact lookup field – Primary Contact. The field is usually required to store the primary contact for a customer. For our demo, …

How to display DataVerse Lookup as Dropdown in canvas apps Read More »

How to reverse an Array/ collection in Power Apps Canvas apps

Hello everyone and welcome to my blog. In today’s blog I will show you on how to reverse an array/ collection in canvas apps. Let’s get started. I have collection of fruits which I will reverse Most of the programming languages have in-built function to reverse an array. Unfortunately, Power Apps does not have an …

How to reverse an Array/ collection in Power Apps Canvas apps Read More »

How to use app.config or configuration files in .NET Core Console Application

Hello everyone and welcome to my blog. In today’s blog I will show you on how to use configuration files in .NET Core console application. For .NET framework applications we always use the app.config to store our configuration values for the application. In .NET Core, instead of App.Config file, we need to use appsettings.json file. …

How to use app.config or configuration files in .NET Core Console Application Read More »

How to find Index of string in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss on how find index of specific phrase inside a string in canvas apps. Canvas apps have the Index function which is frequently confused to work with strings. The Index function is used to find a specific item by index position from a …

How to find Index of string in Power Apps canvas apps Read More »

How to configure Password Reset policy for Azure AD B2C authentication with Power Apps portals

Hello everyone and welcome to my blog. In today’s blog I will show how to configure Password Reset policy with Azure AD B2C authentication in Power Apps portals/ power pages. 4 years back, I wrote a post how to configure Azure AD B2C authentication with portals. All the configurations described in the post still hold …

How to configure Password Reset policy for Azure AD B2C authentication with Power Apps portals Read More »

{Solved} Could not create ssl/tls secure channel – Error while connecting to REST API using Certificate

Hello there and welcome to my blog. Today’s blog is going to be a bit different from my usual blogs on Power Platform and Dynamics 365. In today’s blog I will discuss about the error – Could not create ssl/tls secure channel I faced while connecting to a REST API using certificate and how I …

{Solved} Could not create ssl/tls secure channel – Error while connecting to REST API using Certificate Read More »

Share link of a record in Model Driven apps/ Dynamics 365 Apps

Hello everyone and welcome to my blog. In today’s blog I will discuss a very simple but useful feature which has been released lately. When we browse records in our Model Driven apps or Dynamics 365 Apps, we frequently need to share the URL of the record to access it directly. As easy as it …

Share link of a record in Model Driven apps/ Dynamics 365 Apps Read More »

Show related records in a subgrid – Power Apps Canvas Apps

Hello everyone and welcome to my blog. In today’s blog I will discuss on how to show related records in a subgrid in Power Apps canvas apps. For this demo, I will take the example of Accounts and Contacts table of DataVerse. Accounts and Contacts are in 1:N relationship where an account can have multiple …

Show related records in a subgrid – Power Apps Canvas Apps Read More »

Replace all instances of text , case insensitive, in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss how to replace all instances of word inside a string. I will demonstrate for both case sensitive and case insensitive scenarios. Power Apps has the Substitute function to replace all instances of word inside a text. For this blog, I will use …

Replace all instances of text , case insensitive, in Power Apps canvas apps Read More »

How to Get Environment name in Power Apps canvas apps

Hello everyone and welcome to my blog. I am back with another blog on canvas apps and today I will discuss on how to get the current environment name in Power Apps canvas apps. While we will focus on Canvas apps, the article shall help you explore the below scenarios as well. As of the …

How to Get Environment name in Power Apps canvas apps Read More »

How to extract email address form string in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss about a very simple requirement on how to extract email address from string in Power Automate. Requirements like this usually are solved using regular expressions. Canvas apps have support for regular expressions. There are couple of functions in Power Apps like Match …

How to extract email address form string in Power Apps canvas apps Read More »

Check if Owner of a DataVerse record is User or Team in Power Apps canvas apps

Hello everyone and welcome to my blog. In today’s blog we will discuss on how to check if the owner of a dataverse record is a User or Team in Canvas apps. If you have worked with DataVerse, you know that you can set thee Owner of record either to a team or a user. …

Check if Owner of a DataVerse record is User or Team in Power Apps canvas apps Read More »

How to connect to SharePoint search API using certificate authentication

Hello everyone and welcome to my blog. Today’s blog is going to be bit different from my usual blogs on Power Apps and SharePoint. In this blog I will discuss on how to connect to SharePoint Search API using POSTMAN At the end of the article you will also learn the following topics. So let’s …

How to connect to SharePoint search API using certificate authentication Read More »

Create a X509 certificate and .pfx (p12) file using OpenSSL

Please follow the below code to generate the X509 certificate using openSSL The first step is to generate the certificate with the private key. For this open your Open SSL command prompt and type in the below command You will be prompted to enter few details related to the certificate as shown in the screenshot …

Create a X509 certificate and .pfx (p12) file using OpenSSL Read More »

How to introduce Delay or Wait in actions in Power apps canvas apps

Hello everyone and welcome to my blog. I today’s blog I will discuss on how you can introduce timeout/ wait/ delay for your actions in Power Apps canvas apps. Let’s take an example scenario to understand when you may need this feature. I have a very simple form to create a contact and once the …

How to introduce Delay or Wait in actions in Power apps canvas apps Read More »

Show Loading spinner when a Gallery is loading in Power apps canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss about a very interesting topic and something which is required for almost all Power Apps projects. Suppose you have a Gallery which display a list of records. And it may take a while while the data is fetched and loaded in the …

Show Loading spinner when a Gallery is loading in Power apps canvas apps Read More »

How to connect to excel file stored in SharePoint document library from Power BI Desktop

Hello everyone and welcome to my blog. In today’s blog I will show you on how you can connect to an excel file stored in SharePoint document library from Power BI Desktop. If you look this requirement, it seems really simple. Connecting to an excel file is not something we usually consider as a challenge. …

How to connect to excel file stored in SharePoint document library from Power BI Desktop Read More »

Bulk update Image column of SharePoint to a specific Image – using Power Automate – Part 2

Hello everyone and welcome to my blog. I am back with another blog on SharePoint and Power Automate flow. This post is a continuation of my previous post where I went through in detail on how to clear the value of image column of SharePoint through a Power Automate flow. We also saw how we …

Bulk update Image column of SharePoint to a specific Image – using Power Automate – Part 2 Read More »

Troubleshooting issues while connecting to Oracle database from Power BI Desktop

Hello everyone and welcome to my blog. Today’s blog will be on Power BI and I will discuss on the issues while connecting Power BI Desktop to Oracle data source. There is a fairly good documentation out here from Microsoft on how to connect to Oracle from Power BI. Then why this blog? Because even …

Troubleshooting issues while connecting to Oracle database from Power BI Desktop Read More »

The field of type ‘Note’ cannot be used in the query filter expression error in Power Automate

Hello everyone and welcome to my blog. In today’s blog I will discuss about a new requirement which is quite common but the solution to it is not straightforward as expected. The requirement is pretty simple. I have a SharePoint List for my Report Inventory which has a Description column. The description is an Out …

The field of type ‘Note’ cannot be used in the query filter expression error in Power Automate Read More »

How to make a phone call directly from your Power Apps canvas app

Hello everyone and welcome to my blog. In today’s blog I will discuss about a Power app feature to make phone calls directly from your canvas app. I have a simple Contact list gallery as show in the below screenshot. The idea is to make a phone call directly when clicked on the Phone icon …

How to make a phone call directly from your Power Apps canvas app Read More »

Auto height of text input control in Power Apps Canvas apps

Hello everyone and welcome to my blog. I am back with another blog on Power Apps. In today’s blog I will discuss on how to automatically adjust the height of text input control in Power Apps depending on content. Let’s understand the requirement first. I have a text input control and I have changed the …

Auto height of text input control in Power Apps Canvas apps Read More »

How to convert datetime to Unix (epoch) timestamp and vice versa in PowerApps canvas apps

Hello everyone and welcome to my blog. I am back with another blog on Power Apps and this blog is going to be short and sweet. In today’s blog I will discuss on how to convert Unix (epoch) time to DateTime and vice versa in Power Apps canvas apps. First of all we need to …

How to convert datetime to Unix (epoch) timestamp and vice versa in PowerApps canvas apps Read More »

Bulk update Image column of SharePoint list – using Power Automate – Part 1

Hello everyone and welcome to my blog. In today’s blog I will discuss about a very interesting topic related to Image column type in SharePoint List. Sometime back, Microsoft introduced Image column type for SharePoint list. It is indeed a great feature as prior to that if you have a list of products and you …

Bulk update Image column of SharePoint list – using Power Automate – Part 1 Read More »

How to create a modal dialog in Power Apps Canvas apps

Hello everyone and welcome to my blog. Today I will discuss about a very common requirement I come across in most of my projects. The requirement is to create a modal dialog (popup) in Canvas apps. As of the time of writing this blog, there is no modal dialog control in canvas apps. If you …

How to create a modal dialog in Power Apps Canvas apps Read More »

New expression editor in Power Automate

Hello everyone and welcome to my blog. Today I will discuss about the new and improved expression editor in Power Automate. Before you read further, a quick word of caution – This is an experimental feature and should not be tried on production instances. Navigate to your Power Automate flow window. Did I tell you …

New expression editor in Power Automate Read More »

How to change the owner of Power Automate flow from flow interface

Hello everyone and welcome to my blog. In today’s blog I will discuss about a frequently discussed topic – The capability to change the owner for Power Automate flows. For a very long time, this was not possible. And as hard it is to believe, the only resort was to change the owner through legacy …

How to change the owner of Power Automate flow from flow interface Read More »

How to filter a SharePoint list view by Hyperlink column in SharePoint online

Welcome to my blog readers. Today’s blog is on SharePoint and in today’s blog I will discuss a requirement which is quite common. But surprisingly there is hardly any solution to meet the requirement. So much hype about the requirement. What it is? The requirement is to create/ filter a SharePoint List view by Hyperlink …

How to filter a SharePoint list view by Hyperlink column in SharePoint online Read More »

How to create a SharePoint Hyperlink (URL) column with more than 255 characters

Hello everyone and welcome to my blog. In today’s blog I will discuss on how to create a Hyperlink column in SharePoint to store more than 255 characters. SharePoint list has a hyperlink column and more often than not it serves your purpose. But the problem arise when the URL is more than 255 characters. …

How to create a SharePoint Hyperlink (URL) column with more than 255 characters Read More »

Constant variables in Power Apps canvas apps – All you need to know about named variables in Power Apps

Welcome to my blog. I am back with another blog on Power Apps and today I am going to talk about a recently launched feature – “Named formulas“. What is this feature all about? If you look at the documentation of named formulas, your first impression may be – “Is it a new way of …

Constant variables in Power Apps canvas apps – All you need to know about named variables in Power Apps Read More »

How to pares JSON in Power Apps? The much awaited ParseJSON function is finally here.

Welcome to my blog. Before I go ahead, this is still an experimental feature and is not available in GA. Having said that, I am pretty sure a feature of this value and importance and something which Power Apps was missing for a long time, will certainly make it GA. Quite sometime back, Microsoft introduced …

How to pares JSON in Power Apps? The much awaited ParseJSON function is finally here. Read More »

String operations in Power Apps canvas apps – How to perform substring, indexof, lastindexof operations

Welcome to all my blog readers. Today’s topic is rather very simple. And especially so when Power Apps has been around for quite a few years now. Today we are going to do understand how to work with strings in canvas apps and what are the functions available in canvas apps for the same. If …

String operations in Power Apps canvas apps – How to perform substring, indexof, lastindexof operations Read More »

How to use AddColumns with Lookup fields of SharePoint in Power Apps

Welcome to all my blog readers. I am back with another blog on PowerApps. Today I will discuss on how to use the AddColumns function of Power Apps with lookup fields in SharePoint. If you are looking to query parent table data from Lookup columns, you will also find this blog useful. For this demo …

How to use AddColumns with Lookup fields of SharePoint in Power Apps Read More »

How to dynamically set value of Choices multi-select field in Power Apps portals

Welcome to all my blog readers. I am back with another blog on Power Apps; this time, it’s on Power Apps portals. Today I will discuss a very interesting requirement I came across. It’s about on how to dynamically set the value of a choices multi-select field in Power Apps portals. Support for choices multi-select …

How to dynamically set value of Choices multi-select field in Power Apps portals Read More »

Create AND/OR groups for your calculated fields in Model Driven Apps/Dynamics 365? DataVerse Power Fx columns can help you achieve it.

Hello everyone and welcome to my blog. Today I am going to discuss about a recently release topic. In fact it’s in preview stage but I am pretty sure this cool stuff is certainly going to be in General Availability soon. Calculated columns is there with Dynamics 365 and now DataVerse for quite some time …

Create AND/OR groups for your calculated fields in Model Driven Apps/Dynamics 365? DataVerse Power Fx columns can help you achieve it. Read More »

No Entities to select when creating SLA in Dynamics 365 Customer Service

Hello everyone. Welcome back to my blog. Today I will discuss about a common problem faced while creating a Service level agreement (SLA) in Dynamics 365 Customer service. If you are new to Dynamics 365 Customer service module or new to the unified interface, you may face this too. Let’s say I want to create …

No Entities to select when creating SLA in Dynamics 365 Customer Service Read More »

How to add existing controls and groups to a container control in Power Apps canvas apps

This blog will be a quick tip on how to add existing controls to a containers in Canvas apps. In the screenshot below, I have a Vertical container containing 3 buttons and three text input controls outside the container. I want to move the text input controls inside the container. If I check for options …

How to add existing controls and groups to a container control in Power Apps canvas apps Read More »

How to align and set margin for controls inside Vertical container – Power apps canvas apps

I am back with another blog on Power Apps. In today’s blog I will discuss on how you can align controls inside a vertical container in PowerApps. I will concentrate my discussion on how to space out the controls inside the container and set margins for controls. Let’s start with a very simple example here. …

How to align and set margin for controls inside Vertical container – Power apps canvas apps Read More »

Enable spell check for text input controls in Power Apps

I am back with another blog on Power Apps. In this blog I am going to discuss about a simple functionality – enabling spell check in Text input controls. Let’s get started. Power Apps has an inbuilt property to enable spell checker on Text Input controls. Below is the Text Input control with EnableSpellCheck set …

Enable spell check for text input controls in Power Apps Read More »

PowerApps now allow you to display SharePoint List images in four sizes. Check this out!

Welcome to all my readers. I am back with another blog on PowerApps. In this blog I am going to discuss about a new feature. PowerApps has recently launched the support for images (image column) from SharePoint lists. If you have an Image column in SharePoint list and you want to display that in PowerApps, …

PowerApps now allow you to display SharePoint List images in four sizes. Check this out! Read More »

How to use Plugin registration tool to register dependent assemblies in DataVerse/ Dynamics 365 plugins.

Welcome to all my blog readers. Today’s topic will be a bit longer than my usual blogs. I will talk about a new feature introduced with Power Platform 2022 Release wave 1. It’s a feature you have been awaiting for especially if you are a Power Platform/ Dynamics 365 Developer. Today I am will discuss …

How to use Plugin registration tool to register dependent assemblies in DataVerse/ Dynamics 365 plugins. Read More »

How to select a control in a specific row of gallery- power apps canvas apps

Welcome to all my blog readers. I am back with another blog on Power Apps. In today’s topic, I am going to discuss about a very simple requirement – How to select a control in specific gallery control row? For this blog, let’s take a very simple requirement. I have Gallery which shows the list …

How to select a control in a specific row of gallery- power apps canvas apps Read More »

When a record is selected – Dataverse trigger flow not showing

Welcome back to all my blog readers. In today’s blog I am going to share with you my recent experience while working with Power Automate flows. I have a model driven app which has a list of contacts for each account. I need a Power Automate flow which should run when a contact record is …

When a record is selected – Dataverse trigger flow not showing Read More »

How to check if a user is part of Office365Group in Power Apps canvas apps

Welcome back to all of my blog readers. I am back with another blog on Power Apps. In today’s blog I am going to discuss about a very simple requirement – “How to check if a user is a part of Office365 group?”. So let’s get started. First and foremost, the Office 365 Group related …

How to check if a user is part of Office365Group in Power Apps canvas apps Read More »

How to embed an image in an email in Power Automate

A warm welcome to all my blog readers. I am back with another blog on Power Automate. And today I am going to show you on how to embed an image in email body when we send an email using Power Automate. For this demo I will use an image stored in OneDrive for Business. …

How to embed an image in an email in Power Automate Read More »

How to get contents of an image column of SharePoint in Power Automate

Welcome to all of my readers. I am back with another blog on Power Automate. In today’s blog, I will walk you through on how to get the content of image column of a SharePoint list in Power Automate So let’s get started. I have a SharePoint List with an Image column. I create a …

How to get contents of an image column of SharePoint in Power Automate Read More »

How add or subtract weeks, months or years from a date in Power automate.

Welcome to all of my readers. I am back with another blog on Power Automate. This blog is rather simple and one of the most common requirements we may come across in our day to day work. How do I add or subtract weeks/ months/ years from a timestamp? We have the popular addHours, addMinutes, …

How add or subtract weeks, months or years from a date in Power automate. Read More »

Configure Dataverse connector to run under triggering user for Instant cloud flows in Power Automate

Greeting to all of my blog readers. I am back again with another blog on Power Automate. The feature I am going to talk about today is related to dataverse connector and how can configure the dataverse connector in your Power automate flow to run under triggering user. Honestly I was not aware that it’s …

Configure Dataverse connector to run under triggering user for Instant cloud flows in Power Automate Read More »

string comparison not working in Power Automate? know when it can fail.

Welcome to all my blog readers. Today’s blog post is rather interesting. A look at the title of the blog and you might be wondering – “What can be new here? Isn’t it the simplest of the functionalities to implement?”. Can’t deny that it is indeed simple. But sometimes the simplest of things can be …

string comparison not working in Power Automate? know when it can fail. Read More »

How to allow portal users to upload profile image in Power Apps portals

Welcome to all my readers. I am back with another blog on Power Apps portals. And this time also, it’s one of those nice little personalization experiences that you can expose to end users. Today I am going to discuss on how to allow portal users to upload their profile pictures. For that we first …

How to allow portal users to upload profile image in Power Apps portals Read More »

How to redirect user to Login Page after session timeout in Power Apps portals

It’s been sometime that I have written a blog on portals. However came across this requirement and thought of posting it for my readers. This blog focus on couple of topics. Configure session timeout in Power Apps portals. Redirect to the SignIn page or to any custom page of your choice post session timeout. If …

How to redirect user to Login Page after session timeout in Power Apps portals Read More »

{Solved} authorization_requestdenied error when querying graph API from Sharepoint Framework SPFx component.

Welcome to my blog. Today’s blog topic is going to be a little different from my regular topics which are usually on Power apps and Dynamics 365. My blog today is about an error I faced from my SharePoint framework extensions controls (SPFx). Quite new to SPFx development but I am learning something new and …

{Solved} authorization_requestdenied error when querying graph API from Sharepoint Framework SPFx component. Read More »

How to send notifications across apps in Power Apps Canvas apps

Welcome to my blog. In today’s blog I will discuss a simple requirement on how to send notifications across apps in canvas app. Did you ever had the following requirements? Send notification to a user from an app. Open a canvas app when a user press on the push notification. Pass data across canvas apps …

How to send notifications across apps in Power Apps Canvas apps Read More »

Generate Random numbers within a range in Power Apps Canvas apps

Welcome to my blog. In today’s blog i am going to discuss on the different options to generate random numbers in Power Apps canvas apps. Many a times in our development, we need to generate uniqueness – for example auto-generated unique number, unique control names etc. What better way than to use the traditional Rand() …

Generate Random numbers within a range in Power Apps Canvas apps Read More »

How to get first and last date of current month in Power Apps Canvas apps

Welcome back to my blog. I am back with another blog on Power Apps and this time it’s about a very common requirement. How to get the first and the last date of current month in Power Apps? Isn’t it too simple a requirement? It is indeed and something which you might come across as …

How to get first and last date of current month in Power Apps Canvas apps Read More »

OnStart property of the App not available in Power Apps canvas apps

Welcome to my blog and today I am going to share another tip that may help while you are working with Power Apps. This one is fresh out of experience from a project. We were developing a new Canvas app and all one of the developers informed me that they are not able to find …

OnStart property of the App not available in Power Apps canvas apps Read More »

How to get an item from an array, collection or table by index in Power Apps canvas app

Welcome to my blog and here I am back with another blog on Power Apps. Today I am going to write about a fairly new feature, a feature awaited from a pretty long time. Did you ever had the following requirements in Canvas apps? Get an array item at a particular index Get an item …

How to get an item from an array, collection or table by index in Power Apps canvas app Read More »

Concatenate string expressions in PowerApps Canvas apps using $ operator

Looking at the topic of this blog, you might be wondering – “What new I am going to learn here?” And specially if you have been working on PowerApps for some time, this question is even more relevant. Let’s see what’s new in here. If you want to display a Welcome message to a user …

Concatenate string expressions in PowerApps Canvas apps using $ operator Read More »

How to stop navigation from Lookup columns in Model Driven Apps grid

The feature that I am going to discuss in the blog has been there for sometime. But strangely I find many experienced consultants not aware of this feature. Hence decided to pen this down. But what is the requirement here? If you are working in Power Platform or Dynamics 365 products, you must be working …

How to stop navigation from Lookup columns in Model Driven Apps grid Read More »

Mistakenly deleted your Power Automate flow. You can now restore Power Automate flows deleted in last 28 days.

Ever had a scenario where you mistakenly deleted a Power Automate flow? Or may be you created a flow and when you go back later you don’t see it. You think someone might have deleted the flow. Unfortunately there was no way to retrieve it back. Well, no longer. With the Power Platform 2022 Release …

Mistakenly deleted your Power Automate flow. You can now restore Power Automate flows deleted in last 28 days. Read More »

Power Automate flows not getting triggered for environment.

This blog will rather be short. And based on one of my recent experiences in a project. The issue was Power Automate flows were not triggering for this environment. When a flow does not trigger, you tend to try out various things. The first thing is obviously to check if the flow trigger is correct. …

Power Automate flows not getting triggered for environment. Read More »

How to use hexadecimal color values in Power Apps canvas apps

This is going to be short and sweet. In Power Apps canvas apps, whenever we set the Color or Fill property of any control, we use RGBA code. For example – Fill property of Label control. If we try to put Hexadecimal values, Power Apps throw an error. If you are new to Power Apps, …

How to use hexadecimal color values in Power Apps canvas apps Read More »

How to display values of Person column of SharePoint list in a PowerApps combobox control

This is an interesting scenario and infact turned out to be tougher than I thought. Let’s look at the requirement first. I have a List in SharePoint which a Person column – Approver1. Screenshot below for reference. All I need is to show the values from Approver1 field in a combobox inside canvas app. Seems …

How to display values of Person column of SharePoint list in a PowerApps combobox control Read More »

How to show cursor hand for images in Power Apps Canvas apps

I am back with another blog on Power Apps and this time again it’s on a requirement which is pretty simple and yet tricky. We use images in our Canvas apps. And it’s quite obvious if you are building a canvas app for an organization, they will have their own themes and images you need …

How to show cursor hand for images in Power Apps Canvas apps Read More »

Horizontal Text alignment of Toggle control in Power Apps canvas apps

I am back with another quick tip for Canvas apps and this time it’s related to text alignment of Toggle control in canvas apps. We all love toggle controls. And if you worked with Canvas apps you know that any boolean field will display as toggle control. I have inserted a Toogle control on the …

Horizontal Text alignment of Toggle control in Power Apps canvas apps Read More »

{Quick Tip} How insert a vertical and horizontal line separator in Power Apps canvas apps?

As the name of the blog suggest, it’s going to be a quick tip and a really short one. But if you are new to Power Apps this might just turn out to be helpful. We can achieve the requirement in couple of ways. The first way is to use the Rectangle control. From the …

{Quick Tip} How insert a vertical and horizontal line separator in Power Apps canvas apps? Read More »

How to show a Choice Field as Radio Buttons in Power Apps Canvas app

I am back with another blog on Power Apps and this time I am going to show you on how to display a Choice field as Radio button list of forms. Did you ever had the following requirements? You need to display a Choice Field of SharePoint as Radio button list on Canvas app form? …

How to show a Choice Field as Radio Buttons in Power Apps Canvas app Read More »

How to dynamically add multiple attachments to a Power Automate approval flow?

Approval flows are great. The ability to approve/ rejects from emails or from Power Automate mobile app has indeed changed the way approvals are done. And if you think about approvals, you cannot skip attachments in approvals. Inside an approval flow, you can add multiple attachments. But how to send multiple attachments dynamically in SharePoint …

How to dynamically add multiple attachments to a Power Automate approval flow? Read More »

Power Automate Flows in Solutions are now also visible under My Flows section

I am back with another blog on Power Apps and today I am going to discuss about new feature that’s available with Power Platform 2022 Release Wave 1. Solutions are great. After all they are the core of ALM process when you move your changes from one environment to another. However there has always been …

Power Automate Flows in Solutions are now also visible under My Flows section Read More »

Resubmit multiple failed runs in Power Automate

I am back with another blog on Power Platform and this time it is about a new feature introduced in Power Platform 2022 Release wave 1. Imagine you have a cloud flow (automated/ instant/ scheduled) which started failing. And by the time you identified the error, quite a number of flow instances have failed. Let’s …

Resubmit multiple failed runs in Power Automate Read More »

Email is not triggered for Power Automate Approvals to Microsoft 365 groups.

Power Automate approvals are great and much used. And why not? Afterall they allow users the capability to approve/ reject from their mailboxes and also configure multiple scenarios related to approval process. When you are working on Approvals, more often than not you need to send email to Office 365 Groups. Think of an invoice …

Email is not triggered for Power Automate Approvals to Microsoft 365 groups. Read More »

How to get Comments of a Sharepoint List Item in Power Automate

I am back with another blog on Microsoft Power Platform. It’s about Comments feature for a SharePoint List Item and how we can retrieve them using Power Automate. In SharePoint for every list item we can specify comments. And you can specify multiple comments with mentions. In the below screenshot, you can see I have …

How to get Comments of a Sharepoint List Item in Power Automate Read More »

How to update Single or Multi person field in SharePoint from Power Apps Canvas apps

SharePoint lists and Canvas app are match made in heaven. If you are a Power Platform consultant you must have come across multiple canvas apps which use SharePoint as data source. Today’s blog is also about using Canvas apps with SharePoint data source. In this blog, I will show you on how to dynamically set …

How to update Single or Multi person field in SharePoint from Power Apps Canvas apps Read More »

How to get the app name inside plugins in Dynamics 365/ Model driven apps.

The importance of age old plugins never ceases to exist. Since the advent of Microsoft CRM plugins has been there and I presume it will be there in the years to come. Since the introduction of model driven apps, it has always been a ask to execute app specific logic inside plugins. The necessity of …

How to get the app name inside plugins in Dynamics 365/ Model driven apps. Read More »

Users in Dynamics 365/ Data Verse can be assigned security roles from multiple business units. How does this effect you existing security model?

Before I start the blog, a quick reminder – The feature we are going to discuss here is a preview feature. Since the advent of erstwhile Dynamics CRM and later Dynamics 365 and now in DataVerse, a user can belong to a single business unit. And a user can be assigned a security role of …

Users in Dynamics 365/ Data Verse can be assigned security roles from multiple business units. How does this effect you existing security model? Read More »

Hide your system views in Model Driven Apps/ Dynamics 365 Apps

2022 Release Wave 1 bring in a host of features for Dynamics 365 Apps and Power Platform. While some updates are discussed pretty much everywhere because of their impact, there are quite a few cool changes which goes unnoticed. And one of them is the ability for users to hide system view from their Model …

Hide your system views in Model Driven Apps/ Dynamics 365 Apps Read More »