powerapps

Improving User Experience with Delayed filter or Search in Power Apps

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

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

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

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

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

How to convert a local datetime to UTC in Power Apps

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

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

PowerApps Tutorial: Extracting Dynamic JSON Schema Properties and Values

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

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

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

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

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

Power Apps canvas apps: Adding Calculated and Dynamic Columns

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

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

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

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

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

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

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

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

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

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

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

Using OnError Event in Power Apps: Unhandled Errors Tracing

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

How to fetch data from Smartsheet in Power Apps canvas apps

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

How to show Progress bar control in Power Apps canvas apps

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

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

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

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

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

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

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

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

How to create a People Picker in Power Apps canvas apps

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

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

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

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

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

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

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

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

Get DataVerse record URL in Power Apps canvas apps

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

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

ROUND, ROUNDUP and ROUNDDOWN in Power Automate

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

ROUND, ROUNDUP and ROUNDDOWN in Power Automate Read More »

How to enable logging in Power Apps

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

How to enable logging in Power Apps Read More »

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

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

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

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

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

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

How to merge/ join excel files in Power Automate flow

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

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

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

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

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

How to enable scrolling for Label in Power Apps canvas apps

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

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

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

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

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

How to write Plugins on CreateMultiple and UpdateMultiple messages in DataVerse

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

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

How to use CreateMultiple and UpdateMultiple messages using DataVerse SDK Client

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

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

How to bypass Power Automate flow execution during DataVerse operations

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

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

How to create Sequential approvals in Power Automate

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

How to create Sequential approvals in Power Automate Read More »

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

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

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

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

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

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

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

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

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

3 Challenges of Using Power Apps New Users Face

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

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

How to Copy to clipboard from Power Apps canvas apps

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

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

How to extract numbers from string in Power Automate

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Convert Word document to PDF using Power Automate flows

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Remove controls during print in Power Apps canvas apps.

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

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

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

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

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

Users not able to access model-driven app.

Hello everyone and welcome to my blog. I am back with another blog on Power App and today it’s about model-driven app and security role. When you develop a model-driven app and publish it, users sometime report they are not able to access the model-driven app. In this blog I will discuss on the troubleshooting …

Users not able to access model-driven app. Read More »

Fluent UI design, the new look and feel of model-driven apps

Hello everyone and welcome to my blog. In today’s blog I will discuss on a really cool feature that is in preview and certainly going to be liked by users a lot. If you are wondering what I am talking about, it’s the new Fluent UI design of Model-driven apps. Model-driven apps are great with …

Fluent UI design, the new look and feel of model-driven apps Read More »

How to read emails from shared mailbox in Exchange in PowerApps Canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss on how to retrieve emails from shared mailbox in Exchange in canvas apps. Power Platform has inbuilt connector for Office 365 Outlook that can be used to in Canvas apps and Power Automate to perform operations with Outlook. For this demo, I …

How to read emails from shared mailbox in Exchange in PowerApps Canvas apps Read More »

How to create a Power Apps trial with onmicrosoft.com account

Hello everyone and welcome to my blog. In this blog I will show how you can create a trial onmicrosoft.com account and subscribe to Power Apps. I am recently into lot of Power Apps training sessions and the frequent question I get from the participants is – How do I subscribe for trial Power Apps …

How to create a Power Apps trial with onmicrosoft.com account Read More »

Struggling with expressions in Power Automate? Use this new feature to get formula suggestions in Power Automate

Hello everyone and welcome to my blog. In today’s blog I am going to discuss about a new feature that will help you to create expressions based on your desired output. Power Platform is low code – no code, a platform for citizen developers. Make no mistake about it. But at the same time, let’s …

Struggling with expressions in Power Automate? Use this new feature to get formula suggestions in Power Automate Read More »

How to configure Relative time filter in Power BI

Wishing all my readers a very happy and prosperous new year. This is my first blog for this year and in this blog I will show how you can configure relative date/ time filters in Power BI report. Did you ever had the requirement to configure the following filters based on date column. If this …

How to configure Relative time filter in Power BI Read More »

How to prevent sharing of apps in Power Platform environment

Hello everyone and welcome to my blog. In today’s blog I will show you how you can disable sharing of apps in your Power Platform environment. The problem of sharing apps is more prominent with Default environments. As makers continue to build apps in the default environment and start sharing the apps, it soon becomes …

How to prevent sharing of apps in Power Platform environment Read More »

How to filter a table on click of Card in Power BI

Hello everyone and welcome to my blog. In today’s blog I will discuss the issue with Card visualizations in Power BI. Card visualizations are great. They allow you to highlight the single most important pieces of information in a report and it look’s great too. However there is a small issue with the cards. As …

How to filter a table on click of Card in Power BI Read More »

How to retrieve content of Image column in DataVerse and send it as an email attachment

Hello everyone and welcome to my blog. In today’s blog I will discuss on how we can retrieve the contents of DataVerse image column and send it as an attachment in an email. We are going to use Power Automate for this. Power Automate DataVerse connector has actions to upload and download image and file …

How to retrieve content of Image column in DataVerse and send it as an email attachment 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 »

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 »