Hello everyone and welcome to my blog. In today’s blog I will discuss an interesting topic. And that is the ability to customize the Power automate flow panel when you execute a Power automate flow from a SharePoint list item record. In my previous blog I have explained how to create a button column in …
How to change ‘Run Flow’ button text when executing a flow from a SharePoint List item Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss on how you can frame DataVerse record URL links in your canvas apps. This blog target the following requirements. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client …
Get DataVerse record URL in Power Apps canvas apps Read More »
Hello everyone and welcome to my blog. In my blog today, I am going to discuss on how to round off numbers in Power Automate flows. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog …
Hello everyone and welcome to my blog. In today’s blog my intention is to go deep and explore the reason why certain power automate flows configured with DataVerse triggers stop executing. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting …
Welcome everyone to my blog. In today’s blog, I will discuss how you perform join on excel files using Power Automate flow. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog to stay updated. Let’s …
How to merge/ join excel files in Power Automate flow Read More »
Hello everyone and welcome to my blog. In today’s blog I will show how you can fetch more than 256 rows in from excel file in Power Automate. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to …
{Solved} How to fetch more than 256 rows from Excel in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog I will show how you can get SharePoint document Library Id by Library name, in a Power Automate flow. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe …
How to get SharePoint document library id by library name in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog, I will discuss on how you can check if an object property is null or missing in a Power Automate flow. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting …
How to check for null or missing object property in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog, we shall learn about the comparison operators in Power Automate and how to use them in expressions. We will discuss on the following comparison operators. I keep frequently getting requests from a lot of users starting with Power Automate to write content for beginners. I …
All about how to use comparison operators in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog, I will discuss a very simple requirement to check if a variable is an integer or float or decimal. 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 …
How to check if a variable is integer or float or decimal in Power Automate Read More »
Hello everyone and welcome to my blog. Today’s blog is how to convert a word document to PDF using Power Automate flow. Without further ado, let’s get started. I have word document uploaded in my SharePoint drive which I shall convert to PDF using Power Automate flow. For this blog, I have created a flow …
Convert Word document to PDF using Power Automate flows Read More »
Hello everyone and welcome to my blog. Today’s blog shall focus on the following requirements. This blog will demonstrate how you can achieve above requirement. For this blog, I will use a Flow with Manual trigger. I have a variable varRequest. It’s a JSON array. The first object has three properties – FirstName, LastName and …
Replace missing properties in object or null value in Power Automate flow. Read More »
Hello everyone and welcome to my blog. In today’s blog I shall discuss on how you can cancel pending approvals in Power Automate flow. If you have been working on Power Automate for sometime now, you must have used the Approvals in Power Automate flow. However when using approvals, lot of time you will end …
How to cancel all pending approvals in Power Automate flow Read More »
Hello everyone and welcome to my blog. In today’s blog I will show how you can set expiry time for your approval flows in Power Automate. If you have worked with Power Automate, you have most likely used Approval flows. What if there is a requirement to set a time limit or expiry period for …
How to set expiry/ timeout for Approval flows in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss an interesting way to cancel all running instances of a Power Automate flow in Bulk using Power Shell. So let’s get started. Here is my Power Automate flow which currently have few running instances. My intention is to cancel all the running …
How to cancel all running instances of Power Automate flow using PowerShell Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss about on how to create hyperlinks with dynamic URL while sending an email in Power Automate. Let’s first understand the problem statement. Below is an instant flow I created for this demo. I have created a variable varHyperLink with has the value …
How to create hyperlink with dynamic URL in Power Automate emails. Read More »
Hello everyone and welcome to my blog. In today’s blog we will discuss on how to calculate the difference between two dates in Power Automate. Sometime back I have written a blog which show how to substract two date time objects and then calculate the difference. Infact most of the blogs available on this topic …
How to Calculate difference between two dates in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog I show a simple technique on how to reverse a string in Power Automate. I have the following string – “1234567890“. I want to reverse the string in Power Automate. If you are looking to do the same thing in Power Apps, you can check …
Hello everyone and welcome to my blog. In today’s blog I will discuss show how you can create an array from string in Power Automate. Suppose I have the string Microsoft. I want to create an array out of the string, basically to return an array – [“M”, “i”, “c”, “r”, “o”, “s”, “o”, “f”, …
How to create an array of characters from a string in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss on a rather peculiar issue faced when you try to export a Power Automate flow. Traditionally whenever I would want to export a Power Automate flow, I shall select the flow and then choose the Package (.zip) option. However lately I observed …
{Solved} Unable to export Power Automate Flow as package (.zip) Read More »
Hello everyone and welcome to my blog. I am back with another blog on canvas apps and today I will discuss on how to get the current environment name in Power Apps canvas apps. While we will focus on Canvas apps, the article shall help you explore the below scenarios as well. As of the …
How to Get Environment name in Power Apps canvas apps Read More »
Hello everyone and welcome to my blog. 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 …
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 …
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 »
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 …
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 »
Welcome back to all my blog readers. In today’s blog I am going to share with you my recent experience while working with Power Automate flows. I have a model driven app which has a list of contacts for each account. I need a Power Automate flow which should run when a contact record is …
When a record is selected – Dataverse trigger flow not showing Read More »
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 »
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 »
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 …
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 »
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 …
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 »
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 »
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 …
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 »
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 …
The General availability of this feature is April 2022 and this is gradually rolled out across regions. If you don’t see this in your environment then the feature rollout may be pending in your region. So what is this feature I am referring here. It’s a very simple one and is the capability to undo …
If you have worked with DataVerse and Power Automate, chances are likely that you have created a record in DataVerse using Power Automate. And when you create a record, there are times when you need to need to set a lookup field on the record. This post is specially relevant if you are trying to …
How to get entitysetname while setting lookup value in Power Automate Read More »
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 …
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 …
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 »
It’s been sometime I wrote a blog on Power Automate. And today’s blog is very simple. And trust me, this requirement is one of the most common requirements. Convert an input into currency format, for example you want to convert 1234.567 to $1234.567 or for that matter any other currency is one of the most …
How to convert a string to currency format in Power Automate 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 »
This topic is pretty interesting. If you look at the requirement here, it can’t be simpler than this. I need to remove duplicate items from a table/ collection. Or even more generic requirement to remove duplicate items from a gallery. If you are coming from programming background or database SQL experience, it’s another day at …
How to remove duplicate items from a collection in Power Apps Read More »
Substracting dates – Can it be any simpler than this? Well quite not when it comes to Power Automate. Whenever we need to substract dates, we usually think of the functions – diffInDays, diffInMonths etc. While the method described here works too, there is a better way to achieve this. You can check it out …
How to substract two datetime objects in Power Automate Read More »
Loops – it existed since the inception of programming and it’s there in all languages and platforms. And why then Power Automate shall be an exception? Power Automate too has the ‘Apply to Each‘ which basically works like forEach and ‘Do Until‘ which is basically the traditional do-while. And with that a requirement come often. …
How to get index number in Do Until and Apply to each in Power Automate Read More »
So here I am back with another blog on Power Automate and again one simple but widely used functionality. How do you convert XML string in JSON object? If you are thinking I am going to show you something really hard here, you are in for a surprise. There is an OOB function available in …
How to convert XML string to JSON object in Power Automate Read More »
This one is going to be really short and sweet. I was conducting a training in Power Automate and was demoing to the participants on how to use expressions in Power Automate. Majority of the participants were able to follow the labs and add the expressions. However some of the participants reported that they are …
Add Dynamic content/ expression editor not showing in Power Automate flow designer Read More »
This is another requirement which is quite common but may be difficult for citizen developer. After I wrote the blog post on how to find unique elements in an array, I received a query on how to perform the following operations. Intersection of two arrays Union of two arrays. Compare array objects based on array …
I am back with another blog on Power Automate. And again a blog on request of one of citizen developer. The requirement here is very simple. In a flow, we need to determine if a particular user is Out of Office. Depending on whether user is OOF, we would take decision to send the email …
How to check if an employee is Out of Office using Power Automate Read More »
In my previous article, I showed you how to check if today is the start date of the month in Power Automate. Subsequently I received quite a few queries on how to get the last day of a month using Power Automate. When I first saw the question, I was kind of perplexed. I was …
How to Get Last day of current month in Power Automate 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 »
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 »
Power Automate has changed the way we looked at automations and integrations. Things which used to take weeks if not months can now be achieved using in days/ hours. This is because of the huge number of functions available in Power Automate. To be honest, exploring all these at one go is kind of improbable …
Power Automate is flexible, powerful and not to forget, the future of Power Platform operations. And if you are working on DataVerse or the erstwhile Common Data Service, it is quite improbable that you haven’t worked with the CDS connector in Power Automate. Yet sometimes it is surprising to see some basic stuffs which could …
How to Query Metadata in DataVerse/ Common Data Service using 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 »
Sometimes the simplest of the requirements surprise you and here is one of them. With Power automate becoming stronger with every release, it is unfathomable that these issues still exist in Power platform. So what’s the requirement here? It can be as simple as you can imagine of. I needed to perform some aggregate operation …
Follow Debajit’s Power Apps & Dynamics 365 Blog on WordPress.com Power Automate have come a long way indeed. And with all the advancements in Power Automate, tasks which used to take weeks now take few days or even less. But sometimes the simplest of requirement which we take almost as granted come across as a challenge. …
How to query more than 5K CDS records using FetchXml in PowerAutomate/ Microsoft flow 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 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 »
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 »
This is one of easiest and simplest blogs that I am writing but yet quite useful. In this blog I am going to discuss the following topics How to compare using the if expression in Power Automate? How to compare with null using if expression in Power Automate? Frankly speaking it’s quite easy. But for …
This is one of the most common requirement in flow/ Power Automate. And apparently it’s quite an easy one and straightforward as well. However more often than not, even after configuration it does not work correctly. I have written a blog sometime back on the same topic describing on how we can implement timeout conditions …
How to delay a Power Automate flow execution till a specified date and time Read More »
So I am here again, back with another blog on Power Automate and this time with a requirement which is quite common . And why not? After all with Power Automate, connecting multiple line of business systems have become really easy. So what I am going to discuss here? Precisely this blog will touch on …
This one is pretty simple blog but pretty useful. And a requirement which is common across implementations. So I decided to share with my blog readers. In this blog I am going to discuss about the following requirements. How can you compare dates only with date value in Power Automate? How can you ignore time …
How to ignore time while comparing with current date in Power Automate Read More »
Whenever we write any programs in any language, we frequently end up with string manipulation. And whenever there is string manipulation, you will bump into a requirement where you need to trim characters from the beginning and end of a string. Every language is equipped with powerful API’s to tackle these scenarios. Power Automate is …
How to remove trailing spaces and extra spaces in a string in Power Automate Read More »
The advent of Power Automate or the erstwhile Microsoft flow have completely changed the way customers and consultants approach a requirement. Prior to Power Automate, integrating across systems even if they are from Microsoft stack, would pose a challenge and customers would rethink considering the budget and implementation time. But now things have become really …
How to save attachments from an email in Outlook to SharePoint Read More »
Lately I have been working a lot with Power Automate. If you are Power platform consultant who work a lot on Dynamics 365 products and CDS, chances are you are spending an ample amount of time in automating your business solutions using Power Automate. And while PowerAutomate is going stronger by the day, there are …
How to get Year, Month and day in various formats from a date in Power Automate 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 any of the following requirements? You wish to send an email to external users in Power Automate with Approve/ Reject option. You want to make sure that external users do not need a Power Automate license to approve/ reject. You tenant policies does not allow Guest user set-up. If you are having …
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 was pretty surprising and today I faced this error while trying to implement the most mundane operation with Power Automate. On create of an Account, depending on the Account Category, I need …
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 Hi All, I am back with one more tip from Power Automate. In this blog I am going to show you on how to get current date in your Power Automate flows.And with …
Get Today’s date in Power Automate/ Microsoft Flow 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.comLately I have been working on Power Automate a lot. And if you have worked on Power Automate more often than not, you must have used the Compose Action.And one of the compose Action …
Concatenate properties of a JSON array in Power Automate/ Microsoft Flow 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 Power Automate Compose function is indeed quite powerful and if you have designed a complex flow, chances are you have used it in one of the flow steps.However there are so many hidden …
Convert an Array to string in Power Automate/ Microsoft Flow 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 was recently conducting a training on Power Automate and there in came this question. How do I convert a byte array to base64 string in PowerApps.After all there is a function in …
Binary to Base64 in Microsoft Power Automate/ Microsoft Flow 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.comWay back when Power Automate was introduced, there was no way to export Flow run history. As surprising it may sound today, there was no way to export the flow run history when flow …
Export Power Automate/ Microsoft flow run history 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“Starting from templates is a great way to start learning flows” – This is one of the recommendations I learned during my preparation for Microsoft Certification.And I realized it today when I had to …
Copy Notes with Attachments when a lead is qualified to Opportunity in Dynamics 365 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 Lately working on Microsoft flows these days where I am helping my customer to migrate Dynamics 365 workflows to Microsoft flow. One of the workflow was using a timeout condition with Duration Timeout …
Set TimeOut or wait condition in Power Automate/ Microsoft Flow 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.comFlows are the new path on which every Dynamics 365 consultant is treading now and while you move along, you discover many new stuffs on your journey.And one of them is when customer walked …
Invoke Power Automate/ Microsoft Flow from plugin in Dynamics 365 Read More »