{"id":34461,"date":"2023-04-17T14:24:04","date_gmt":"2023-04-17T08:54:04","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=34461"},"modified":"2024-01-04T12:23:57","modified_gmt":"2024-01-04T06:53:57","slug":"how-to-filter-json-array-using-filter-array-action-in-power-automate","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2023\/04\/how-to-filter-json-array-using-filter-array-action-in-power-automate\/","title":{"rendered":"How to filter JSON array using Filter Array action in Power Automate"},"content":{"rendered":"

A requirement of filtering JASON arrays can easily be solved using JavaScript. But to do it in Power Automate<\/a>, we have to create a web resource and register the script in CRM. However, with the new updates, 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.<\/p>\n

Requirement:<\/strong><\/p>\n

Consider that we have JSON data containing individual Employee\u2019s Project Details which specify the number of projects that a single employee is working on, the number of projects completed, the estimation of the projects in days, and their start date. Please find below the JSON array that we want to filter:<\/p>\n

{\r\n\r\n{\r\n\r\n\"Project Name\": \"Employee Payroll System\",\r\n\r\n\"Start Date\": \"22-05-2021\",\r\n\r\n\"Duration\": 65,\r\n\r\n\"Industry\": \"IT Corporate\",\r\n\r\n\"Status\": \"Complete\"\r\n\r\n},\r\n\r\n{\r\n\r\n\"Project Name\": \"Healthcare Solution\",\r\n\r\n\"Start Date\": \"22-03-2023\",\r\n\r\n\"Duration\": 95,\r\n\r\n\"Industry\": \"Heath and Hospitality\",\r\n\r\n\"Status\": \"In Progress\"\r\n\r\n},\r\n\r\n{\r\n\r\n\"Project Name\": \"Pharmacare Solution\",\r\n\r\n\"Start Date\": \"26-03-2022\",\r\n\r\n\"Duration\": 32,\r\n\r\n\"Industry\": \"Heath and Hospitality\",\r\n\r\n\"Status\": \"Complete\"\r\n\r\n},\r\n\r\n{\r\n\r\n\"Project Name\": \"Agro Management System\",\r\n\r\n\"Start Date\": \"22-08-2021\",\r\n\r\n\"Duration\": 120,\r\n\r\n\"Industry\": \"Agriculture\",\r\n\r\n\"Status\": \"Complete\"\r\n\r\n},\r\n\r\n{\r\n\r\n\"Project Name\": \"Finance Management System\",\r\n\r\n\"Start Date\": \"22-08-2023\",\r\n\r\n\"Duration\": 38,\r\n\r\n\"Industry\": \"Finance\",\r\n\r\n\"Status\": \"Not Started\"\r\n\r\n}\r\n\r\n}<\/pre>\n
In the above JSON array, they mention project details for five projects. So, now we want to identify how many projects an individual employee has completed for a duration greater than 40.<\/p>\n
Solution<\/strong><\/h2>\n
For this requirement, 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 as an input as shown in the following screenshot:<\/p>\n
\"Filter<\/p>\n
Next, we apply the Filter Array action on the above input of the JSON array<\/p>\n
\"Filter<\/p>\n
Following is the Filter Array expression that we have used to get the exact output:<\/p>\n
@and(equals(item().Status,\u2019Complete\u2019),greater(item().Duration,40))<\/em><\/strong><\/p>\n
Here we have applied both conditions which we have merged with the\u00a0@and<\/em>\u00a0<\/strong>clause. In that,<\/p>\n
\"Microsoft<\/a><\/p>\n
1. The projects which were completed, were obtained using the @equals<\/em><\/strong> clause<\/p>\n
equals(item().Status,’Complete’)<\/em><\/strong><\/p>\n
2. The projects which have not been completed within 40 days, were obtained using the @greater<\/strong><\/p>\n
greater(item().Duration,40)<\/em><\/strong><\/p>\n
After applying the Filter Array action we got the exact output as shown in the screenshot below:<\/p>\n
\"Filter<\/p>\n
Conclusion<\/h2>\n
Filter Array<\/strong>\u00a0is the best option to filter the JSON array in Power Automate without writing any external programming logic.<\/p>\n","protected":false},"excerpt":{"rendered":"
A requirement of filtering JASON arrays can easily be solved using JavaScript. But to do it in Power Automate, we have to create a web resource and register the script in CRM. However, with the new updates, we can achieve this requirement within the CRM process itself. Power Automate introduced the Filter Array action, using\u2026 Read More: How to filter JSON array using Filter Array action in\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1913,1985,2361],"tags":[2689,1975],"class_list":["post-34461","post","type-post","status-publish","format-standard","hentry","category-microsoft-power-platform-services","category-power-automate","category-technical","tag-json-array","tag-power-automate"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t