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

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 »

How to remove first and last character(s) from a string in Power Automate

Reading the title of the blog you might be wondering – “Why this blog?”. After all trimming characters from a string is a mundane job and every language has a function to do that. With all the might that Power Automate has, there must be a trim function to perform the same operation in Power …

How to remove first and last character(s) from a string in Power Automate Read More »

How to Add/ Remove property from a JSON object dynamically using Power Automate

I am back with another blog on Power Automate. There is so much Power Automate can offer that you hardly run out of topics to share it through blogs. And one such topic is the ability to dynamically add/ remove properties from a JSON object. In this blog I am going to discuss the below …

How to Add/ Remove property from a JSON object dynamically using Power Automate Read More »

How to show Months and Weekdays in dropdown in Power Apps canvas apps?

After my last few blogs, this one is relatively simple. But nonetheless this is quite interesting and a requirement which frequently pop up. This blog will basically cover the following requirements Show list of months in Dropdown/ combo box like – January, February, March, ……, December Show the list of months in dropdown or combobox …

How to show Months and Weekdays in dropdown in Power Apps canvas apps? Read More »

Business process flow not appearing on Dynamics 365/ CDS form although the user has access to process flow table? Check this out!

With the advent of Power platform and DataVerse we don’t talk about Dynamics 365 much these days. But essentially the learnings of Dynamics 365 help us a lot to work in DataVerse (CDS) environments, considering they both share the same platform. We can’t deny the fact that one of the most used and talked about …

Business process flow not appearing on Dynamics 365/ CDS form although the user has access to process flow table? Check this out! Read More »

{Solved} Key properties cannot have null values error when performing aggregate queries using List records step in Power automate

Sometimes the simplest of the requirements surprise you and here is one of them. With Power automate becoming stronger with every release, it is unfathomable that these issues still exist in Power platform. So what’s the requirement here? It can be as simple as you can imagine of. I needed to perform some aggregate operation …

{Solved} Key properties cannot have null values error when performing aggregate queries using List records step in Power automate Read More »

How to edit a parent record from Child record form in Dynamics 365/ Dataverse?

Microsoft is releasing updates to Power platform every quarter and honestly it’s so tough to keep track of the numerous enhancements that are pushed on to the platform. But the one thing that caught my eye and perhaps didn’t gain much publicity is the introduction of Form component control. So it’s another control in Microsoft …

How to edit a parent record from Child record form in Dynamics 365/ Dataverse? Read More »

How to query more than 5K CDS records using FetchXml in PowerAutomate/ Microsoft flow

Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com Power Automate have come a long way indeed. And with all the advancements in Power Automate, tasks which used to take weeks now take few days or even less. But sometimes the simplest of requirement which we take almost as granted come across as a challenge. …

How to query more than 5K CDS records using FetchXml in PowerAutomate/ Microsoft flow Read More »

How to filter view in Power Apps portals/ Dynamics 365 portals with logged in contact

Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com It’s been sometime I wrote a blog on portals and this topic is one of the requirements we come across frequently while implementing a portal solution. While this is a pretty old concept, many who haven’t worked with Dynamics 365 portals and just started working with …

How to filter view in Power Apps portals/ Dynamics 365 portals with logged in contact Read More »

How to resolve – “License cannot be assigned to a user without a usage location specified.” error when assigning license to guest user in Azure.

Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com Happy new year to all my blog readers. This is my first blog of the year 2021 and I can’t be more excited to get on with it. And what’s more exciting that to have the blog on Azure. In this blog I am going to …

How to resolve – “License cannot be assigned to a user without a usage location specified.” error when assigning license to guest user in Azure. Read More »

How to enable or disable “Export to PDF” option for entities in CDS/ Dynamics 365 through code.

It’s been sometime that I wrote a blog and what better time to write than on Christmas eve when holidays are finally here. This blog is going to be slightly different from my usual blogs on PowerAutomate and PowerApps. In this blog I am going to discuss the following. You have ‘Export to PDF’ enabled …

How to enable or disable “Export to PDF” option for entities in CDS/ Dynamics 365 through code. Read More »

{Solved} The data returned by the service is invalid – CountRows() function in PowerApps

Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com This is a really interesting topic I am going to share in this blog. Sometimes the most interesting learning come from areas where you least expect them. I was using the CountRows() function with the Account table of CDS and below is the error I got. …

{Solved} The data returned by the service is invalid – CountRows() function in PowerApps Read More »

How to remove duplicate items from an Array in Power Automate

Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com I am back after sometime with another blog on Power Automate. And this time I am going to focus on a very important functionality – “Remove duplicate items from an Array“. You have to agree with me on this – “Removing duplicate items from an array” …

How to remove duplicate items from an Array in Power Automate Read More »

How to perform Contains() search in PowerApps Canvas Apps

Canvas are a delight to work with, specially with so many in-built functions and operators which makes our life a whole lot easier. However developers and consultants from past programming background are accustomed to some functions which surprisingly may be missing from Canvas apps. And contains() is one such function. What are the common scenarios …

How to perform Contains() search in PowerApps Canvas Apps Read More »

How to save signature from Pen Input control to file data type in CDS

Quite sometime back I wrote a post on how we can save signature from a Pen input control and store it inside multi-line of text field in CDS. Back then it was quite complex but with the introduction of JSON function in canvas apps, things got a whole lot easier. In this blog, I am …

How to save signature from Pen Input control to file data type in CDS Read More »