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 »
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 »
Hello everyone and welcome to my blog. In today’s blog I will discuss on how to perform substring operations in Canvas apps. Unlike other platforms, Power Apps does not have the substring function. However very similar to the substring, there is a Mid function which can be used to achieve similar results. Let’s get started. …
Hello everyone and welcome to my blog. In today’s blog, I will show how you can get the last day of current month using the new EOMonth function introduced in Power Apps. Sometime back, I wrote a blog on how to get the first and last day of a month in Power Apps. While it …
How to get last day of a month in Power Apps using EOMonth Read More »
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 …
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 »
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 …
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
Hello everyone and welcome to my blog. In today’s blog we will discuss how to get the TenantId inside your Power App Canvas app. Let’s get started. Quite unknown to many, every canvas app has a Host object. The Host object is right there under the App object but many a times it goes unnoticed. …
How to get the Tenant Id in Power Apps canvas apps Read More »
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 »
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 »
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 …
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 »
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 »
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 »
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 »
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 »
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 …
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 …
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 …
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 »
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 »
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 »
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 »
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 …
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 »
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 »
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 »
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 »
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 »
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 …
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 »
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 …
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 »
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 »
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 »
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 …
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 »
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 …
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 …
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 …
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 »
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 »
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 »
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 …
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 »
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 »
Hello everyone and welcome to my blog. Today’s blog will be on how to filter an array in Power Automate flow. In this blog, we shall cover different scenarios for filter. Power Automate has native support for filtering arrays. You can use the Filter array action of the Data Operation control to filter any type …
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 …
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 …
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 »
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 »
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 »
Hello everyone and welcome to my blog. In today’s blog I will show how you can display a hyperlink column as image/ icon in Power report table. Let’s get started. Below is a table in Power BI report where I am displaying couple of columns. One is Machine Name and the other Photo. As you …
How to display a URL as Image in Power BI report table Read More »
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 …
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 »
Hello everyone and welcome to my blog. In today’s blog I will show how you can embed a Power BI report in SharePoint. Many a times we have a requirement to embed a Power BI report on SharePoint page. For this we choose the Power BI webpart available in SharePoint. In the Power BI webpart, …
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 »
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 »
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 »
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 »
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 »
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 …
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 »
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 »
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 …
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 »
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 »
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 »
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 …
Hello everyone and welcome to my blog. In today’s blog I will discuss about on how to create hyperlinks with dynamic URL while sending an email in Power Automate. Let’s first understand the problem statement. Below is an instant flow I created for this demo. I have created a variable varHyperLink with has the value …
How to create hyperlink with dynamic URL in Power Automate emails. Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss a peculiar behavior with the CountRows function. Below is an example where I am using the CountRows function to show the total number of customers. Quite strangely, the function returns zero as you can see from the below screenshot. This is quite …
CountRows function returning zero for DataVerse tables – Power Apps Canvas apps Read More »
Hello everyone and welcome to my blog. In today’s blog we will discuss on how to calculate the difference between two dates in Power Automate. Sometime back I have written a blog which show how to substract two date time objects and then calculate the difference. Infact most of the blogs available on this topic …
How to Calculate difference between two dates in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog I show a simple technique on how to reverse a string in Power Automate. I have the following string – “1234567890“. I want to reverse the string in Power Automate. If you are looking to do the same thing in Power Apps, you can check …
Hello everyone and welcome to my blog. In today’s blog I will discuss show how you can create an array from string in Power Automate. Suppose I have the string Microsoft. I want to create an array out of the string, basically to return an array – [“M”, “i”, “c”, “r”, “o”, “s”, “o”, “f”, …
How to create an array of characters from a string in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss on a rather peculiar issue faced when you try to export a Power Automate flow. Traditionally whenever I would want to export a Power Automate flow, I shall select the flow and then choose the Package (.zip) option. However lately I observed …
{Solved} Unable to export Power Automate Flow as package (.zip) Read More »
Hello everyone and welcome to my blog. In today’s blog, I will show you on how to get the timezone details of a user from DataVerse in a Power Automate flow. Before we get started with the Power Automate flow, it’s important to understand the tables in DataVerse which we will use in the Power …
How to retrieve a user’s timezone from DataVerse in a Power Automate flow Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss on how to display a lookup column of DataVerse as a Dropdown in Power Apps canvas apps. Account has a contact lookup field – Primary Contact. The field is usually required to store the primary contact for a customer. For our demo, …
How to display DataVerse Lookup as Dropdown in canvas apps Read More »
Hello everyone and welcome to my blog. In today’s blog I will show you on how to reverse an array/ collection in canvas apps. Let’s get started. I have collection of fruits which I will reverse Most of the programming languages have in-built function to reverse an array. Unfortunately, Power Apps does not have an …
How to reverse an Array/ collection in Power Apps Canvas apps Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss on how find index of specific phrase inside a string in canvas apps. Canvas apps have the Index function which is frequently confused to work with strings. The Index function is used to find a specific item by index position from a …
How to find Index of string in Power Apps canvas apps Read More »
Hello everyone and welcome to my blog. In today’s blog I will show how to configure Password Reset policy with Azure AD B2C authentication in Power Apps portals/ power pages. 4 years back, I wrote a post how to configure Azure AD B2C authentication with portals. All the configurations described in the post still hold …
Hello everyone and welcome to my blog. In today’s blog I will discuss a very simple but useful feature which has been released lately. When we browse records in our Model Driven apps or Dynamics 365 Apps, we frequently need to share the URL of the record to access it directly. As easy as it …
Share link of a record in Model Driven apps/ Dynamics 365 Apps Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss on how to show related records in a subgrid in Power Apps canvas apps. For this demo, I will take the example of Accounts and Contacts table of DataVerse. Accounts and Contacts are in 1:N relationship where an account can have multiple …
Show related records in a subgrid – Power Apps Canvas Apps Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss how to replace all instances of word inside a string. I will demonstrate for both case sensitive and case insensitive scenarios. Power Apps has the Substitute function to replace all instances of word inside a text. For this blog, I will use …
Replace all instances of text , case insensitive, in Power Apps canvas apps Read More »
Hello everyone and welcome to my blog. I am back with another blog on canvas apps and today I will discuss on how to get the current environment name in Power Apps canvas apps. While we will focus on Canvas apps, the article shall help you explore the below scenarios as well. As of the …
How to Get Environment name in Power Apps canvas apps Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss about a very simple requirement on how to extract email address from string in Power Automate. Requirements like this usually are solved using regular expressions. Canvas apps have support for regular expressions. There are couple of functions in Power Apps like Match …
How to extract email address form string in Power Apps canvas apps Read More »