powerautomate

Power Automate: Easily Replace New Line in Flow Expression

When recently working on a flow to do some data transformations to convert a CSV file into a JSON array, I had to find a way to replace the new line character from the string. My initial thought was, this should be very easy to do using replace [https://docs.

powerautomate

Power Automate: Group By Multiple Columns on a Collection

When recently working on a flow, I had a scenario where we need to group an existing collection using multiple columns. Typically this would be a very straight forward to accomplish using code. I thought the same can be achieved in flow easily. However, after checking the functions reference documentation

powerautomate

Power Automate: Send Dynamics 365 Email Using Common Data Service

Power Automate comes with a default Mail connector that we can use to send Emails easily, this just requires us to have the email addresses along with the content of the email. But if we want to send an Email with a mix of both static email address which do

powerautomate

Power Automate: Get Distinct Count From Array/Collection

When working with Power Automate we might be limited by the functions [https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference] that are available to us, that we have traditionally used in programming languages. Recently when working on a requirement that requires using distinct count of records for a certain property

flow

Using Server-to-Server authentication with Power Automate(Flow)

Power Automate(flow) makes automation with Dynamics 365 very easy to setup and configure without the need for a developer in most cases. While there are times we could run the automation for ourselves often times we need to share them or use it across the board. While it'