Data Operation while working with Microsoft Flow in Dynamics 365.

 Hello Guys,

Today we will see some data operation while working with Microsoft Flow. But before If you are new to MS Flow then please read my this blog.




Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends.

As of now we have created so many flows and used some data operation like Compose, Filter Array etc. Today we will see Parse JSON and Select data operation. Also we will see how can we avoid loops for making our flow faster in performance.

We will be creating one flow which will retrieve records of Three entities named Customer, Vendor and Partner. For time being I have already made these three entities in CRM and also created sample data. Here we go...

Navigate to https://us.flow.microsoft.com and click on Create. Select Instant Flow and configure it as below and click on Create.




Click on New Step. Search List records and configure it as below. Will do it for all three entities.




Now we will add next step i.e. Initialize Array variable. Configure it as below.




We will merge all these three entities data into one array variable. We have already retrieved records for all three entities. Now we can use Apply for each loop to add records of entity to the array. But we have to do it thrice as we have three entities. Also using loop is causing performance issue while working with large dataset.  

To increase performance of the flow we will use Parse JSON data operation and also Select Data Operation. Once data will be selected, we will create string variable which will combined these three Select Data. Add new step and search Parse JSON. Configure it as below.




Now we have parsed all these three entities. Now click on add new step and search initialize variable and configure it as below.




Click on New step and search Select Data operation. Configure it as below.
Will do it for all parsed JSON.



Now we will append this select data to string variable. Add new step and search append to string. Configure it as below.






replace(replace(string(body('Select_Customer')),'[',','),']','')
replace(replace(string(body('Select_Vendor')),'[',','),']','')
replace(replace(string(body('Select_Partner')),'[',','),']','')

So now our string is ready. it contains records for all three entitles. Now will be adding this string to our array using JSON function. Add new step. Search Set variables.




json(concat(concat('[',substring(variables('Data String'),1,sub(length(variables('Data String')),1))),']'))

So our flow is ready now. Will run and check whether it is containing all records together in one array or not.




As you can see we have output which is as below.

[
  {
    "ID": "6872820e-6b10-eb11-a813-000d3a5306e5",
    "Name": "Malishka Gupta",
    "City": "New Delhi",
    "Account Type": "Customer"
  },
  {
    "ID": "5c5d2c19-6b10-eb11-a813-000d3a5306e5",
    "Name": "Vihan Ranjan",
    "City": "Lucknow",
    "Account Type": "Customer"
  },
  {
    "ID": "810bd228-6b10-eb11-a813-000d3a5306e5",
    "Name": "Vinita Gupta",
    "City": "Valsad",
    "Account Type": "Customer"
  },
  {
    "ID": "74dca636-6b10-eb11-a813-000d3a5306e5",
    "Name": "Prashant Chavan",
    "City": "Pune",
    "Account Type": "Customer"
  },
  {
    "ID": "fa60923d-6b10-eb11-a813-000d3a5306e5",
    "Name": "Satish Gupta",
    "City": "Ahemdabad",
    "Account Type": "Customer"
  },
  {
    "ID": "c35c0a50-6b10-eb11-a813-000d3a5306e5",
    "Name": "Gaurav Singh",
    "City": "Mumbai",
    "Account Type": "Vendor"
  },
  {
    "ID": "6402d756-6b10-eb11-a813-000d3a5306e5",
    "Name": "Angline Mary",
    "City": "Chennai",
    "Account Type": "Vendor"
  },
  {
    "ID": "75e0b662-6b10-eb11-a813-000d3a5306e5",
    "Name": "Sneha Kolin",
    "City": "Hydrabad",
    "Account Type": "Vendor"
  },
  {
    "ID": "01f87083-6b10-eb11-a813-000d3a5306e5",
    "Name": "Gurpreet Gill",
    "City": "Pune",
    "Account Type": "Vendor"
  },
  {
    "ID": "63ec448f-6b10-eb11-a813-000d3a5306e5",
    "Name": "Sowmya Rajsekhar",
    "City": "Chennai",
    "Account Type": "Vendor"
  },
  {
    "ID": "2e491bbe-6b10-eb11-a813-000d3a5306e5",
    "Name": "Riya Gupta",
    "City": "Varanasi",
    "Account Type": "Partner"
  },
  {
    "ID": "490f23cb-6b10-eb11-a813-000d3a5306e5",
    "Name": "Sameer Chatale",
    "City": "Chandrapur",
    "Account Type": "Partner"
  },
  {
    "ID": "ab5e07d2-6b10-eb11-a813-000d3a5306e5",
    "Name": "Nilesh Karle",
    "City": "Pune",
    "Account Type": "Partner"
  },
  {
    "ID": "9094b1d9-6b10-eb11-a813-000d3a5306e5",
    "Name": "Amol Birar",
    "City": "Nasik",
    "Account Type": "Partner"
  },
  {
    "ID": "b01288e5-6b10-eb11-a813-000d3a5306e5",
    "Name": "Vighnesha Gupta",
    "City": "Valsad",
    "Account Type": "Partner"
  }
]

Now we will retrieve only name and will store it in another array variable. Add new step and initialize array variable as below.




Add new step of select and configure it as below. We will select name from the All account array.




item()['Name']

Now add new step i.e. set variable and configure it as below.




Run the flow again.




As you can see we have Names in array variable as output.

Hope it helps...









Comments

Post a Comment

Popular posts from this blog

Read Only Sub Grid & Editable Sub grid in Dynamics 365

Image
Hello Guys, In my previous blogs we have seen Duplicate Detection in Dynamics 365 where we covered how you can use OOB feature of D365 to detect duplicate records. Today we will see how we can implement editable sub grid.  But before if you are new to our blog then do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. In Dynamics CRM we have seen many entities sharing parent child relationships and we can create records of child from the parent page. For example Account and Contact Entity. We can create a new contact entity from the Account Form with the help of Sub Grid control. We can also create sub grid for custom entity and can utilize it in our own way. We will be using Department and Employee Entity for demonstration. Below are the steps: Step 1:- Login to Dynamics 365 with credentials. Step 2:- Click on Advance Settings Gear icon. Navigate to Settings -> Solution -...
Read more

Using Pipelines in Power platform for deploying solutions to environments.

Image
Hello Guys, In our previous  blog   we have seen how to use changesets in PA flow for atomic transactions. Today we will see how we can use Power Platform pipeline for deploying solutions. Do follow us to know more about Dynamics and Power Platform.  Also if you like our blog then please comment and share this blog with your friends. AS a CRM Developer, we need to create and manage solutions for various environment. Once development is done on Dev environment, we are moving the CRM changes by packaging into the solution to next environment like UAT and Production. Previously we were doing the solution movement manually but nowadays we have CICD pipeline in Azure. Now Microsoft has introduced pipelines in Power Platform too. So today we will be exploring the same Pipeline and will see how to deploy solutions in various environment using Power Platform Pipeline.  As you can see in above image, we have three environments like Dev, UAT and Prod. We will be doing some cus...
Read more

Understanding Sales Process in D365.

Image
Hello Guys, In our previous blog we have seen what is Lead and types of leads. Today we are going to understand Sales Process. Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. Sales Life cycle begins with Lead. Business captures leads through advertising, marketing, trade shows, mailings etc. Whenever organization gets any new lead, Sales Person captures the information of the lead in Lead entity available in Dynamics 365. For creating lead we require only two things, Lead Name and a Topic describing the lead. Once lead creation is completed, Sales Person performs follow up activities by sending emails, appointment and phone calls to collect more information about the lead. Microsoft Dynamics 365 stores these activities in the Activities entity in the system. Leads can be qualified or disqualified. A disqualified lead indicates that the lead is not a good candidate for sales opportunit...
Read more