powerapps

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 »

How to add a custom trigger phase in Greeting topic in Power Virtual agents Chatbot

I have been working a lot on Power Apps and Power Automate since few years now. And never really got a chance to work with Power Virtual agents in a real time project. And finally got a chance. And with that came the opportunity to write this blog. If you have worked on Power Virtual …

How to add a custom trigger phase in Greeting topic in Power Virtual agents Chatbot Read More »

How to compare with @ character on a condition action in Power Automate

This is one of the easiest blogs I may have written on Power Automate. And honestly I thought twice before even posting this blog. But then I verified this with couple of citizen developers in the project and both of them struggled doing this for sometime before eventually doing it successfully. While this is walk …

How to compare with @ character on a condition action in Power Automate Read More »

How to extract an excel file like an archive in One Drive folder using Power Automate

With Office 2003, Microsoft have changed the way an excel is formatted. From excel 2003, excel files are essentially zip files. If you change the excel file extension to .zip you should be able to extract the contents of the excel file into a folder. What if you need to automate this process in your …

How to extract an excel file like an archive in One Drive folder using Power Automate Read More »

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