Find articles, guides, information and community news

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, common scenario is to get current date and time to do manipulations on current date.

How to set up OAuth 2.0 in Power Automate Custom Connector in order to use the Automation API for Business Central.

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 extract parameters that are present in website url, which can be achieved easily using uriQuery Function as an example.

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, most of the common scenario is to format Date and Time based on the customer requirement, in Power Automate it can be achieved easily using formatDateTime Function.

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 Power Automate, functions place an important role for conversions, to quickly see how to Convert UTC Time to IST Time we use Instant Cloud flow.

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.

Parsing out text from formatted emails is a common requirement.  This blog explains how to use the split() expression to meet the requirement.

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.

Analyze the members of a distribution list which is populated by an HR process and automatically add new members to a specific Team, and send them a custom welcoming email with details.

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.