Category Archives: Power Automate
Nested IF Expression in Cloud Flow
Introduction: We have been using Action-Condition for IF in Cloud flow, while this is easy to use, it ends up making your flow bigger in size. Instead if we just need to validate conditions, we can use expression to do the same checks. Solution: Add a compose action>> Go to Expression>> Add if() Example: If(empty(field),’No … Continue reading Nested IF Expression in Cloud Flow
Share Story :
Retrieve Email Recipients(TO, CC, BCC) in Cloud Flow
Introduction: When we trigger a flow on Email Activity or retrieve email activity. However that does not provide us the recipient details of the email. Recipient details are stored as part of Activity Party. In this blog, we will understand how to retrieve the Email Recipients from the activity party of the email. Solution: From … Continue reading Retrieve Email Recipients(TO, CC, BCC) in Cloud Flow
Share Story :
Retrieve characters/Substring from string in Cloud Flows
In this blog we will see how to retrieve string or characters from string using substring and take method When we want to retrieve character/string from starting index then will use take() method, else will use substring() Let say we want to retrieve first 5 character from string. Eg. – string is Power Automate We … Continue reading Retrieve characters/Substring from string in Cloud Flows
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 :
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