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 …
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 »
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 »
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 »
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 »
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 …
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 »
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 »
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 »
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 »
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 »
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 …
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 …
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 …
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 »
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 »
In today’s blog we are going to discuss on how to generate QR code in Canvas apps. QR Code is now synonymous to our everyday living. Whether we attend an event or generate or book a doctor’s appointment or redeem a coupon, we need to scan our QR code. With canvas apps gathering more eyeballs …
How to Generate QR Code in Power Apps Canvas apps? Read More »
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 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 »
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 »
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 »
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 …
Before I go ahead and explain, let me accept this. I was not aware of the newly introduced client APIs in Model driven apps. And this one was pure serendipity. You might be thinking – Isn’t there formContext.data.save().then(successCallback, errorCallback) function which allow us to do that? Yes it does. But I am not talking about …
How to handle save complete event in client side in Dynamics 365/ Model driven apps Read More »
Power Platform is for citizen developers. For Power Users who are masters of their business process but lacks the technical background to build an application out of that knowledge, Power platform have provided a level playing field. Last few posts, I wrote based requests of enthusiastic citizen developers. This is one more query I received …
How to check if today is starting day of month using Power Automate? Read More »
Power Automate have simplified our tasks to a great extent. Requirements which would take few months previously are now accomplished in few weeks and weeks development may be in days. And here is one such requirement I will discuss. The requirement is very simple. Convert HTML document to PDF. Basically if you have the following …
How to convert HTML file to PDF using Power Automate Read More »
It’s been sometime I have written blog on PCF control. While my first blog still date back to one of the earliest detailed step by step blog on PCF and probably written couple of days after PCF preview release, unfortunately I could not write up much on PCF from that point. However I find so …
Error: Required argument –publisher-name/ –publisher-prefix is missing Read More »
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 »
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 »
I am back with another blog on Power Automate. There is so much Power Automate can offer that you hardly run out of topics to share it through blogs. And one such topic is the ability to dynamically add/ remove properties from a JSON object. In this blog I am going to discuss the below …
How to Add/ Remove property from a JSON object dynamically using Power Automate Read More »
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 »
Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com Happy new year to all my blog readers. This is my first blog of the year 2021 and I can’t be more excited to get on with it. And what’s more exciting that to have the blog on Azure. In this blog I am going to …
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 »
Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com I am back after sometime with another blog on Power Automate. And this time I am going to focus on a very important functionality – “Remove duplicate items from an Array“. You have to agree with me on this – “Removing duplicate items from an array” …
How to remove duplicate items from an Array in Power Automate Read More »
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 »
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 »
Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com This is fairly simple one especially after my last blog. But I bet this may be more required than what I wrote for my previous blog. In this blog I am going to discuss the following How to remove HTML tags from a string in …
How to remove HTML and XML from a string in PowerApps Canvas apps Read More »
Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com This one is a really cool requirement I came across today. I had this requirement, I implemented it and I can’t wait to share it with my readers. So what am I going to cover here? In this blog I am going to cover the …
How to download Notes from Power Apps Canvas Apps? Read More »
Do you know the following? Trim() function in canvas apps not only removes text from the end but also from within the text? There is a separate function TrimEnds() and how does it differ from Trim()? How do you trim spaces from the items inside a collection? If you are aware of all the three …
How to trim spaces from the end and within a text in PowerApps Canvas app Read More »
This one is pretty interesting and also the one which took me by surprise. The requirement was very simple – I have a canvas app screen from where I needed to update back CDS account record. Apart from few other fields, I also needed to clear the Primary contact field on Account which is basically …
How to clear Lookup fields of CDS from Canvas app. Read More »
Do you have the following requirements? You want create a HTML table in Power Automate from JSON data You want to send an email with HTML table in the body of the email using Power Automate If you have these requirements and you are wondering on how to accomplish the same, you are on the …
How to send an email with HTML table in Power Automate Read More »
Do you have the following requirements for your canvas apps? You are using the form control in your canvas app and you want to make a field mandatory/ non-mandatory depending on business logic You are not using a form. However you have some input controls which should be made required depending on business logic. If …
How to make a field required dynamically in PowerApps canvas app Read More »
Do you have the following requirements? You want to pass an array from a Canvas App to a Power Automate You want to pass an array from Model Driven apps to Power Automate. You have to parse JSON data in your canvas app and perform further processing. If your requirement is similar to this, this …
How to pass an array from PowerApps to Power Automate Read More »
“Who can create environment(s) in Power Platform admin center?” “How can I restrict environment creation in Power platform admin center only to admins? These are the questions that keep popping up in almost every other PowerApps training I conduct. While Power platform is pretty familiar, this is a topic which is still a grey area …
Who can create environments in Power Platform admin center? Read More »
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com I am back with another blog and this time it’s a blog on canvas apps. And quite an interesting requirement as well. It’s about creating accounts in bulk from a Canvas app. So …
I am back with another blog topic and this time it is about business rules in canvas apps. If you have been working on Dynamics 365 / CDS, you must be aware of business rules. In case you are no aware of business rules, I strongly recommend to go through the Microsoft documentation before proceeding. …
This article focus on the recent changes in SLA Changes in Dynamics 365 including the much awaited feature to configure more than one SLA for an entity and a host of other new enhancements by Microsoft. Very informative post by Prashant Kumar Mayura Check out my recent posts: Hope this helps! Debajit Dutta(Business Solutions MVP)
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com This one will be real quick. A small and effective one I should say. But before we go into the solution, let’s understand the problem statement here. My customer have a canvas app …
Set Date Picker in Canvas App to today's date by default Read More »
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com With every new release of Canvas apps, Microsoft add new features to it’s kitty. Today I will explain one of these features. And that is the ability to associate records in Canvas apps. …
Associate and Disassociate records in Power Apps Canvas Apps Read More »
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com In this blog, I am going to walk you on how to manage version in Canvas app. Also I am going to discuss on how we can restore a canvas app to it’s …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com The introduction of Canvas Apps have completely changed the way of developing apps. App development was always a developer’s paradise. With canvas apps, it’s a level playing field for developer and Power Users …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com Working with date and time values are one of the most common requirements across implementations irrespective of the technology and the same applies to PowerApps canvas apps. And Canvas app have power functions …
Get Today’s date, format dates in Power Apps Canvas app Read More »
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com Every now and then when you design a Canvas App, you may be required to accomplish the following requirements. Pass data from one screen to another while navigating to the new screen. Identity …
Use Navigate() function to pass data between two screens in PowerApps Canvas apps Read More »
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.comThis one is a really simple trick which is required in so many. How can I specify multiple JSONFormat values inside JSON() function in canvas app? Before I go ahead and provide an answer …
Specify more than one JSONFormat value inside JSON function in canvas app Read More »
Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com Canvas apps have really taken the art of developing pretty neat apps for mobile platforms from a niche set of developers to a wide platform of developers, consultants and business users. And with Microsoft adding features to the Power platform framework every now and then, I …
How to get CDS Optionset value in PowerApps Canvas apps Read More »
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com Data Integration in Power Platform Admin centre – One of the few and detailed post on this topic. Wonderful read.
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com First of all, if your server side synchronization is not working for Production environment, then this blog may not help you. This only applies if your environment is in SandBox mode. Now when …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com The simplest of things are sometimes the sweetest. And here is this one requirement to parse an XML using Power Automate/ Microsoft Flow. With SOAP giving away to REST based API’s, XML parsing …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com Few months back I wrote an article on File Data type in Dynamics 365/ CDS where I explained the details of this data type and explained how you download the content of the …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com If you are directly on this blog post, I suggest you start from the first blog post of this series to get the context. So I am on the final blog of this …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com Few months back I posted an article on how you can develop a custom button for Save as draft functionality on an Entity form in PowerApps portals. On that post I have received …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com If you are directly on this blog, I suggest you go through the first blog of this series. In our previous blog, we created the SharePoint Add-in. In this blog we shall be …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com Before I go ahead, while this blog depicts on how you can generate the Authentication token to integrate between Dynamics 365 and SharePoint, this can be applied to any application trying to authenticate …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com Entity permissions are a great way to control record access in your Dynamics 365 Portals. You can have fine grained control at individual record level. But ever wondered if you can determine the …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com “Restrict Read” – A privilege which is perhaps most misunderstood. And every session I go when I start explaining the concept of Restrict Read, participants are like – Come on! This is not …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com Recently we had an issue with one of our Customer portals. Everything was working fine in DEV and UAT environments. However after portal deployment in production environment, customers reported they are unable to …
Follow my blog for interesting topics on Dynamics 365, Portals and Power Platform. The world is into mobile devices and Dynamics 365 is not left far behind. With unified interface, user’s are now getting seamless experience across all devices starting from web browser in desktop clients, to phones and tablets. Dynamics 365 is well and …
How to get device location in Dynamics 365 for Mobile Read More »
For training and consulting, write to us at info@xrmforyou.com Recently I published a blog on the new preview feature for PowerApps portals where it allows you to change the portal theme from PowerApps portal editor. Check this here. While I received quite a few queries on the same, one of the interesting questions I got …
For training and consulting, write to us at info@xrmforyou.com If you have used alternate keys in Dynamics 365 and tried to update using a record using WebAPI alternate key, you know the default behavior of how it works.For example, let’s see the sample code below. // JavaScript source code function UpdateRecord(e) { var fc = …
For training and consulting, write to us at info@xrmforyou.com Recently I have been conducting a lot of training on PowerApps Portals. And every time when I start teaching WebForms, I get this question – What is the significance of Developer extensions in WebForm step. If you are not able to relate, this is what I am …
For training and consulting, write to us at info@xrmforyou.com Liquid and PowerApps portals. I think a match made in heavens. And what can I say about Liquid, a simple yet so powerful template editing language. And while I was singing praises for Liquid, a colleague came up to me and told that liquid does not have …
Convert byte array to base64 string using Liquid in Dynamics 365/ PowerApps portals Read More »
For training and consulting, write to us at info@xrmforyou.com If you are looking for a new feature that has been introduced, unfortunately it’s not. Come one Debajit! Don’t be so disappointing at the start of the blog!But truth needs to be told! So what are my other options?Field security profiles are not available in Power …
For training and consulting, write to us at info@xrmforyou.com With every release of PowerApps and PowerApps portals, Microsoft is making the life of customizers easy. And when I saw this feature this was my reaction – “WOW“ Very simple yet so beneficial and time saving. Traditionally customers always had a ask to change the theme …
For training and consulting, write to us at info@xrmforyou.com Follow my blog for more interesting topics on Dynamics 365 and Portals As I have been working on liquids a lot lately, I am amazed by the simple and yet powerful language which allows me to do so much without drop of a sweat. And then …
Base64 encoding and Base64 decode using Liquid in Dynamics 365/ PowerApps portals Read More »
For training, consulting and our products, please write to us at – info@xrmforyou.com I got this query from one of my blog readers and hence thought of sharing it with everyone. They were trying to display a knowledge article in portals. They were following the Microsoft guidance – “You can author knowledge articles and add …
{Quick Tip} Display knowledge article as attachment in Dynamics 365/ PowerApps portals Read More »
For training, consulting and our products, please write to us at – info@xrmforyou.com Recently I faced this scenario where I needed to determine based on whether I am on-premise or online, I needed to write my logic accordingly. We have our popular Sharepoint Utility which is used by a lot of customers and we had …
You may be wondering why this simple post? After all, setting a date value, what’s in that? Sometimes the simplest of things takes us by surprise. Below is a screenshot of an entity form with date field. Based on custom business logic on the client side, we have to set the value of the date …
Well, there can be so many reasons why Azure Storage integration with Dynamics 365 Portals/ PowerApps portals is not working. However more often than not, the most common error I see is “access is denied” message in the portal logs. And you scramble to your portal configurations and verify the connection string to your azure …
In this blog, I will set-up Google authentication using the new PowerApps/ Dynamics 365 Portal identity provider configuration UI. If you are not aware of the preview feature, please visit the previous blog to know more about this new preview feature. In the identity provider screen, we configure the Google provider. Once we click on …
I had this requirement lately and the first time I heard this I thought, is this even possible? But then I never doubt about the every increasing capability of canvas apps. So decided to do a search. And guess what! Found this wonderful documentation here with a complete solution. https://powerapps.microsoft.com/en-us/blog/using-business-process-flows-in-a-canvas-app/ I am simply falling in …
Designing Business process flows for your canvas apps Read More »
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com The article is a part of series of blog posts on Custom component framework topic. In order to get the context I would suggest to get started from beginning. Let’s not get to the …
Part 1: Understanding PowerApps Component Framework (PCF) and control lifecycle Read More »
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com In my recently conducted training on Dynamics 365, I dealt a lot with the Power Platform admin center and could find that while there is great awareness of the CDS and how does …
Data policies (DLP) in Power platform admin center Read More »
Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com This content has been update with the introduction of new capabilities in Canvas Apps. Please follow this link for updated content. Debajit DuttaBusiness Solutions MVP
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.comAs promised, I am back to my second post on this topic. In my previous post, I showed you on how to generate Authorization token of D365 online from Native Console App using the …
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com As I have been working mostly on Dynamics 365 portals, here goes another D365 portal post. So here is the requirement. The portal customer applies for loan and then views the status of …
toggle entity forms in Dynamics 365 portals / powerapps portals using liquid Read More »
Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com First of all, I can thank more to the Linked In community for the overwhelming response on our SharePoint Attachment Extractor and metadata manager tool. Your feedbacks, your comments and your patronage keeps …