Category Archives: Power Automate

Send an Email to all users in a D365 Team using power automate.

D365 gives us a functionality to assign a record to a group of users which can be archived by using a D365 Team these users then are know as members of that respective team, due to functionality restrictions we cannot send an email to a  D365 team, however there are a few workarounds by which … Continue reading Send an Email to all users in a D365 Team using power automate.

Share Story :

Send an Email to all users in a D365 Team using power automate

D365 gives us a functionality to assign a record to a group of users which can be archived by using a D365 Team these users then are know as members of that respective team, due to functionality restrictions we cannot send an email to a  D365 team, however there are a few workarounds by which … Continue reading Send an Email to all users in a D365 Team using power automate

Share Story :

Last and First expression in Cloud Flows – Part I

Let see how we can use last and first expression in Cloud Flows. We can use last and first expression get first and last value in array, strings and also we can use first and last expression to get first and last record from list of records in cloud flows Let get started!!!!! Let say … Continue reading Last and First expression in Cloud Flows – Part I

Share Story :

Send an email to users in a D365 Team Individually using power automate (without using a distribution list)

D365 gives us a functionality to assign a record to a group of users which can be archived by using a D365 Team these users then are know as members of that respective team, due to functionality restrictions we cannot send an email to a  D365 team, however there are a few workarounds by which … Continue reading Send an email to users in a D365 Team Individually using power automate (without using a distribution list)

Share Story :

Parse JSON and update excel using Cloud flow

Introduction: If you have an Excel with data in JSON format and do not want to use Excel Power Query to transform JSON, you can use the below actions in Cloud flows. Solution: Create a Manual trigger flow and upload the Excel with JSON data on SharePoint. Use List rows to read the excel data … Continue reading Parse JSON and update excel using Cloud flow

Share Story :

Last and First Expression in Cloud Flows – Part II

We have already seen how to extract character from string in Cloud flows. Let see how we can get first and last value in array. I have array of list of records (account records), want to get 1st value in array. Array – Add a compose step in flow and use below syntax to get … Continue reading Last and First Expression in Cloud Flows – Part II

Share Story :

Multi Select Option Set is not visible in Cloud flow Trigger Body

Problem Statement:  I triggered a Cloud flow and expected to get the multi select option set value as part of triggered body.  However, the trigger body does not show the field. I checked with Common Data Service(Current environment) and Common Data Service Connector as well. Solution: This is more of a workaround, we do not … Continue reading Multi Select Option Set is not visible in Cloud flow Trigger Body

Share Story :

Loop on Multi Select Option Set Values Using Cloud flow

Problem Statement: We wanted to run an action on all the selected values in a multi select option set(choice).We get the data in a comma separated string. Solution: 1.When we get the values in comma separated values, we will need to convert the string to an array format. Formula: array(split(Input comma separated data),’,’)) 2. Get … Continue reading Loop on Multi Select Option Set Values Using Cloud flow

Share Story :

Post Message in MS Team when Code is Checked-in Azure DevOps TFS

If you want to keep track of the Commits of any Critical Project and want to discuss with your Project Team Member regarding commits made on TFS. We can create a flow that will post the Commit details of that Critical Project on your Project Channel. Step 1: Create a Team and a channel to … Continue reading Post Message in MS Team when Code is Checked-in Azure DevOps TFS

Share Story :

Sort records in Cloud flows

In this blog we will see how we can sort list records in Cloud flows Lets say we want to retrieve all accounts on created by ascending. There are two ways to sort list of records in Cloud flows Order By – Fetch Xml – Order By – Use List Records step in Common Data … Continue reading Sort records in Cloud flows

Share Story :