powerautomate - Dynamics for CRM

Power Automate: Remove Special Characters From A String

When working with string in PowerAutomate we often have to remove special characters from the string. Some common use cases include field cleanup, file creation, etc. Let's look at building a reusable flow that can replace the special characters from a string easily. The flow has the following

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'