Power Community

Power Community

How to filter JOSN array using Filter Array action in Power Automate

In this blog, we learn about filtering JSON arrays in Power Automate. We all know that this type of requirement can easily be solved using JavaScript. But in this method, we have to create a web resource to register the script in CRM. Now, we can achieve this requirement within the CRM process itself. Power Automate introduced the Filter Array action, using which we can easily filter the JSON array of objects and get the exact output from the JSON array.

Problem:

We have JSON data containing individual Employee’s Project Details, which specify that a single employee is working on how many projects, he completed how many projects, the estimation of the projects in days, and when those projects get started. Please find the below JSON array that we want to filter:

{
{
"Project Name": "Employee Payroll System",
"Start Date": "22-05-2021",
"Duration": 65,
"Industry": "IT Corporate",
"Status": "Complete"
},
{
"Project Name": "Healthcare Solution",
"Start Date": "22-03-2023",
"Duration": 95,
"Industry": "Heath and Hospitality",
"Status": "In Progress"
},
{
"Project Name": "Pharmacare Solution",
"Start Date": "26-03-2022",
"Duration": 32,
"Industry": "Heath and Hospitality",
"Status": "Complete"
},
{
"Project Name": "Agro Management System",
"Start Date": "22-08-2021",
"Duration": 120,
"Industry": "Agriculture",
"Status": "Complete"
},
{
"Project Name": "Finance Management System",
"Start Date": "22-08-2023",
"Duration": 38,
"Industry": "Finance",
"Status": "Not Started"
}
}

In the below JSON array, they mention five project details, so now we want to identify how many projects an individual employee has completed for a duration greater than 40.

Microsoft Power Platform

Solution:

To resolve this problem, we go with the Power Automate solution. We have created an on-demand Power Automate flow. In that we have passed the above JSON array to the flow as input as shown in the below screenshot:

Filter Array action in Power Automate

 After that, we apply the Filter Array action on the above input of JSON array as shown below in the screenshot:

Filter Array action in Power Automate

Please find the below Filter Array expression that we have used to get the exact output:

@and(equals(item().Status,’Complete’),greater(item().Duration,40))

In the above expression, we have applied both conditions which we have merged with the @and clause. In that,

1. The projects which were completed, were obtained using the @equals clause

equals(item().Status,’Complete’)

2. The projects which have not been completed within 40 days, were obtained using the @greater

greater(item().Duration,40)

After applying the Filter Array action we got the exact output as shown in the screenshot below:

Filter Array action in Power Automate

Conclusion

Filter Array is the best option to filter the JSON array in Power Automate without writing any external programming logic.

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Mastering Microsoft Dynamics 365 CRM Data Visualization with Map My Relationships: The Complete Guide!

Microsoft Dynamics 365 CRM is a powerful customer relationship management system widely used by businesses to manage customer interactions,...

More Articles Like This

- Advertisement -spot_img