Canvas apps

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 »

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 »

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

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

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 »

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 »

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

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

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

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

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 »

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

{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 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 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 import data from an excel file into an existing SharePoint list

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

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

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

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

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

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

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

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

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 »

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 check user permission/ privilege on a record/ table in Power Apps Canvas app

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

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

How to write nested For loop in Power Apps Canvas apps

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

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

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

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

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

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

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

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

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

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

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

How to search users from Office365 in Power Apps Canvas app

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

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

How to add time to datepicker control in Canvas apps

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

How do you Print in PowerApps Canvas apps?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

How to perform Contains() search in PowerApps Canvas Apps

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

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

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

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

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

How to set a variable inside ForAll in PowerApps Canvas apps

Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com This blog is again quite simple one and yet quite interesting. In this blog I will discuss about how we can set a variable inside For loop in canvas app. You might be wondering – “Isn’t UpdateContext and Set function already there in PowerApps to …

How to set a variable inside ForAll in PowerApps Canvas apps Read More »