{"id":8235,"date":"2025-09-08T18:36:43","date_gmt":"2025-09-08T18:36:43","guid":{"rendered":"https:\/\/powergi.net\/?p=8235"},"modified":"2025-09-15T19:04:24","modified_gmt":"2025-09-15T19:04:24","slug":"how-to-use-filter-array-power-automate","status":"publish","type":"post","link":"https:\/\/powergi.net\/es\/blog\/how-to-use-filter-array-power-automate\/","title":{"rendered":"C\u00f3mo usar el array de filtro en Power Automate"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"8235\" class=\"elementor elementor-8235\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dc8526a e-flex e-con-boxed e-con e-parent\" data-id=\"dc8526a\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-314f5f5 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"314f5f5\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings='{\"exclude_headings_by_selector\":[],\"no_headings_message\":\"No headings were found on this page.\",\"headings_by_tags\":[\"h2\",\"h3\",\"h4\",\"h5\",\"h6\"],\"marker_view\":\"numbers\",\"minimize_box\":\"yes\",\"minimized_on\":\"tablet\",\"hierarchical_view\":\"yes\",\"min_height\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_tablet\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_mobile\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]}}' data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTable of Contents\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__314f5f5\" aria-expanded=\"true\" aria-label=\"Open table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__314f5f5\" aria-expanded=\"true\" aria-label=\"Close table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__314f5f5\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee575f0 elementor-widget elementor-widget-heading\" data-id=\"ee575f0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">What are data operations in Power Automate?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a892ccb elementor-widget elementor-widget-text-editor\" data-id=\"a892ccb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Data operations in Power Automate\u00a0 allow you to manipulate (sort, filter, rearrange, and much more) data while the flow is running. The list of data operations available in Power Automate are:<\/span><\/p><ul style=\"margin-top: 0in;\" type=\"disc\"><li><span lang=\"ES-SV\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Parse JSON<\/span><\/li><li><span lang=\"ES-SV\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Create CSV table<\/span><\/li><li><span lang=\"ES-SV\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Filter array<\/span><\/li><li><span lang=\"ES-SV\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Select<\/span><\/li><li><span lang=\"ES-SV\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Join<\/span><\/li><li><span lang=\"ES-SV\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Create HTML table<\/span><\/li><li>Compose<\/li><\/ul><div><img decoding=\"async\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c553682.png\" alt=\"\"><\/div><div>In this blog we will talk about how to use filter array in Power Automate, so we will focus on the \u201cfilter array\u201d action.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aacea99 elementor-widget elementor-widget-heading\" data-id=\"aacea99\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">What is the filter array action in Power Automate?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-46e43e3 elementor-widget elementor-widget-text-editor\" data-id=\"46e43e3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The filter array action in Power Automate is used to reduce the number of objects in an array to a subset that meet one or more specific conditions.<\/p><p><strong>How it works<\/strong><\/p><ul><li>Input: An array or list of items, it usually comes from another action like Get items (SharePoint), List rows (Dataverse\/Excel) or a result from an API call.<\/li><\/ul><ul><li>Condition: A logical test you define in the \u201cChoose value\u201d \/ \u201cis equal to\u201d \/ \u201cChoose value\u201d style fields, or by writing an expression.<\/li><\/ul><p>Output: A new array containing only items where the condition is true.<img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c57d501.png\" alt=\"\"><\/p><p>In the above example, we would take a list from another action, then apply a filter (First name = Eugenia) and the outputs of this action would be all items from the list that match this criteria.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-040e445 elementor-widget elementor-widget-heading\" data-id=\"040e445\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">When to use filter array vs OData filter query?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0bd6d08 elementor-widget elementor-widget-text-editor\" data-id=\"0bd6d08\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>There are two main ways to filter data in Power Automate:<\/p><p><span style=\"font-style: inherit; font-weight: inherit;\">Use an <\/span><strong style=\"font-style: inherit;\">OData filter query<\/strong><span style=\"font-style: inherit; font-weight: inherit;\"> directly in your data-retrieval action, this filter is applied in the very same action that the data is retrieved. For example if we want to extract all projects from a SharePoint list that have \u201cRejected\u201d status, we can do this directly in the SharePoint action:<\/span><\/p><p><img decoding=\"async\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/migrated-img-8235-6a4450c5a4a8e.webp\" alt=\"\"><\/p><p><span style=\"font-style: inherit; font-weight: inherit;\">There are different types of filters that can be applied, you can find a full guide on <\/span><span style=\"font-style: inherit; font-weight: inherit;\"><a href=\"https:\/\/powergi.net\/blog\/ultimate-guide-to-odata-query-filters-in-sharepoint\/\">SharePoint OData filters in our blog<\/a><\/span><span style=\"font-style: inherit; font-weight: inherit;\">.<\/span><\/p><p>Apply the Filter array\u00a0action after the data has been fetched: first, we extract data from a data source (Excel, Dataverse or a third party API), and on top of the result returned by the system, we apply a filter inside the flow.<\/p><p><img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c5f32e0.png\" alt=\"\"><\/p><div id=\"seology-cta-1\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7283\" class=\"elementor elementor-7283\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Is your business ready for automation?<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Automate processes with Microsoft Power Platform.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/es\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">OData query filters are used when the data source supports this type of filtering and when the data type we want to filter by is allowed. <\/span><span lang=\"ES-SV\" style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">For example:<\/span><\/p><ul style=\"margin-top: 0in;\" type=\"disc\"><li class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">SharePoint allows OData filters, but calculated columns are not filterable columns<\/span><\/li><li class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Excel allows OData filters, but only one column can be filtered at a time and the column name can\u2019t have special characters such as spaces.<\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8b5971c elementor-widget elementor-widget-heading\" data-id=\"8b5971c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">When to use the Filter array action<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a282c1 elementor-widget elementor-widget-text-editor\" data-id=\"7a282c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The filter array action is used mainly when OData filters can\u2019t\u00a0 be applied, but there are other scenarios that will require the need of this action in the workflow. Here is a quick guide with some general points to consider:<\/p><ul><li>The data source <strong>doesn\u2019t support OData filtering<\/strong>\u00a0<\/li><li>You need <strong>more complex logic<\/strong> than OData can handle (substring matches, regex, nested array fields, case-insensitive comparisons, advanced date math).<\/li><li>You already have an array from a <strong>previous step<\/strong> (like a variable or API response) and need to refine it further.<\/li><li>You\u2019re combining data from <strong>multiple sources<\/strong> before filtering.<\/li><\/ul><table><tbody><tr><td><p><strong>Feature<\/strong><\/p><\/td><td><p><strong>OData Filter Query<\/strong><\/p><\/td><td><p><strong>Filter Array<\/strong><\/p><\/td><\/tr><tr><td><p><strong>When filtering happens<\/strong><\/p><\/td><td><p>Before data is retrieved (server-side)<\/p><\/td><td><p>After data is retrieved (flow-side)<\/p><\/td><\/tr><tr><td><p><strong>Performance<\/strong><\/p><\/td><td><p>\u00a0Faster, less data transferred<\/p><\/td><td><p>\u00a0Slower if large dataset<\/p><\/td><\/tr><tr><td><p><strong>Complex logic<\/strong><\/p><\/td><td><p>\u00a0Depends on the data source<\/p><\/td><td><p>Very flexible<\/p><\/td><\/tr><tr><td><p><strong>Best for<\/strong><\/p><\/td><td><p>Reducing data load from supported connectors<\/p><\/td><td><p>Filtering arrays already in your flow<\/p><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1fab22 elementor-widget elementor-widget-heading\" data-id=\"a1fab22\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How to use filter array with a single condition?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-88bbd30 elementor-widget elementor-widget-text-editor\" data-id=\"88bbd30\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The <strong>Filter array<\/strong> action is quite simple when working with just one condition. Just pick the array to filter, define the property to check, and set your comparison operator.\u00a0<\/p>\n<p>There are multiple operators available:<img decoding=\"async\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/migrated-img-8235-6a4450c62cc41.webp\" alt=\"\" style=\"font-size: 1rem;\"><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b1a2003 elementor-widget elementor-widget-heading\" data-id=\"b1a2003\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Example: filter for value equal to<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-190830c elementor-widget elementor-widget-text-editor\" data-id=\"190830c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Depending on the condition you want to apply, just select the column to filter by on the left side of the action, then select the operator from the dropdown, and finally write the criteria to be met on the right side.<\/p>\n<p>Below shows a filter for projects \u201cequals to\u201d Rejected.<img decoding=\"async\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c6a8536.png\" alt=\"\" style=\"font-size: 1rem;\"><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f3b3ee elementor-widget elementor-widget-heading\" data-id=\"7f3b3ee\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Example: not equal to vs contains vs starts with<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-316460b elementor-widget elementor-widget-text-editor\" data-id=\"316460b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Depending on the criteria, different operators can be used. Below you\u2019ll find an example that will show all projects that \u201ccontain\u201d the word <strong>France <\/strong>in the name.<\/p><p><img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c6df07a.png\" alt=\"\"><\/p><p>We can also do something similar and bring everything that is \u201cnot equals to\u201d:<\/p><p><img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c725a88.png\" alt=\"\"><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3ca5569 elementor-widget elementor-widget-heading\" data-id=\"3ca5569\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Greater than, less than, greaterOrEquals, lessOrEquals<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-743e8dd elementor-widget elementor-widget-text-editor\" data-id=\"743e8dd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Filters can also be appled to numbers to return, for example, projects that started prior 2025:<img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c752464.png\" alt=\"\"><\/p><p>Expressions can also be applied on the criteria field, for example, if we want to dynamically calculate the current year, something like below can be written:<\/p><p><img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c7908e7.png\" alt=\"\"><b style=\"font-size: 1rem;\"><span style=\"font-size: 11pt; line-height: 107%; font-family: Aptos, sans-serif; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\"><br><\/span><\/b><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3ad2ad elementor-widget elementor-widget-heading\" data-id=\"a3ad2ad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Remove empty items (null)<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2d25ce5 elementor-widget elementor-widget-text-editor\" data-id=\"2d25ce5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>It\u2019s also very common to want to exclude items that are empty. To remove null results from an array, we must use the <strong>null <\/strong>expression as shown below:<img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/migrated-img-8235-6a4450c7c0e9d.webp\" alt=\"\"><\/p><p>The results should like this:<\/p><p><img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c83a5ca.png\" alt=\"\"><\/p><p>It\u2019s important to not write \u201cnull\u201d directly in the text input, otherwise Power Automate will interpret it as plain text.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-14b0e90 elementor-widget elementor-widget-heading\" data-id=\"14b0e90\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Remove empty items (empty string)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ac6be37 elementor-widget elementor-widget-text-editor\" data-id=\"ac6be37\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Some empty data comes as empty strings instead of nulls. For this scenario, a filter like this can be applied:<img decoding=\"async\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c8755a9.png\" alt=\"\" style=\"font-size: 1rem;\"><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b9d1b98 elementor-widget elementor-widget-heading\" data-id=\"b9d1b98\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How to apply multiple conditions (and \/ or)?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f5f3ee4 elementor-widget elementor-widget-text-editor\" data-id=\"f5f3ee4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Sometimes you need to filter your array based on more than one rule, for example \u201cRejected projects in 2025\u201d or \u201cApproved and In progress projects with a budget over 100,000 USD\u201d. The <strong>Filter array<\/strong> action allows you to combine conditions using the and() and or() functions.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-62e47fd elementor-widget elementor-widget-text-editor\" data-id=\"62e47fd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Using and() for \u201call conditions must be true\u201d<\/strong><\/p><p>and() makes sure that every condition inside it is true before the item is kept.<\/p><p>Example: Status = Rejected AND Year = 2025<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-30584d0 elementor-widget elementor-widget-code-highlight\" data-id=\"30584d0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>and(\n\n\u00a0\u00a0\u00a0\u00a0equals(item()?['Status'], \u2018Rejected\u2019),\n\n\u00a0\u00a0\u00a0\u00a0greater(item()?['Year'], 2025)\n\n)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2315d6a elementor-widget elementor-widget-text-editor\" data-id=\"2315d6a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Using or() for \u201cany condition can be true\u201d<\/strong><\/p><p>or() returns true if at least one condition is met.<\/p><p>Example: Status = In progress or Status = Approved<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a0f34c9 elementor-widget elementor-widget-code-highlight\" data-id=\"a0f34c9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>or(\n\n\u00a0\u00a0\u00a0equals(item()?['Status'], \u2018Approved\u2019),\n\n\u00a0\u00a0\u00a0equals(item()?['Status'],\u2019In progress\u2019)\n\n)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c69294 elementor-widget elementor-widget-text-editor\" data-id=\"7c69294\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Combining and() and or()<\/strong><\/p><p>You can nest them for more complex filters.\u00a0<\/p><p>Example: Status = In progress or Status = Approved AND budget &gt; 100,000<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-871e665 elementor-widget elementor-widget-code-highlight\" data-id=\"871e665\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>and(\n\nor(\n\n\u00a0\u00a0\u00a0equals(item()?['Status'], \u2018Approved\u2019),\n\n\u00a0\u00a0\u00a0equals(item()?['Status'],\u2019In progress\u2019)\n\n),\n\n\u00a0\u00a0\u00a0\u00a0greater(item()?['Budget'], 100000)\n\n)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-778857a elementor-widget elementor-widget-text-editor\" data-id=\"778857a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>An important consideration for filters that combine two or more criteria, is that these need to be written directly in the Power Automate action, by using the \u201cEdit in advanced mode\u201d option.<img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c8b791a.png\" alt=\"\"><\/p><p>Make sure to always include a \u201c@\u201d at the beginning of the expression.<\/p><p><img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c908878.png\" alt=\"\"><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4965502 elementor-widget elementor-widget-heading\" data-id=\"4965502\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Filter array coding convention<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-96b1b11 elementor-widget elementor-widget-text-editor\" data-id=\"96b1b11\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>When working with the filter array action, to indicate the column or attribute by which the filter will be applied,<strong> item()?[\u2018PropertyName\u2019]<\/strong> is used.<\/p><ul><li>The item() function represents the current row in the array.<\/li><li>The ? is a navigator operator that helps us connect the current row with the attribute we want to filter by.<\/li><li>The property name inside the brackets <strong>must match exactly<\/strong> the field name in your array (case-sensitive)<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a6cc6c4 elementor-widget elementor-widget-code-highlight\" data-id=\"a6cc6c4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>item()?['PropertyName']\n\nitem()?['Year']<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a58c70 elementor-widget elementor-widget-text-editor\" data-id=\"8a58c70\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If the column has some \u201cchild\u201d values, like LookUp columns or Choice columns in SharePoint \u2013 that have \u201cValue\u201d and\/or \u201cId\u201d. This can represented as follows:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9b82297 elementor-widget elementor-widget-code-highlight\" data-id=\"9b82297\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>item()?['Status\/Value']\n\nitem()?['Company\/Id']<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dde2786 elementor-widget elementor-widget-heading\" data-id=\"dde2786\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How to get the count from filter array?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9634693 elementor-widget elementor-widget-text-editor\" data-id=\"9634693\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The length() function is used to count how many results the filter returned.<\/p><div id=\"seology-cta-2\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7531\" class=\"elementor elementor-7531\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Are you ready to discover the joy of automation?<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Whether you have a project in mind or just want to know how we can help, we\u2019re happy to have a conversation<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/es\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div><p>This is really useful for example to know when to do something or not do anything.\u00a0<\/p><ul><li>If there aren\u2019t projects rejected for 2025, then: do nothing.<\/li><li>If there are: send a summary email<img decoding=\"async\" style=\"font-size: 1rem;\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c941f21.png\" alt=\"\"><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dfc766a elementor-widget elementor-widget-code-highlight\" data-id=\"dfc766a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>length(body('Filter_array'))<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9bccdee elementor-widget elementor-widget-heading\" data-id=\"9bccdee\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How to use the results from filter array?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fe9deee elementor-widget elementor-widget-text-editor\" data-id=\"fe9deee\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>After applying <strong>Filter array<\/strong>, the output is a <strong>new array<\/strong> containing only the items that matched your conditions. We can use these results in different ways depending on your scenario. The \u201cBody\u201d output of the filter array action is what we would usually use.<\/p><p><img decoding=\"async\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/06\/migrated-img-8235-6a4450c975e90.png\" alt=\"\"><\/p><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Some examples of how the results are used are:<\/span><\/p><p class=\"MsoNormal\"><b>Loop\u00a0through the results<\/b><\/p><p class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">The\u00a0most common use case is processing each filtered item.<\/span><\/p><ul style=\"margin-top: 0in;\" type=\"disc\"><li class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">Add an <b>Apply to each\u00a0<\/b>action.<\/span><\/span><\/li><li class=\"MsoNormal\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\"><span style=\"background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\">In the <i>Select an output from previous steps<\/i> box, choose the <b>body of Filter array<\/b>.<\/span><\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c9ff442 elementor-widget elementor-widget-code-highlight\" data-id=\"c9ff442\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>Inside\u00a0the loop, you can work with properties like:\n\nitem()?['Year']\n\nitem()?['Status\/Value']<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-620f382 elementor-widget elementor-widget-text-editor\" data-id=\"620f382\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Get the first item from the filtered array<\/strong><\/p><p>If you only need one result (the first match), the following expression can be used:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40fa6cb elementor-widget elementor-widget-code-highlight\" data-id=\"40fa6cb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>\u00a0first(body('Filter_array'))?['Title']<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5062300 elementor-widget elementor-widget-heading\" data-id=\"5062300\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Common scenarios with filter array in Power Automate<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a50584 elementor-widget elementor-widget-heading\" data-id=\"9a50584\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Filter SharePoint list items<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a5dda0 elementor-widget elementor-widget-text-editor\" data-id=\"0a5dda0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If the column supports OData filters, then OData is recommended, but in the case that the column type is not supported for OData, the filter array action comes to the rescue! Some common cases of columns that can be used with Filter array are:<\/p>\n<ol>\n<li>When we want to filter by long text columns<\/li><li>When we want to filter by calculated columns<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-db2e2be elementor-widget elementor-widget-heading\" data-id=\"db2e2be\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Filter Excel table rows<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-35e8314 elementor-widget elementor-widget-text-editor\" data-id=\"35e8314\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The Excel connector has plenty of limitations when it comes to filtering, it pretty much covers only a single text column filter. Anything more complex than that, needs to be handled by a filter array. Some examples are:<\/p>\n<ol>\n<li>Multiple criteria combined (multiple columns)<\/li>\n<li>Filter by dates or numbers<\/li><li>Filter by column names with spaces in the header name or special characters<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-321d541 elementor-widget elementor-widget-heading\" data-id=\"321d541\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Common mistakes to avoid when using filter array<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc622be elementor-widget elementor-widget-text-editor\" data-id=\"dc622be\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>When working with combined filters (and \/ or), always use the advanced editor and include \u201c@\u201d at the beginning of the expression, otherwise it won\u2019t work!<\/li>\n<li>When there is a possibility that data can contain nulls, use the \u201ccoalesce\u201d function to handle the empty results.<\/li>\n<li>Keep in mind data types!\n<ul>\n<li>Text should be compared with text<\/li>\n<li>Dates should be compared with dates<\/li>\n<li>Numbers should be compared with numbers<\/li><li>Don\u2019t forget that arrays start at index 0. The first result is index\/row number 0. The second result is 1, and so on!<\/li><\/ul><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c6f19ba elementor-widget elementor-widget-heading\" data-id=\"c6f19ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Partner with Power GI to build smarter Power Platform solutions<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b767d9 elementor-widget elementor-widget-text-editor\" data-id=\"2b767d9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Building efficient flows often comes down to making the right choices \u2014 like knowing when to use <strong>Filter array<\/strong> inside Power Automate versus applying an <strong>OData filter query<\/strong> at the source.\u00a0 <strong><a href=\"https:\/\/powergi.net\/contact\/\">Contact us<\/a><\/strong> and start building great automations<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Table of Contents What are data operations in Power Automate? Data operations in Power Automate\u00a0 allow you to manipulate (sort, filter, rearrange, and much more) data while the flow is running. The list of data operations available in Power Automate are: Parse JSON Create CSV table Filter array Select Join Create HTML table Compose In [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":8261,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"glossary_letter":"","footnotes":""},"categories":[172,85],"tags":[],"class_list":["post-8235","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dpa","category-power-automate-cat"],"glossary_letter":"","rank_math_title":"How to use filter array in Power automate - Power GI","rank_math_description":"Learn how to use filter array in Power automate. Learn use cases, best practices, and when to choose it over other filtering methods.","rank_math_focus_keyword":"how to use filter array","_links":{"self":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts\/8235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/comments?post=8235"}],"version-history":[{"count":0,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts\/8235\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/media\/8261"}],"wp:attachment":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/media?parent=8235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/categories?post=8235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/tags?post=8235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}