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

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 »

How to create SSL certificate request with SAN (Subject alternate names) using OpenSSL

Readers who follow my blog know that I am an avid writer on Power Apps and Dynamics 365. And this blog is about creating a SSL certificate with SAN using OpenSSL. I have been working for a Dynamics 365 on-premise and the requirement was to go IFD. And it’s quite obvious that for IFD I …

How to create SSL certificate request with SAN (Subject alternate names) using OpenSSL Read More »

How to import data from an excel file into an existing SharePoint list

This is going to be short and precise and probably very useful for citizen developers. My blogs have mostly been related on Power Apps and if you are someone who have started working with Power Apps recently, you might end up with using SharePoint as the data source. Let’s take an example here. I have …

How to import data from an excel file into an existing SharePoint list Read More »

Need to add a Power Automate flow to Power Apps? Enable the Power Automate pane for an improved maker experience

Power Automate and Power Apps Canvas apps are powerful on their own but they are even better together. If you have implemented a requirement using Power Apps Canvas apps, you must had that requirement where you need to call a Power Automate flow on click of a button or on an event of a controls …

Need to add a Power Automate flow to Power Apps? Enable the Power Automate pane for an improved maker experience Read More »

Having a hard time with Power Apps formulas? Use Power Apps Ideas to transform your natural language/ SQL based queries to Power Apps formulas.

The introduction of Power Apps have encouraged professionals from various sectors to jump into the world of application development. Someone who were expert in business processes but no past experience in programming, are now finding feet in the world of application development. While this is encouraging, it can be a steep learning curve for citizen …

Having a hard time with Power Apps formulas? Use Power Apps Ideas to transform your natural language/ SQL based queries to Power Apps formulas. Read More »

Configure custom SLA pause conditions in Dynamics 365 Customer Service apart from status reason.

This is a fairly new feature and introduced in 2022 Release Wave 1. The GA is April 2022 That’s an announcement. But now comes the interesting part. What this functionality is about? For a very long time, we are able to pause and resume our Service Level Agreements (SLA’s). And that was based on status …

Configure custom SLA pause conditions in Dynamics 365 Customer Service apart from status reason. Read More »

How to get entitysetname while setting lookup value in Power Automate

If you have worked with DataVerse and Power Automate, chances are likely that you have created a record in DataVerse using Power Automate. And when you create a record, there are times when you need to need to set a lookup field on the record. This post is specially relevant if you are trying to …

How to get entitysetname while setting lookup value in Power Automate Read More »

Multilingual capability in Power Apps Canvas apps

You have a built a canvas app and you need to roll out your app in different languages for users accessing from different regions. If this is your requirement, this blog might just help you. Basically we need to implement multi-lingual capability in canvas app. Now there can be many ways to implement this. But …

Multilingual capability in Power Apps Canvas apps Read More »

Connect to excel in One Drive from Power Apps Canvas apps? Connect using Excel Online (Business connector) instead of OneDrive for Business Connector.

Excel was there, is there and will be there forever. One of the most loved tools from Microsoft if not the most and something which everyone is comfortable with. Using excel files stored in OneDrive as datasource with Power Apps Canvas apps is a very common scenario. We see so many businesses transitioning to Power …

Connect to excel in One Drive from Power Apps Canvas apps? Connect using Excel Online (Business connector) instead of OneDrive for Business Connector. Read More »

Convert first letter in each word to Upper case in Power Apps canvas apps.

As strange it may sound, if I ask this question to experienced Power Apps developers, the first thing that shall come to mind of many is to write some custom logic. And I don’t blame anyone. After all it is virtually impossible to remember each and every function within Power Apps. With every release, we …

Convert first letter in each word to Upper case in Power Apps canvas apps. Read More »

Enabling Power Apps Model Driven apps for offline capability

Erstwhile with Dynamics 365 Apps and custom Model driven apps, setting up an app for offline capability shall require multiple steps You have to create offline profiles Add tables for offline mode Set users to offline profiles Enable the Model driven app for offline availability and then select the appropriate profile. Well the latest release …

Enabling Power Apps Model Driven apps for offline capability Read More »

How to send multiple attachments in email from SharePoint list item using Power Automate

SharePoint and Power Apps are like match made in heaven. More often than not I find Power Apps implementations on top of SharePoint data. And if you are working with SharePoint data, you must have worked with SharePoint ListItem. And with that, here is the requirement. Whenever an item is added to SharePoint list item, …

How to send multiple attachments in email from SharePoint list item using Power Automate Read More »

How to create variable of data source type in Power Apps Canvas apps

This one is really interesting and trust me, even if you are an experienced Power Apps developer, this may be something you learn today. Say you are working with DataVerse and you want to declare a variable of type Account. In conventional DataVerse server side conventional programming, you can do something like this. Well, in …

How to create variable of data source type in Power Apps Canvas apps Read More »

How to get Timezone of current user in Power Apps Canvas apps.

Date and Time related queries are kind of intriguing. With people from all over the globe, accessing an application from various timezones, handling date and time issues is not for faint hearted. And related to that, there is a question – “How do I get the timezone of a user inside a Power App?” When …

How to get Timezone of current user in Power Apps Canvas apps. Read More »

Dynamically Navigate across screens in PowerApps Canvas apps by name

In today’s blog I will discuss how you can navigate screens dynamically based of name in Power Apps canvas apps. Before I go ahead and suggest a solution, let’s understand the requirement here. Below I have a gallery showing the list of contacts. And say I have a requirement. And the requirement is, if I …

Dynamically Navigate across screens in PowerApps Canvas apps by name Read More »

How to create a people picker in Power Apps Canvas apps using combobox

I am back with another blog on Power Apps and this one I am quite sure you would find interesting. People picker controls are great as they allow you to select the users from Office 365. If you are working with SharePoint data source, you will find People picker controls. Precisely this is how they …

How to create a people picker in Power Apps Canvas apps using combobox Read More »

User().Email not returning correct email of the user in Power Apps canvas apps

I am back with another blog on Power Apps and this time I will discuss about a very simple requirement. The requirement is to get the email address of a user in Power Apps canvas apps. It’s so common a requirement that anyone developing Canvas apps at basic level is aware of how to do …

User().Email not returning correct email of the user in Power Apps canvas apps Read More »

Get latest copy or refresh a record from datasource in Power Apps canvas apps

Looking at the title of this post, you might be wondering – Isn’t it pretty easy? After all we have the Refresh function in Power Apps which refreshes an entire datasource. However, there are situations where you want to refresh a single record from a datasource. Suppose you are working on a form for sometime …

Get latest copy or refresh a record from datasource in Power Apps canvas apps Read More »

How to populate parent lookup field during create of child record from sub-grid in Power Apps portals.

Creating a child record from the subgrid of parent record form – a task which we perform in DataVerse Model-driven apps almost everyday and in every implementation. And whenever we click on “+” icon of the subgrid, the child record form open and it has the parent lookup automatically set. I don’t think I need …

How to populate parent lookup field during create of child record from sub-grid in Power Apps portals. Read More »

How to reset the selected item of a Gallery in Canvas app?

I am back with another blog on Power Apps and this again is about a frequently asked question – “How do I reset the selected item in Gallery in Power Apps Canvas app? “. You might be wondering, won’t it be as simple as calling the Reset function of the gallery control. Well, I assumed …

How to reset the selected item of a Gallery in Canvas app? Read More »

How to delete Audit logs in Power Platform DataVerse environments after a specified time

I am back with another blog on PowerApps and this time it’s on DataVerse. The ability to audit record operation on dataverse is great! You can track the edits, creates and delete of records in dataverse using audit. But with this advantage, there comes a problem. And the problem is with audit log storage. With …

How to delete Audit logs in Power Platform DataVerse environments after a specified time Read More »

How to clear a collection inside ForAll in PowerApps Canvas apps

It’s been a long time I have written a blog on Canvas apps. So I made sure I start it back with a rather simple but interesting one. The function Clear or ClearCollect cannot be invoked within ForAll. Have you ever received the above error? If yes then you are on the right blog. The …

How to clear a collection inside ForAll in PowerApps Canvas apps Read More »

How to get choice/ optionset/ lookup text in Power Automate flow using Formatted value property.

In this blog, I am going to introduce something which has been really long awaited in Power Automate flows. I am not going to show any workarounds here. Rather some new property introduced in Power Automate which you may not be aware of. How many of you had the following requirements? Lot of hands raised …

How to get choice/ optionset/ lookup text in Power Automate flow using Formatted value property. Read More »

How to compare dates in Power Automate

Introduction of Power Automate has been a revolution when it comes to automations and connecting disparate systems. Stuffs which used to take days can now be done in few hours. And yet, sometimes the simplest of tasks in Power automate require some workarounds. And one such requirement is to compare dates in Power Automate. If …

How to compare dates in Power Automate Read More »

How to check user permission/ privilege on a record/ table in Power Apps Canvas app

If you are in this blog, I am sure the title of the blog must have got you pretty excited by now. Well the topic is interesting indeed but as of the time of writing this blog, this apply only to DataVerse data source. I am pretty sure, Microsoft shall extend this support to other …

How to check user permission/ privilege on a record/ table in Power Apps Canvas app Read More »

How to write nested For loop in Power Apps Canvas apps

I am back with another blog on Canvas apps and this time it’s about on how to write nested loops inside Power Apps canvas apps. However if you are having this requirement, the blog might just be the time saver for you. So let’s get started. How do we write For loops inside Canvas apps? …

How to write nested For loop in Power Apps Canvas apps Read More »

How to show Notifications which automatically disappear after certain time in Power Apps Canvas apps

I am back with another blog on Power Apps and I am hopeful you will find this interesting. In this blog I am going to discuss on how to display ‘Toast Notifications‘ in Canvas apps. Toast Notifications are not a new concept. Infact it’s an age old concept associated with the UI design. A toast …

How to show Notifications which automatically disappear after certain time in Power Apps Canvas apps Read More »

How to add a custom trigger phase in Greeting topic in Power Virtual agents Chatbot

I have been working a lot on Power Apps and Power Automate since few years now. And never really got a chance to work with Power Virtual agents in a real time project. And finally got a chance. And with that came the opportunity to write this blog. If you have worked on Power Virtual …

How to add a custom trigger phase in Greeting topic in Power Virtual agents Chatbot Read More »

How to compare with @ character on a condition action in Power Automate

This is one of the easiest blogs I may have written on Power Automate. And honestly I thought twice before even posting this blog. But then I verified this with couple of citizen developers in the project and both of them struggled doing this for sometime before eventually doing it successfully. While this is walk …

How to compare with @ character on a condition action in Power Automate Read More »

How to extract an excel file like an archive in One Drive folder using Power Automate

With Office 2003, Microsoft have changed the way an excel is formatted. From excel 2003, excel files are essentially zip files. If you change the excel file extension to .zip you should be able to extract the contents of the excel file into a folder. What if you need to automate this process in your …

How to extract an excel file like an archive in One Drive folder using Power Automate Read More »

How to convert a string to currency format in Power Automate

It’s been sometime I wrote a blog on Power Automate. And today’s blog is very simple. And trust me, this requirement is one of the most common requirements. Convert an input into currency format, for example you want to convert 1234.567 to $1234.567 or for that matter any other currency is one of the most …

How to convert a string to currency format in Power Automate Read More »

How to dynamically show the start screen of an App in Power Apps Canvas apps?

Welcome to another blog on Power Apps. If you are in the blog, you must have worked with Canvas apps. And if you have worked on Canvas apps, you are aware that by default,  the first screen shown when an app starts is the first in the Tree View in Studio. More often than not, …

How to dynamically show the start screen of an App in Power Apps Canvas apps? Read More »

Exception: Could not find any valid connection for connection reference name ‘shared_office365users’ in APIM tokens header.

I am back with another blog on Power Apps and this time it’s about a strange error that I received while invoking a Power Automate flow from the Power Apps. I had simple Power Automate flow that I was invoking from the Power Apps. And it was working fine. However the requirement came to get …

Exception: Could not find any valid connection for connection reference name ‘shared_office365users’ in APIM tokens header. Read More »

How to search users from Office365 in Power Apps Canvas app

We are all aware of Office365 Users connector through which we can fetch details of a user from Azure AD in our Canvas apps. Personally I simply love this connector. I still remember my old ways where I would literally spent days to fetch user details from active directory and display them. If you are …

How to search users from Office365 in Power Apps Canvas app Read More »

How to add time to datepicker control in Canvas apps

Date picker is a very common control you use in Canvas apps. And sometimes, these simple controls pose us a challenge. And once such challenge I faced is to add time component to select Hours and Minutes to the Date Picker control. Below is a date picker control on canvas app screen. As you can …

How to add time to datepicker control in Canvas apps Read More »

How to use Count/ Sum using GroupBy in Power Apps Canvas Apps

I am back with another blog on Power Apps and in this blog I will discuss on how to use SUM or COUNT using GroupBy function in Power Apps. While this seem to be pretty easy in different programming languages, it can come across bit tricky while trying to do the same in Power Apps. …

How to use Count/ Sum using GroupBy in Power Apps Canvas Apps Read More »

How to filter a datasource in Canvas app based on Choice/ Optionset field

This blog is short and simple. And quite a common requirement I guess. How do I filter a datasource in canvas app based on Choice field? If you have worked on Canvas app, you must have used the Filter function. And sometimes in that filter you shall need to use a Choice field value as …

How to filter a datasource in Canvas app based on Choice/ Optionset field Read More »

How to get an item at a particular position in a collection in Power Apps Canvas apps?

Here I am back with another blog on Power Apps and this time I shall discuss about one of the simplest requirements. Get an item at specific position inside a collection in Power Apps. If I take this question to anyone exposed to basic programming, the answer shall be – “I would get it by …

How to get an item at a particular position in a collection in Power Apps Canvas apps? Read More »

How to create responsive layouts for your Power Apps Canvas apps and adjust to Device rotations?

Responsive layouts. They are everywhere. If you are designing a modern app, responsive layout is kind of taken for granted. Power Apps Canvas apps allow you to create enterprise grade B2B apps for mobile platform. And quite obviously, it must have responsive layout capabilities. As surprising it is, I have seen developers doing all the …

How to create responsive layouts for your Power Apps Canvas apps and adjust to Device rotations? Read More »

How to block all users in a tenant from accessing a canvas app/ model driven app in PowerApps?

As of the time of writing this blog, this is a preview feature. But I am quite confident that such a useful feature shall make it to production. You have a canvas app which is widely used across your organization. You are about to make a major release of the app. But this time you …

How to block all users in a tenant from accessing a canvas app/ model driven app in PowerApps? Read More »

How to switch from New Form to Edit Form after record creation in Power Apps Canvas Apps?

This is my another blog on Power Apps and quite an interesting one. The requirement is to show the newly created record in an edit form immediately after creating the record. After reading this blog you should be able to handle the following requirements. Switch the form mode of Power Apps Canvas apps from new …

How to switch from New Form to Edit Form after record creation in Power Apps Canvas Apps? Read More »

How to swap Camera to front and back in Power Apps Canvas Apps

I am back with another blog on Power Apps and this time it is a really simple requirement. There is Camera control on the form and using the Camera control, the user should be able to switch between back and front cameras. A very generic requirement where the user can upload a pic from their …

How to swap Camera to front and back in Power Apps Canvas Apps Read More »

How to make a Phone field clickable in Power Apps Canvas apps?

This blog post is rather going to be a short and sweet. One of the most common requirements you may come across. How do I make a mobile number clickable in Power Apps Canvas apps? I have form with a text input for mobile number. The idea is to open the phone app to dial …

How to make a Phone field clickable in Power Apps Canvas apps? Read More »

Select record from grid and open an editable form in side by side pane in Model Driven Apps/ Dynamics 365

As of the time of writing this blog, this is a pre-release documentation. But I am pretty sure, such an awesome feature is certainly going to make it to release. So what are we discussing here? Did you ever had the following requirements? You want to show the view and record form for an entity …

Select record from grid and open an editable form in side by side pane in Model Driven Apps/ Dynamics 365 Read More »

How to get the created record id and other details using Patch in Power Apps Canvas apps?

I am back with another blog on Power Apps and this time after quite a gap of almost a month and half. And since this a blog after some time, I am going to share something very helpful in your day to day encounter with canvas apps. Recently I was conducting this Power Apps session …

How to get the created record id and other details using Patch in Power Apps Canvas apps? Read More »

{Solved} contextUserId=XXXX-XXXX-XXXX-XXXX-XXXXXXXXXXX has correct privileges but allowImpersonationOfOrganizationSystemUser == false

It’s been sometime that I have written a blog on on-premises Dynamics 365. But whenever I get a chance, I don’t miss an opportunity to write on them. Reminds me of the good old interesting days of working with Dynamics 365 on-premise. Well, coming back to the topic. One of my customer received this error …

{Solved} contextUserId=XXXX-XXXX-XXXX-XXXX-XXXXXXXXXXX has correct privileges but allowImpersonationOfOrganizationSystemUser == false Read More »

How to check NULL values in Power Apps Canvas Apps

I am back with another blog on Power Apps and this is one more for citizen developers who are still finding their feet in PowerApps. While conducting trainings on Power Platform, one of the frequent question I get from citizen developers and sometimes even from experienced developers coming into Power Platform is – “How do …

How to check NULL values in Power Apps Canvas Apps Read More »

How to do Error handling similar to try/ catch in Power Apps Canvas apps

How do I perform error handling in my Canvas Apps in Power Apps? This is a question I face in almost every training I conduct in Power Apps. After all why not? Isn’t it the most simplest of requirement to catch an error in an application if something goes wrong so that end-users don’t face …

How to do Error handling similar to try/ catch in Power Apps Canvas apps Read More »

{Solved} Could not find service ReportServer$SSRS error while installing SSRS reporting extensions in Dynamics on-premise

This is a continuation of my previous blog where I explained on how to resolve the issue in SSRS instance is showing blank while installing reporting extensions for CRM V9.0 on-premise. The above blog solve the issue of blank SSRS instance and then you can proceed to installation. However at the final step of installation …

{Solved} Could not find service ReportServer$SSRS error while installing SSRS reporting extensions in Dynamics on-premise Read More »

Async OnSave handlers in DataVerse/ Dynamics 365 forms to cancel save operation, stop save till certain async events are executed. Check this out!

OnSave event handlers on an entity/table form in Dynamics 365/ DataVerse has been there for ages. And I have hardly come across implementations which does not have scripts written onsave event of an entity form. With onsave event handlers, the following requirements frequently come up. Cancel save event of form in based on custom validations …

Async OnSave handlers in DataVerse/ Dynamics 365 forms to cancel save operation, stop save till certain async events are executed. Check this out! Read More »

How to convert JSON array from Power Automate into a collection in PowerApps Canvas app

So I am back with another blog on PowerApps and this one is rather interesting. This is about a requirement which time and again come up in almost every requirement. Did you ever had the following requirements? Bind JSON array from flow to a Gallery or DataTable in PowerApps canvas app Convert a JSON array …

How to convert JSON array from Power Automate into a collection in PowerApps Canvas app Read More »

How to show a custom confirmation message when user exit a PowerApps Canvas app

So I am back with another blog on PowerApps. And this is yet another blog for a query I received from one of the blog readers. Canvas apps have virtually closed out the gap between pro and citizen developers in terms of application development. Whenever we talk of Power platform components, I find it’s the …

How to show a custom confirmation message when user exit a PowerApps Canvas app Read More »

How to delete and share personal document templates in Dynamics 365/ DataVerse

These days Power Platform and specially Power Apps have taken over and erstwhile Dynamics 365 products have taken a backseat. However some of the old features are still gold today and one of them is the Document template feature introduced 3-4 year back. Back then when it was released, it was quite a thing. It’s …

How to delete and share personal document templates in Dynamics 365/ DataVerse Read More »

How to resolve msbuild is not recognized as internal or external command error in visual studio code

I have working a lot recently with visual studio code and why not. I am into Power platform and with power platform developer extensions focused more on client side technologies, I association with visual studio code shall be for long. And whenever I develop PCF Controls, I am on this platform. Where you are an …

How to resolve msbuild is not recognized as internal or external command error in visual studio code Read More »

Planning to use views with column comparison in Power Apps portals? You are in for a surprise.

Introduction of column comparison in FetchXML came as relief for so many consultants like me who have been working on Dynamics 365 platform for over a decade now. It was rather hard to understand why a feature which is quite basic and in demand took more than a decade to be finally inducted in the …

Planning to use views with column comparison in Power Apps portals? You are in for a surprise. Read More »

How to get OptionSet/ Choice text from DataVerse in Power Automate

Microsoft have recently introduced an easier way to get the choice text. Check this blog out.If you can’t see this feature yet in your environment and you need an alternative way, please continue reading. I am back with another blog on Power Automate and this time it’s again a question from citizen developer. I get …

How to get OptionSet/ Choice text from DataVerse in Power Automate Read More »

How to Dynamically show/ hide buttons on entity list grid in PowerApps portals

I am working on PowerApps project for my customer and recently I got a requirement to show/ hide buttons on entity list item depending on condition. To explain the requirement in more detail, I have the following action buttons on my entity list grid. View details and Edit record are the two action buttons I …

How to Dynamically show/ hide buttons on entity list grid in PowerApps portals Read More »

Assign a user rights to create application in Azure active directory.

Sometime back I wrote a blog on how to resolve the error “You don’t have required permissions to create Azure Active Directory applications” while configuring Power Apps portal. In that blog I explained that to get rid of the error, you need to make sure that the account used to configure a portal is having …

Assign a user rights to create application in Azure active directory. Read More »

How to upload a custom javascript web file in Power Apps portals

So here I am back with another blog on portals and this time it’s about very basic requirements You want to refer external script libraries in your Power Apps portals pages. You want to upload a javascript file as web file in your Power Apps portal and reference it from your web pages or web …

How to upload a custom javascript web file in Power Apps portals Read More »

How to open a related record entity form conditionally in Power Apps Portals/ Dynamics 365 Portals

It’s been sometime that I have written a blog on PowerApps Portals. And today I am going to share something interesting to my blog readers. The requirement is very simple here. I have Entity A and Entity B with 1:N relationship. On entity form for Table A, I want a button to create a child …

How to open a related record entity form conditionally in Power Apps Portals/ Dynamics 365 Portals Read More »

How to remove duplicate items from a collection in Power Apps

This topic is pretty interesting. If you look at the requirement here, it can’t be simpler than this. I need to remove duplicate items from a table/ collection. Or even more generic requirement to remove duplicate items from a gallery. If you are coming from programming background or database SQL experience, it’s another day at …

How to remove duplicate items from a collection in Power Apps Read More »

How to substract two datetime objects in Power Automate

Substracting dates – Can it be any simpler than this? Well quite not when it comes to Power Automate. Whenever we need to substract dates, we usually think of the functions – diffInDays, diffInMonths etc. While the method described here works too, there is a better way to achieve this. You can check it out …

How to substract two datetime objects in Power Automate Read More »

How to get index number in Do Until and Apply to each in Power Automate

Loops – it existed since the inception of programming and it’s there in all languages and platforms. And why then Power Automate shall be an exception? Power Automate too has the ‘Apply to Each‘ which basically works like forEach and ‘Do Until‘ which is basically the traditional do-while. And with that a requirement come often. …

How to get index number in Do Until and Apply to each in Power Automate Read More »

How to convert XML string to JSON object in Power Automate

So here I am back with another blog on Power Automate and again one simple but widely used functionality. How do you convert XML string in JSON object? If you are thinking I am going to show you something really hard here, you are in for a surprise. There is an OOB function available in …

How to convert XML string to JSON object in Power Automate Read More »

How do you Print in PowerApps Canvas apps?

PowerApps have taken over the low code/ no code market by storm and especially Canvas apps are really a treat to watch. Gone are the days when you need to employ an out and out techie to design applications on mobile platforms. Canvas apps have opened up mobile app development to developers as well as …

How do you Print in PowerApps Canvas apps? Read More »

Add Dynamic content/ expression editor not showing in Power Automate flow designer

This one is going to be really short and sweet. I was conducting a training in Power Automate and was demoing to the participants on how to use expressions in Power Automate. Majority of the participants were able to follow the labs and add the expressions. However some of the participants reported that they are …

Add Dynamic content/ expression editor not showing in Power Automate flow designer Read More »

How to compare two Array objects Power Automate

This is another requirement which is quite common but may be difficult for citizen developer. After I wrote the blog post on how to find unique elements in an array, I received a query on how to perform the following operations. Intersection of two arrays Union of two arrays. Compare array objects based on array …

How to compare two Array objects Power Automate Read More »

How to check if an employee is Out of Office using Power Automate

I am back with another blog on Power Automate. And again a blog on request of one of citizen developer. The requirement here is very simple. In a flow, we need to determine if a particular user is Out of Office. Depending on whether user is OOF, we would take decision to send the email …

How to check if an employee is Out of Office using Power Automate Read More »

How to get GUID of selected view in Dynamics 365/ Model driven apps home page grid

Welcome back to another blog post on Dynamics 365/ Model driven app and today I am going to discuss about a unique requirement. Get the GUID of selected view of a table in Model driven apps entity list/ grid. Basically get the GUID of ‘My Active Contacts’ view. In my case, the client wanted it …

How to get GUID of selected view in Dynamics 365/ Model driven apps home page grid Read More »

How to handle save complete event in client side in Dynamics 365/ Model driven apps

Before I go ahead and explain, let me accept this. I was not aware of the newly introduced client APIs in Model driven apps. And this one was pure serendipity. You might be thinking – Isn’t there formContext.data.save().then(successCallback, errorCallback) function which allow us to do that? Yes it does. But I am not talking about …

How to handle save complete event in client side in Dynamics 365/ Model driven apps Read More »

How to check if today is starting day of month using Power Automate?

Power Platform is for citizen developers. For Power Users who are masters of their business process but lacks the technical background to build an application out of that knowledge, Power platform have provided a level playing field. Last few posts, I wrote based requests of enthusiastic citizen developers. This is one more query I received …

How to check if today is starting day of month using Power Automate? Read More »

Error while creating an Application User in Dynamics 365/ Model driven apps

These are days of integration. And when it comes to Power platform, you have plenty of options to do the same. And one of the most common ways to interact with data of DataVerse (Common Data Service) is through the method of registering an app in azure active director and provide necessary permissions to the …

Error while creating an Application User in Dynamics 365/ Model driven apps Read More »

How to convert HTML file to PDF using Power Automate

Power Automate have simplified our tasks to a great extent. Requirements which would take few months previously are now accomplished in few weeks and weeks development may be in days. And here is one such requirement I will discuss. The requirement is very simple. Convert HTML document to PDF. Basically if you have the following …

How to convert HTML file to PDF using Power Automate Read More »

Error: Required argument –publisher-name/ –publisher-prefix is missing

It’s been sometime I have written blog on PCF control. While my first blog still date back to one of the earliest detailed step by step blog on PCF and probably written couple of days after PCF preview release, unfortunately I could not write up much on PCF from that point. However I find so …

Error: Required argument –publisher-name/ –publisher-prefix is missing Read More »

Show/ Hide header and ribbon menu dynamically on Dynamics 365/ Model Driven App forms

Recently I cam across a requirement from customer to control the header section visibility of Dynamics 365/ Model driven app form. For a very long time, Microsoft didn’t had any API’s to work with headers in model driven apps. You could work with controls on the header but if you had a requirement to show/ …

Show/ Hide header and ribbon menu dynamically on Dynamics 365/ Model Driven App forms Read More »

Trigger a Power Automate flow only when a column has a specific value in SharePoint list

I am working on SharePoint in one of my recent projects and kind of like a lot the way Microsoft have tightly coupled the SharePoint events with Power Automate. There are so many stuffs that you can do in SharePoint through Power Automate in a matter of minutes. And here I was with a very …

Trigger a Power Automate flow only when a column has a specific value in SharePoint list Read More »

Integrate Dynamics CRM on-premise with SharePoint online without IFD? Try out the SharePoint Attachment Manager from XrmForYou

Sometime back I wrote a blog on the common obstacles faced while setting up CRM on-premise integration with SharePoint online. We have a very detailed documentation from Microsoft which explains the step by step details on how to do the same. While these documentation are very detailed, everyone will agree that it’s quite an effort …

Integrate Dynamics CRM on-premise with SharePoint online without IFD? Try out the SharePoint Attachment Manager from XrmForYou Read More »

How to set focus on first control of a form in Power Apps canvas app

So I am back with another blog on Power Apps and today I am going to discuss with you a very simple requirement. How do I set focus on first field inside a canvas app create or edit form? This is one of the most common requirements I come across and why not? After all …

How to set focus on first control of a form in Power Apps canvas app Read More »

How to parse QueryString in Power Automate

Power Automate has changed the way we looked at automations and integrations. Things which used to take weeks if not months can now be achieved using in days/ hours. This is because of the huge number of functions available in Power Automate. To be honest, exploring all these at one go is kind of improbable …

How to parse QueryString in Power Automate Read More »

How to Query Metadata in DataVerse/ Common Data Service using Power Automate

Power Automate is flexible, powerful and not to forget, the future of Power Platform operations. And if you are working on DataVerse or the erstwhile Common Data Service, it is quite improbable that you haven’t worked with the CDS connector in Power Automate. Yet sometimes it is surprising to see some basic stuffs which could …

How to Query Metadata in DataVerse/ Common Data Service using Power Automate Read More »