Filtering an array in Microsoft Flow.

 Hello Guys,

In our previous blog we have seen how to create an array in MS Flow. Today we are going to learn how to use filter array data operation in Microsoft Flow. 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.

We will be working with same flow which we have created in previous blog.




As you can see in above image we have already created one flow in which we have created one Employee Array and it contains some sample data as below.

[
  {
    "ID": "c4270d27-5bfe-ea11-a815-000d3a5306e5",
    "First Name": "Ravish",
    "Last Name": "Gupta",
    "Address": "French Quarter",
    "City": "New Orleans",
    "Department": "IT",
    "Salary": 56000
  },
  {
    "ID": "6774d9a8-5bfe-ea11-a815-000d3a5306e5",
    "First Name": "Anupriya",
    "Last Name": "Gupta",
    "Address": "Hajratganj",
    "City": "Lucknow",
    "Department": "HR",
    "Salary": 45000
  },
  {
    "ID": "249cc5c1-5bfe-ea11-a815-000d3a5306e5",
    "First Name": "Malishka",
    "Last Name": "Rathore",
    "Address": "Rajouri Garden",
    "City": "New Delhi",
    "Department": "IT",
    "Salary": 45000
  },
  {
    "ID": "bd8b1fea-5bfe-ea11-a815-000d3a5306e5",
    "First Name": "Vihan",
    "Last Name": "Ranjan",
    "Address": "Kothrud",
    "City": "Pune",
    "Department": "Sales",
    "Salary": 34000
  },
  {
    "ID": "2153022c-5cfe-ea11-a815-000d3a5306e5",
    "First Name": "Vinita",
    "Last Name": "Gupta",
    "Address": "Nanakwada",
    "City": "New Delhi",
    "Department": "Sales",
    "Salary": 40000
  },
  {
    "ID": "7eabb85b-5cfe-ea11-a815-000d3a5306e5",
    "First Name": "Elbin",
    "Last Name": "Thomas",
    "Address": "Bavdhan",
    "City": "Pune",
    "Department": "Marketing",
    "Salary": 29000
  },
  {
    "ID": "145414a6-80fe-ea11-a815-000d3a5306e5",
    "First Name": "Joseph",
    "Last Name": "Morgan",
    "Address": "St. Peter Way",
    "City": "Manhatan",
    "Department": "Marketing",
    "Salary": 35000
  },
  {
    "ID": "3ad1b1e9-80fe-ea11-a815-000d3a5306e5",
    "First Name": "Wolfgang",
    "Last Name": "Bogdanow",
    "Address": "New Taxas",
    "City": "Taxas",
    "Department": "IT",
    "Salary": 67000
  },
  {
    "ID": "bb6a7233-81fe-ea11-a815-000d3a5306e5",
    "First Name": "Nomi",
    "Last Name": "Marks",
    "Address": "St. Louis",
    "City": "Manhatan",
    "Department": "Sales",
    "Salary": 43000
  }
]

So now will be filtering this array with some criteria. So first of all we will be adding a new step. Click on add a new step and search Filter Array Data Operation.

1. Filter array where Employee Name is Ravish Gupta. To achieve this configure the step as below.




You can click on Edit in advance mode and can write the criteria. For Example,

@equals(item()['First Name'], 'Ravish')

Add a new step and search Compose and configure it as below.




Here we have used Compose Data operation. As name suggest this data operation is used to create container which contains output from the previous step and you can use this output in further step.

If you have a single value that you want to re-use many different times throughout your flow and you don't want to change this value through out the execution then you can use Compose. Basically we can also use a variable(eg. Array) to store this output which is returned from Filter Array but as we know that we can change the value of the variable in any step of the flow. 

Compose is like using constant variable in any programming languages where its  value remain same through out the program and can't be change. 

Now run the flow and check the output.




As you can see in compose step(Filtered Employee) we have only one record. 

2. Filter Array where Salary is greater than 30000. Configure the Filter Array step as below




@greater(item()['Salary'], 30000)

3. Now we will be searching the Employee who are from Pune, Lucknow and New Orleans city.




@contains(createArray('Pune', 'Lucknow', 'New Orleans'), item()?['City'])

Run the flow and check the output.


















[
  {
    "ID": "c4270d27-5bfe-ea11-a815-000d3a5306e5",
    "First Name": "Ravish",
    "Last Name": "Gupta",
    "Address": "French Quarter",
    "City": "New Orleans",
    "Department": "IT",
    "Salary": 56000
  },
  {
    "ID": "6774d9a8-5bfe-ea11-a815-000d3a5306e5",
    "First Name": "Anupriya",
    "Last Name": "Gupta",
    "Address": "Hajratganj",
    "City": "Lucknow",
    "Department": "HR",
    "Salary": 45000
  },
  {
    "ID": "bd8b1fea-5bfe-ea11-a815-000d3a5306e5",
    "First Name": "Vihan",
    "Last Name": "Ranjan",
    "Address": "Kothrud",
    "City": "Pune",
    "Department": "Sales",
    "Salary": 34000
  },
  {
    "ID": "7eabb85b-5cfe-ea11-a815-000d3a5306e5",
    "First Name": "Elbin",
    "Last Name": "Thomas",
    "Address": "Bavdhan",
    "City": "Pune",
    "Department": "Marketing",
    "Salary": 29000
  }
]

In our upcoming blogs we will see some functions of an array.

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