In Power Automate, at times we need to merge 2 different strings into an Array we can use Create Array Function so that we can get easily desired result. As an example, let us see how to get an array of emails with 2 strings as well as process to merge two different arrays of questions and answers into a single array.
In Power Automate, at times we need to compare values Min Function is used so that we can get easily desired result. As an example, let us see how to get Minimum age of 2 persons as well as minimum value from a given array of integers with the help of Min
In Power Automate, at times we need to compare values Max Function is used so that we can get easily desired result. As an example, let us see how to get Maximum age of 2 persons as well as maximum value from a given array of integers with the help of Max function.
In Power Automate, at times we need to perform Addition arithmetic operations so that we can get easily desired result. As an example, let us see how to calculate total age of 2 persons with the help of Addition function.
In Power Automate, at times we need to perform Subtraction arithmetic operations so that we can get easily desired result. As an example, let us see how to calculate warranty period that is available in years for Generator with the help of Subtraction function.
In Power Automate, at times we need to perform multiplication arithmetic operations so that we can get easily desired result. As an example, let us see how to calculate number of minutes in a Day with the help of multiplication function.
In Power Automate, at times we need to perform division arithmetic operations so that we can get easily desired result. As an example, let us see how to calculate price of a candy for quick reference from a bundle cost with the use of div function.
In Power Automate, at times we need to perform Modular arithmetic operations so that we can get desired result, as an example we can see number of customers waiting for tables based on the customers present in a hotel , so that customers will get information about the number of customers waiting , so that they can plan accordingly.
In Power Automate, at times we need to have array with integers starting from the specified index for doing different operations in design of online exams or quizzes to provide random questions this function would be useful.
In Power Automate, there is a common task to extract complete day of the week from the given date, for this DayofWeek function will be used. Here in this example, we will see how to extract name of the day in a week.
In Power Automate, one of the common scenarios is to do some operations on current date. So, Add Days is one of the functions of its kind which works on the current date so that certain actions like sending an email to alert or give information to user as an example here I am adding 5 days.
In Power Automate, one common scenario is to get the path after the host which will allow to configure url’s easily between environments automatically. uriPath function is used to extract path after host in power automate.
In Power Automate, most of the common scenario is to extract host details URI where in power automate can be used to form a dynamic url to open any record from an email link which can be achieved easily using URIHost Function .
In Power Automate, most of the common scenario is to verify null values and default to a specific value, in Power Automate it can be achieved easily using Coalesce Function as an example and Plan Object is considered.
In Power Automate, in few of the scenarios we need to generate random number example to prepare a unique name with text and combination of Unique number so as to provide a quick test data then rand function is used.
In this Article, I have explained the business scenario of Creating Excel Workbook in a Folder that exists in SharePoint Document Library, also dynamically the folder is created, before storing this Excel Workbook.
In Power Automate, to return a uniform resource identifier (URI) encoded version for a string by replacing URL-unsafe characters with escape characters we can use either encodeUriComponent or uriComponent functions in expressions.
In order to learn and observe new features that are present in Dynamics CRM it is important to spin a trial instance every now and then, in this blog I am going to guide step by step process to Create a new crm trial instance
With the latest Power Automate Desktop May 2021 release, we have announced the deprecation of utilizing MODI OCR engine and Create Tesseract OCR engine action in Power Automate Desktop. Please review below to learn about the available replacements and more info about these deprecations.
Here’s how to save all attachments when an email arrives and move the email automatically. Nothing like automation that does 100% of the work for us. I'll also explain why the obvious solution won't work and show you a workaround in fixing it.
Do you have tasks that you need to do on the last working day of the month? Any reports to execute, backup to run, summary mail to send? Following the great idea of GTD (Get Things Done by David Allen), you shouldn't remember it, but set up a trigger that reminds you about this task to do at a specific point in time.
Do you want to build a flow that is triggered only when the particular mail arrives at the mailbox, and your condition wish list is long?
You can solve it using trigger conditions that are not well documented. I hope this article will fill this gap.
Some flows might run more often than you expect. For example, you create a flow that sends you a push notification whenever your manager sends you an email (by the way this is an example from Microsoft Learn). That flow must run every time you get an email from anyone because the flow must check whether the email came from your manager. This action counts as a run. And it doesn't need to be this way.
I’ve seen some questions recently on the Power Platform Forums about how to send multiple attachments submitted in Microsoft Forms in an email. Since this seems to be a common problem I thought it would be good to walk through the steps in a BLOG post.
I am a Microsoft Business Applications MVP and a Senior Manager at EY.
I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness.
I am a leader of the Houston Power Platform User Group and Power Automate community superuser.
I love traveling , exploring new places, and meeting people from different cultures.
I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 12 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.