Hello everyone and welcome to my blog. In today’s blog I will show how you can display date and time in a specific locale in Power Automate. Let’s get started. Power Automate has this wonderful formatDateTime function which can be used to display date and time values in various formats. Today’s date is 10th of …
How to display date and time in specific locale in Power Automate Read More »
Hello everyone and welcome to my blog. In this blog I will show how you can search for emails within a specific date range in Outlook. The technique described shall work if you want to query for emails within a specified date range from Through my blog I share interesting tips and discuss on latest …
How to search for emails within a specified date range in exchange/ outlook Read More »
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 show how you can launch a Power Automate flow using a button from a row in SharePoint list item. The blog should help you to learn the following scenarios. Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET …
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 discuss on how you can fetch files of specific type from a folder using Power Automate. This blog will help you if you have any of the following requirements in Power Automate Through my blog I share interesting tips and discuss on latest …
How to get files of a specific type from a SharePoint folder using Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss on how we can workaround issues while using Switch Case in Power Automate flows. If you want to understand how to check for null conditions in switch-case of Power Automate flow, you will find this blog useful. Through my blog I share …
Hello everyone and welcome to my blog. In today’s blog we will discuss on how to get the environment id in which the Power Automate flow is executing and also the GUID of the flow Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, …
How to get Environment id and flow id 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. Today we will walkthrough how you can extract numbers from a string using 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 to stay updated. …
How to extract numbers from string 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. In today’s blog we are going to learn on how to execute DataVerse actions using transaction scope in 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 …
How to perform DataVerse actions in transaction in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss 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 scripting libraries. Please subscribe to my blog to stay updated. So let’s get started. I am going …
String operations using index, FirstN, LastN characters from string in Power Automate Read More »
Hello everyone and welcome to my blog. In today’s blog I will discuss 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 scripting libraries. Please subscribe to my blog to stay updated. Let’s get started. We will start with …
Sort a collection or array of objects in Power Automate with sort order. Read More »
Hello everyone and welcome to my blog. In today’s blog I will show how you can Populate a word template in Power Automate with Dynamic files. Below is a word template that I will use for this demo. It has three text template placeholders and I have put appropriate tag and name for each of …
{Solved} How to populate word template with Dynamic files 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. In today’s blog I shall walkthrough the steps to get the error message when a prior scope failed in Power Automate flow. Using scopes to mimic Try-Catch behavior in Power Automate is pretty well known and has been aptly documented in quite a few articles. But there are …
How to get error message from failed scope in Power Automate flow 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 will show on how you can add comment to a SharePoint list item using Power Automate. Comments are a great feature to add information for SharePoint list item. You can put in additional information for each list item and also tag users. Once you …
How to add comment to SharePoint List Item using Power automate Read More »
Hello everyone and welcome to my blog. In today’s blog I am going to discuss about a new feature that will help you to create expressions based on your desired output. Power Platform is low code – no code, a platform for citizen developers. Make no mistake about it. But at the same time, let’s …
Hello everyone and welcome to my blog. In today’s blog I will discuss on how we can retrieve the contents of DataVerse image column and send it as an attachment in an email. We are going to use Power Automate for this. Power Automate DataVerse connector has actions to upload and download image and file …
How to retrieve content of Image column in DataVerse and send it as an email attachment 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 »
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 »
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 »
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 »
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 »
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 …
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 »
These are days of integration. And when it comes to Power platform, you have plenty of options to do the same. And one of the most common ways to interact with data of DataVerse (Common Data Service) is through the method of registering an app in azure active director and provide necessary permissions to the …
Error while creating an Application User in Dynamics 365/ Model driven apps 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 »
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 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 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 »
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 …
How do I use FetchXml in Power Automate? How do I access related entity fields when using Fetchxml in PowerAutomate? If you are having any of the above questions, you are at the right place. Strictly speaking, this blog is more about how to access related entity information in PowerAutomate through FetchXml. But as I …
How to query related entity data in CDS using FetchXml in Power Automate 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 release of Power Automate, it continue to evolve in terms of performance and features. Every release come with some new actions and triggers which make implementation of real life solutions much …
Format Currency and Numbers in Microsoft PowerAutomate/ 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 With each new release, Microsoft add new feature to Power Automate. And these new features does not cease to amaze every Power Apps consultant out there. But sometime the simplest of requirement take …
Get Next Month and Previous Month 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.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.com Microsoft Power Automate have indeed have lot of power in its Kitty. It has all the functions required to perform the minute operations that are required to perform our day to day task.And …
Convert string to 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.com Power Automate is like a continuously evolving engine adding more power to it with every release by Microsoft. I still remember the limited functionality it had when it was introduced. Looking back to …
Add/ remove/ modify JSON elements of a JSON array in Power Automate/ Microsoft Flow Read More »