powerapps

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

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

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

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

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

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

How to Calculate difference between two dates in Power Automate

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

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

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

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

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

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

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

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

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

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

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

How to display DataVerse Lookup as Dropdown in canvas apps

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

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

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

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

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

How to find Index of string in Power Apps canvas apps

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

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

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

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

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

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

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

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

Show related records in a subgrid – Power Apps Canvas Apps

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

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

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

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

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

How to Get Environment name in Power Apps canvas apps

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Auto height of text input control in Power Apps Canvas apps

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

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

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

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

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

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

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

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

How to create a modal dialog in Power Apps Canvas apps

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

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

New expression editor in Power Automate

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

New expression editor in Power Automate Read More »

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Enable spell check for text input controls in Power Apps

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

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

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

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

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

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

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

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

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

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

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

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

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

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

How to embed an image in an email in Power Automate

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

How to send notifications across apps in Power Apps Canvas apps

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

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

Generate Random numbers within a range in Power Apps Canvas apps

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

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

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

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

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

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

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

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

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

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

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

Concatenate string expressions in PowerApps Canvas apps using $ operator

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

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

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

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

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

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

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

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

Power Automate flows not getting triggered for environment.

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

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

How to use hexadecimal color values in Power Apps canvas apps

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

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

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

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

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

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

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

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

Horizontal Text alignment of Toggle control in Power Apps canvas apps

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Resubmit multiple failed runs in Power Automate

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

Resubmit multiple failed runs in Power Automate Read More »

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 »

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 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 »