{"id":5689,"date":"2024-05-30T11:05:31","date_gmt":"2024-05-30T11:05:31","guid":{"rendered":"https:\/\/powergi.net\/?p=5689"},"modified":"2025-10-24T16:32:58","modified_gmt":"2025-10-24T16:32:58","slug":"ultimate-guide-to-odata-query-filters-in-sharepoint","status":"publish","type":"post","link":"https:\/\/powergi.net\/de\/blog\/ultimate-guide-to-odata-query-filters-in-sharepoint\/","title":{"rendered":"Ultimate guide to OData query filters for SharePoint in Power Automate"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"5689\" class=\"elementor elementor-5689\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4908419 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4908419\" data-element_type=\"section\" data-e-type=\"section\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-56ab151\" data-id=\"56ab151\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-619c1a6 elementor-widget elementor-widget-text-editor\" data-id=\"619c1a6\" 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=\"font-weight: 400;\">When working with Power Automate and SharePoint lists we usually are in need of extracting specific rows of data from lists, to do so, we need to use the \u201c<\/span><a href=\"https:\/\/en.wikipedia.org\/wiki\/Open_Data_Protocol\" target=\"_blank\" rel=\"noopener\"><b>Query filter<\/b><\/a><span style=\"font-weight: 400;\">\u201d field available in the SharePoint \u201cGet Items\u201d action. <\/span><\/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-0f8717f elementor-widget elementor-widget-image\" data-id=\"0f8717f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"830\" height=\"581\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media.png\" class=\"attachment-large size-large wp-image-5692\" alt=\"SharePoint \u201cGet Items\u201d action\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media.png 830w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-300x210.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-768x538.png 768w\" sizes=\"(max-width: 830px) 100vw, 830px\">\t\t\t\t\t\t\t\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-b3b02c7 elementor-widget elementor-widget-text-editor\" data-id=\"b3b02c7\" 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=\"font-weight: 400;\">OData queries are usually written in the following format:\u00a0<\/span><\/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-722e7b0 elementor-widget elementor-widget-code-highlight\" data-id=\"722e7b0\" 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>{InternalColumnName} operator {value}\u00a0<\/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-7c7098a elementor-widget elementor-widget-text-editor\" data-id=\"7c7098a\" 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=\"font-weight: 400;\">For example, if we want to search by the Title column in our SharePoint list to find all items with text \u201cBarista Lite\u201d, our odata query filter would look as follows: <\/span><\/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-1eeed46 elementor-widget elementor-widget-image\" data-id=\"1eeed46\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"230\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-1-1024x230.png\" class=\"attachment-large size-large wp-image-5694\" alt=\"odata query filter\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-1-1024x230.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-1-300x67.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-1-768x173.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-1.png 1162w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-c8b3c02 elementor-widget elementor-widget-text-editor\" data-id=\"c8b3c02\" 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><b>InternalColumnName = Title\u00a0<\/b><\/p><p><b>Operator = eq\u00a0<\/b><\/p><p><b>Value = Barista Lite (text we are searching by)\u00a0<\/b><\/p><p><span style=\"font-style: inherit; font-family: var( --e-global-typography-text-font-family ), Poppins; background-color: var(--ast-global-color-5);\">There are some exceptions to this structure (like when we try to apply \u201ccontains\u201d logic), but this is the rule we almost always follow.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">What\u2019s great about OData queries is that you can also use a similar filter logic for other data connectors in the Power Platform such Excel and Dataverse (with some differences depending on the data type).<\/span><\/p><p>For businesses looking to optimize their workflow automation, leveraging <a href=\"https:\/\/powergi.net\/power-apps-consulting-services\/\"><strong>Microsoft PowerApps consulting services<\/strong><\/a> can be a strategic move to ensure seamless integration and efficiency.<\/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-7b0ca81 elementor-widget elementor-widget-table-of-contents\" data-id=\"7b0ca81\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings='{\"exclude_headings_by_selector\":[],\"marker_view\":\"bullets\",\"no_headings_message\":\"No headings were found on this page.\",\"headings_by_tags\":[\"h2\",\"h3\",\"h4\",\"h5\",\"h6\"],\"icon\":{\"value\":\"fas fa-circle\",\"library\":\"fa-solid\"},\"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<\/div>\n\t\t\t\t<div id=\"elementor-toc__7b0ca81\" 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-1eb54b3 elementor-widget elementor-widget-heading\" data-id=\"1eb54b3\" 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\">Column internal name <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7ffc80c elementor-widget elementor-widget-text-editor\" data-id=\"7ffc80c\" 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=\"font-weight: 400;\">Every new column we add to SharePoint gets an internal name assigned, even if we later rename this column to something different, the internal name will not change. Also, if we use SharePoint\u2019s option to import a table from Excel into a SharePoint list, the internal names that SharePoint assigns will be different from the column names it displays in our list. As a result, it\u2019s always important to check which is our column\u2019s <\/span><b>internal<\/b><span style=\"font-weight: 400;\"> name before using it for a OData filter query, because OData will always expect us to user the internal name and not the display name<\/span><\/p><p><span style=\"font-weight: 400;\">To find your columns\u2019 internal name, just go to the List settings, and then you will see your columns listed: <\/span><\/p><div id=\"seology-cta-1\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7280\" class=\"elementor elementor-7280\" 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\">Automate tasks that slow you down<\/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\">Free up your team\u2019s time and focus on strategic work with digital and robotic automation.<\/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\/de\/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>\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-5771e98 elementor-widget elementor-widget-image\" data-id=\"5771e98\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"357\" height=\"511\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-2.png\" class=\"attachment-large size-large wp-image-5695\" alt=\"List settings\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-2.png 357w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-2-210x300.png 210w\" sizes=\"(max-width: 357px) 100vw, 357px\">\t\t\t\t\t\t\t\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-519ab9c elementor-widget elementor-widget-text-editor\" data-id=\"519ab9c\" 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=\"font-weight: 400;\">Click on the column you want to know the internal name of, and the URL in the web browser will tell you the internal name of your column. <\/span><\/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-2c61906 elementor-widget elementor-widget-image\" data-id=\"2c61906\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"44\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-3-1024x44.png\" class=\"attachment-large size-large wp-image-5696\" alt=\"media (3)\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-3-1024x44.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-3-300x13.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-3-768x33.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-3-1536x65.png 1536w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-3.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-b0f1450 elementor-widget elementor-widget-heading\" data-id=\"b0f1450\" 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 Text columns <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-68dfa13 elementor-widget elementor-widget-text-editor\" data-id=\"68dfa13\" 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=\"font-weight: 400;\">Text columns are pretty straightforward and the most common queries we run against this type of column is \u201cequals to\u201d or \u201ccontains\u201d.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Find the rows that exactly match a text:\u00a0<\/span><\/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-c9d4988 elementor-widget elementor-widget-code-highlight\" data-id=\"c9d4988\" 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 \">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>{InternalColumnName} eq {text}<\/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-294d5af elementor-widget elementor-widget-image\" data-id=\"294d5af\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"113\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-5-1024x113.png\" class=\"attachment-large size-large wp-image-5697\" alt=\"Text column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-5-1024x113.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-5-300x33.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-5-768x85.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-5.png 1151w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-f30c84e elementor-widget elementor-widget-text-editor\" data-id=\"f30c84e\" 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=\"font-weight: 400;\">Find the rows that contains certain text:\u00a0<\/span><\/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-6a01915 elementor-widget elementor-widget-code-highlight\" data-id=\"6a01915\" 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>Substringof({text},{InternalColumnName})\u00a0<\/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-a842acc elementor-widget elementor-widget-image\" data-id=\"a842acc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"149\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-6-1024x149.png\" class=\"attachment-large size-large wp-image-5698\" alt=\"Filter Query Text column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-6-1024x149.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-6-300x44.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-6-768x111.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-6.png 1185w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-161f2f2 elementor-widget elementor-widget-text-editor\" data-id=\"161f2f2\" 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=\"font-weight: 400;\">Make sure your search text has some single quotes for the filter to work properly.<\/span><\/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-39b0fb7 elementor-widget elementor-widget-heading\" data-id=\"39b0fb7\" 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\"><span style=\"font-family: var( --e-global-typography-primary-font-family ), Poppins;font-size: 2rem;font-weight: var( --e-global-typography-primary-font-weight );background-color: var(--ast-global-color-5)\">Filter <\/span>Number columns<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a285ea elementor-widget elementor-widget-text-editor\" data-id=\"9a285ea\" 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=\"font-weight: 400;\">For number columns there is a wider range of common conditions, such as \u201cequals\u201d, \u201cgreater than\u201d, \u201cbetween\u201d.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">The \u201cequals\u201d to logic works exactly as the text one, you just need to write\u00a0<\/span><\/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-faea5ac elementor-widget elementor-widget-code-highlight\" data-id=\"faea5ac\" 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>{InternalColumnName} eq {number}<\/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-cee634d elementor-widget elementor-widget-image\" data-id=\"cee634d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"147\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-7-1024x147.png\" class=\"attachment-large size-large wp-image-5699\" alt=\"Filter Query Number Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-7-1024x147.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-7-300x43.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-7-768x110.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-7.png 1166w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-81f7ede elementor-widget elementor-widget-text-editor\" data-id=\"81f7ede\" 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=\"font-weight: 400;\">For <\/span><b>greater than<\/b><span style=\"font-weight: 400;\"> or <\/span><b>less than<\/b><span style=\"font-weight: 400;\">, just replace \u201ceq\u201d by \u201cgt\u201d or \u201clt\u201d<\/span><\/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-270db8b elementor-widget elementor-widget-image\" data-id=\"270db8b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"100\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-8-1024x100.png\" class=\"attachment-large size-large wp-image-5700\" alt=\"Number Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-8-1024x100.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-8-300x29.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-8-768x75.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-8.png 1167w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-52ab102 elementor-widget elementor-widget-image\" data-id=\"52ab102\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"135\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-9-1024x135.png\" class=\"attachment-large size-large wp-image-5701\" alt=\"Filter Query Price Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-9-1024x135.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-9-300x39.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-9-768x101.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-9.png 1141w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-15e1dfc elementor-widget elementor-widget-text-editor\" data-id=\"15e1dfc\" 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=\"font-weight: 400;\">For <\/span><b>greater than or equals to<\/b><span style=\"font-weight: 400;\"> and less than or equals to, just replace \u201ceq\u201d by \u201cge\u201d or \u201cle\u201d<\/span><\/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-3db7ee0 elementor-widget elementor-widget-image\" data-id=\"3db7ee0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"119\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-10-1024x119.png\" class=\"attachment-large size-large wp-image-5702\" alt=\"Number Column Filter Query\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-10-1024x119.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-10-300x35.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-10-768x89.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-10.png 1147w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-90889f1 elementor-widget elementor-widget-image\" data-id=\"90889f1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"121\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-11-1024x121.png\" class=\"attachment-large size-large wp-image-5703\" alt=\"Filter Query Price le Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-11-1024x121.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-11-300x36.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-11-768x91.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-11.png 1157w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-0444836 elementor-widget elementor-widget-text-editor\" data-id=\"0444836\" 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=\"font-weight: 400;\">To find rows between two values (inclusive), use the following structure:\u00a0<\/span><\/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-c3a2ba2 elementor-widget elementor-widget-code-highlight\" data-id=\"c3a2ba2\" 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>{InternalColumnName} ge {number} and {InternalColumnName} le {number}<\/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-652a3b7 elementor-widget elementor-widget-image\" data-id=\"652a3b7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"107\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-12-1024x107.png\" class=\"attachment-large size-large wp-image-5704\" alt=\"Price Column Filter Query\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-12-1024x107.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-12-300x31.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-12-768x80.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-12.png 1160w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-02640db elementor-widget elementor-widget-text-editor\" data-id=\"02640db\" 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=\"font-weight: 400;\">Apply same logic of just replacing \u201cge\u201d by \u201cgt\u201d, and \u201cle\u201d by \u201clt\u201d if you want to exclude the numbers in the condition. <\/span><\/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-c0a6300 elementor-widget elementor-widget-image\" data-id=\"c0a6300\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"121\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-13-1-1024x121.png\" class=\"attachment-large size-large wp-image-5705\" alt=\"Filter Query Price gt Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-13-1-1024x121.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-13-1-300x35.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-13-1-768x91.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-13-1.png 1153w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-39bf35a elementor-widget elementor-widget-heading\" data-id=\"39bf35a\" 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\"><span style=\"font-family: var( --e-global-typography-primary-font-family ), Poppins;font-size: 2rem;font-weight: var( --e-global-typography-primary-font-weight );background-color: var(--ast-global-color-5)\">Filter <\/span>Date columns<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4313ebb elementor-widget elementor-widget-text-editor\" data-id=\"4313ebb\" 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=\"font-weight: 400;\">Logic for date columns is really similar to what we have seen so far, we can find rows with dates greater than today, or less than today, or in between ranges \u2013 and will use the same operators (gt, lt, ge, le, eq). The query structure will be the same, what will change is the value we send in the query: it\u2019s a good idea to format your query dates in <\/span><b>yyyy-MM-dd<\/b><span style=\"font-weight: 400;\"> pattern, to make sure the filter is applied correctly.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">If your filter will include a timestamp, the format <\/span><b>yyyy-MM-ddThh:mm:ss<\/b><span style=\"font-weight: 400;\"> is recommended.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Some examples below: <\/span><\/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-ad7832d elementor-widget elementor-widget-image\" data-id=\"ad7832d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"97\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-14-1-1024x97.png\" class=\"attachment-large size-large wp-image-5706\" alt=\"Date column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-14-1-1024x97.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-14-1-300x29.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-14-1-768x73.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-14-1.png 1145w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-a2dfba2 elementor-widget elementor-widget-image\" data-id=\"a2dfba2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"101\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-15-1-1024x101.png\" class=\"attachment-large size-large wp-image-5707\" alt=\"Filter Query Date column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-15-1-1024x101.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-15-1-300x30.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-15-1-768x76.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-15-1.png 1152w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-4a7c1d0 elementor-widget elementor-widget-image\" data-id=\"4a7c1d0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"133\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-16-1-1024x133.png\" class=\"attachment-large size-large wp-image-5708\" alt=\"Date column Filter Query\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-16-1-1024x133.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-16-1-300x39.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-16-1-768x100.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-16-1.png 1153w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-88fccb4 elementor-widget elementor-widget-text-editor\" data-id=\"88fccb4\" 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=\"font-weight: 400;\">Make sure your search date has some single quotes for the filter to work properly.<\/span><\/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-d94e1fb elementor-widget elementor-widget-heading\" data-id=\"d94e1fb\" 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\"><span style=\"font-family: var( --e-global-typography-primary-font-family ), Poppins;font-size: 2rem;font-weight: var( --e-global-typography-primary-font-weight );background-color: var(--ast-global-color-5)\">Filter <\/span>Choice columns<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7152201 elementor-widget elementor-widget-text-editor\" data-id=\"7152201\" 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=\"font-weight: 400;\">Even if choice columns are not text columns, they work the same way as text columns, we just need to indicate the column name, the operator and the text we\u2019re looking for.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">For example, to find rows where color = Silver: <\/span><\/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-217cec4 elementor-widget elementor-widget-image\" data-id=\"217cec4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"127\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-17-1-1024x127.png\" class=\"attachment-large size-large wp-image-5709\" alt=\"Color Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-17-1-1024x127.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-17-1-300x37.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-17-1-768x95.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-17-1.png 1154w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-d06bdad elementor-widget elementor-widget-text-editor\" data-id=\"d06bdad\" 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=\"font-weight: 400;\">Make sure your search text has some single quotes for the filter to work properly.<\/span><\/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-28b601c elementor-widget elementor-widget-heading\" data-id=\"28b601c\" 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\"><span style=\"font-family: var( --e-global-typography-primary-font-family ), Poppins;font-size: 2rem;font-weight: var( --e-global-typography-primary-font-weight );background-color: var(--ast-global-color-5)\">Filter <\/span>Multiple Choice columns <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-20a29e9 elementor-widget elementor-widget-text-editor\" data-id=\"20a29e9\" 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=\"font-weight: 400;\">Since multiple choice columns can contain multiple selections, but we can apply either the \u201cequals\u201d logic or the \u201ccontains\u201d logic presented previously.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Below examples shows how to find records for which color \u201cSilver\u201d has been selected under the \u201cColors\u201d column. <\/span><\/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-2998ac8 elementor-widget elementor-widget-image\" data-id=\"2998ac8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"122\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-18-1-1024x122.png\" class=\"attachment-large size-large wp-image-5710\" alt=\"Filter Query Color Column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-18-1-1024x122.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-18-1-300x36.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-18-1-768x92.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-18-1.png 1149w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-1c2a070 elementor-widget elementor-widget-code-highlight\" data-id=\"1c2a070\" 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>{InternalColumnName} eq {textChoice}<\/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-af34b1a elementor-widget elementor-widget-image\" data-id=\"af34b1a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"115\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-19-1-1024x115.png\" class=\"attachment-large size-large wp-image-5711\" alt=\"Color Column Filter Query\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-19-1-1024x115.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-19-1-300x34.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-19-1-768x86.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-19-1.png 1160w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-b4c26c8 elementor-widget elementor-widget-code-highlight\" data-id=\"b4c26c8\" 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>Substringof({textChoice},{InternalColumnName})\u00a0<\/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-610ad58 elementor-widget elementor-widget-heading\" data-id=\"610ad58\" 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\"><span style=\"font-family: var( --e-global-typography-primary-font-family ), Poppins;font-size: 2rem;font-weight: var( --e-global-typography-primary-font-weight );background-color: var(--ast-global-color-5)\">Filter <\/span>Lookup columns <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9e08cdd elementor-widget elementor-widget-text-editor\" data-id=\"9e08cdd\" 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=\"font-weight: 400;\">For lookup columns we need to apply \u201cequals\u201d logic (eq operator). The only difference is that we need to add some additional parts to our query, depending on if we will search by <a href=\"https:\/\/powergi.net\/blog\/lookup-function-in-power-apps\/\"><strong>lookup<\/strong><\/a> value or by lookup id.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">If we are searching by lookup value:\u00a0<\/span><\/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-f2000ba elementor-widget elementor-widget-code-highlight\" data-id=\"f2000ba\" 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>{InternalColumnName}\/Title eq {text}<\/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-8ef280d elementor-widget elementor-widget-image\" data-id=\"8ef280d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"143\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-20-1-1024x143.png\" class=\"attachment-large size-large wp-image-5712\" alt=\"Lookup columns\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-20-1-1024x143.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-20-1-300x42.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-20-1-768x108.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-20-1.png 1150w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-d1d9c16 elementor-widget elementor-widget-text-editor\" data-id=\"d1d9c16\" 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=\"font-weight: 400;\">If we are searching by lookup id:\u00a0<\/span><\/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-3b377a1 elementor-widget elementor-widget-code-highlight\" data-id=\"3b377a1\" 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>{InternalColumnName}\/Id eq {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-3e0e227 elementor-widget elementor-widget-image\" data-id=\"3e0e227\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"125\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-21-1-1024x125.png\" class=\"attachment-large size-large wp-image-5713\" alt=\"Filter Query Lookup columns\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-21-1-1024x125.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-21-1-300x37.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-21-1-768x94.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-21-1.png 1152w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-b611ad8 elementor-widget elementor-widget-heading\" data-id=\"b611ad8\" 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\"><span style=\"font-family: var( --e-global-typography-primary-font-family ), Poppins;font-size: 2rem;font-weight: var( --e-global-typography-primary-font-weight );background-color: var(--ast-global-color-5)\">Filter <\/span>Multiple Choice columns <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9da0808 elementor-widget elementor-widget-text-editor\" data-id=\"9da0808\" 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=\"font-weight: 400;\">When trying filtering by Multiple Choice columns, what worked for us was just using the Title\/Lookup value or using the \u201csubstringof\u201d operator.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">This is column looks: <\/span><\/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-70bcf5f elementor-widget elementor-widget-image\" data-id=\"70bcf5f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"194\" height=\"223\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-22-1.png\" class=\"attachment-large size-large wp-image-5714\" alt=\"Multiple Choice column\">\t\t\t\t\t\t\t\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-1fde969 elementor-widget elementor-widget-text-editor\" data-id=\"1fde969\" 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=\"font-weight: 400;\">In the two following examples we are trying to find records in <\/span><a href=\"https:\/\/powergi.net\/blog\/power-automate-upload-file-to-sharepoint\/\"><b>SharePoint<\/b><\/a><span style=\"font-weight: 400;\"> where the machine type \u201cAt Home Coffee Makers\u201d was selected in a multiple lookup column<\/span><\/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-a2602d1 elementor-widget elementor-widget-image\" data-id=\"a2602d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"111\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-23-1-1024x111.png\" class=\"attachment-large size-large wp-image-5715\" alt=\"Multiple Choice columns\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-23-1-1024x111.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-23-1-300x33.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-23-1-768x83.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-23-1.png 1159w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-2f23b29 elementor-widget elementor-widget-image\" data-id=\"2f23b29\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"133\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-24-1-1024x133.png\" class=\"attachment-large size-large wp-image-5716\" alt=\"Filter Query Multiple Choice columns\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-24-1-1024x133.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-24-1-300x39.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-24-1-768x100.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-24-1.png 1154w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-8a49dd5 elementor-widget elementor-widget-heading\" data-id=\"8a49dd5\" 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\"><span style=\"font-family: var( --e-global-typography-primary-font-family ), Poppins;font-size: 2rem;font-weight: var( --e-global-typography-primary-font-weight );background-color: var(--ast-global-color-5)\">Filter <\/span>User columns<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fa28aac elementor-widget elementor-widget-text-editor\" data-id=\"fa28aac\" 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=\"font-weight: 400;\">For User type columns, a similar logic to what we have seen so far applies. We will need to use the \u201cequals\u201d operator and combine it with the email attribute contained in the user object.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Query structure will be like this:\u00a0<\/span><\/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-1c7be33 elementor-widget elementor-widget-code-highlight\" data-id=\"1c7be33\" 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>{InternalColumnName}\/EMail eq {useremail}<\/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-bd971fe elementor-widget elementor-widget-image\" data-id=\"bd971fe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"129\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-25-1-1024x129.png\" class=\"attachment-large size-large wp-image-5717\" alt=\"User columns\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-25-1-1024x129.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-25-1-300x38.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-25-1-768x97.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-25-1.png 1161w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-ad87339 elementor-widget elementor-widget-text-editor\" data-id=\"ad87339\" 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=\"font-weight: 400;\">Please note that both the E and the M are upper case. <\/span><\/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-571bb98 elementor-widget elementor-widget-heading\" data-id=\"571bb98\" 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 Multiple user columns <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8888d1 elementor-widget elementor-widget-text-editor\" data-id=\"a8888d1\" 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=\"font-weight: 400;\">Even if we are working with a multiple user selection column, the query filter will work exactly as the single selection user.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">This is how our column looks: <\/span><\/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\/de\/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>\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-e30f134 elementor-widget elementor-widget-image\" data-id=\"e30f134\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"315\" height=\"172\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-26-1.png\" class=\"attachment-large size-large wp-image-5718\" alt=\"Multiple user column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-26-1.png 315w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-26-1-300x164.png 300w\" sizes=\"(max-width: 315px) 100vw, 315px\">\t\t\t\t\t\t\t\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-1341462 elementor-widget elementor-widget-text-editor\" data-id=\"1341462\" 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=\"font-weight: 400;\">This is the filter to find any row where user is selected: <\/span><\/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-20a3f08 elementor-widget elementor-widget-image\" data-id=\"20a3f08\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"131\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-27-1-1024x131.png\" class=\"attachment-large size-large wp-image-5719\" alt=\"Filter Query Multiple user column\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-27-1-1024x131.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-27-1-300x38.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-27-1-768x98.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-27-1.png 1188w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-5c5dcba elementor-widget elementor-widget-code-highlight\" data-id=\"5c5dcba\" 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>{InternalColumnName}\/EMail eq {useremail}\u00a0<\/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-beeb803 elementor-widget elementor-widget-text-editor\" data-id=\"beeb803\" 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=\"font-weight: 400;\">Please note that both the E and the M are upper case.\u00a0<\/span><\/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-764ef6d elementor-widget elementor-widget-heading\" data-id=\"764ef6d\" 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\"><span style=\"font-family: var( --e-global-typography-primary-font-family ), Poppins;font-size: 2rem;font-weight: var( --e-global-typography-primary-font-weight );background-color: var(--ast-global-color-5)\">Filter <\/span>Calculated columns <\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7fd4d03 elementor-widget elementor-widget-text-editor\" data-id=\"7fd4d03\" 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=\"font-weight: 400;\">You can\u2019t apply OData query filters on calculated columns. The SharePoint action will throw an error. <\/span><\/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-80d62e3 elementor-widget elementor-widget-heading\" data-id=\"80d62e3\" 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\">Combining filters and different columns<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6dce5ec elementor-widget elementor-widget-text-editor\" data-id=\"6dce5ec\" 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=\"font-weight: 400;\">You can use \u201cand\u201d, \u201cor\u201d and parenthesis in your queries to combine different conditions, just make sure you write the column name in all conditions.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Note: the Excel connector only allows one filter at a time (no and\/or allowed).\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Some examples of combined conditions: <\/span><\/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-9f96e58 elementor-widget elementor-widget-image\" data-id=\"9f96e58\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"141\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-28-1-1024x141.png\" class=\"attachment-large size-large wp-image-5720\" alt=\"Combining filters\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-28-1-1024x141.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-28-1-300x41.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-28-1-768x106.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-28-1.png 1152w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-3d4359f elementor-widget elementor-widget-image\" data-id=\"3d4359f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"111\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-29-1-1024x111.png\" class=\"attachment-large size-large wp-image-5721\" alt=\"Combining Filters Query\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-29-1-1024x111.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-29-1-300x33.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-29-1-768x83.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-29-1.png 1151w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-e7cb651 elementor-widget elementor-widget-heading\" data-id=\"e7cb651\" 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\">Pagination<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ff512f2 elementor-widget elementor-widget-text-editor\" data-id=\"ff512f2\" 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=\"font-weight: 400;\">It\u2019s important to know that the SharePoint connector in <\/span><a href=\"https:\/\/powergi.net\/blog\/use-mysql-views-from-power-automate-app-services\/\"><b>Microsoft Power Automate<\/b><\/a><span style=\"font-weight: 400;\"> by default will limit the number of rows it returns, it may be that the query results have 500 records but Power Automate will only list 100 records, because of the default limits.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">To avoid this issue when retrieving rows from SharePoint, use the ellipsis in the top right corner of the \u201cGet items\u201d action and click on Settings. <\/span><\/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-8a3c515 elementor-widget elementor-widget-image\" data-id=\"8a3c515\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"380\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-30-1-1024x380.png\" class=\"attachment-large size-large wp-image-5722\" alt=\"\u201cGet items\u201d action\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-30-1-1024x380.png 1024w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-30-1-300x111.png 300w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-30-1-768x285.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-30-1.png 1109w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\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-45ddd55 elementor-widget elementor-widget-text-editor\" data-id=\"45ddd55\" 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=\"font-weight: 400;\">In the next screen of, just turn on the pagination feature and set a maximum number of rows to retrieve (max value can be 10,000). And finally hit on Done. <\/span><\/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-34ad0f9 elementor-widget elementor-widget-image\" data-id=\"34ad0f9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"1024\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-31-1-652x1024.png\" class=\"attachment-large size-large wp-image-5723\" alt=\"Settings for \u201cGet Items\u201d\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-31-1-652x1024.png 652w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-31-1-191x300.png 191w, https:\/\/powergi.net\/wp-content\/uploads\/2024\/05\/media-31-1.png 704w\" sizes=\"(max-width: 652px) 100vw, 652px\">\t\t\t\t\t\t\t\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-f86b1d6 elementor-widget elementor-widget-text-editor\" data-id=\"f86b1d6\" 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>For businesses aiming to elevate their automation efforts, turning to <a href=\"https:\/\/powergi.net\/microsoft-power-platform-consulting-services\/\"><strong>Microsoft Power Platform consulting services<\/strong><\/a> is crucial. With our expertise, we streamline workflows, ensuring optimal use of tools like Power Automate to connect and manage SharePoint data efficiently.<\/p><p><span style=\"font-style: inherit; font-weight: inherit;\">Understanding column types and the related query structures is important. Remember, internal column names are key, and combining filters allows you to perform detailed searches.<\/span><\/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<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>When working with Power Automate and SharePoint lists we usually are in need of extracting specific rows of data from lists, to do so, we need to use the \u201cQuery filter\u201d field available in the SharePoint \u201cGet Items\u201d action. OData queries are usually written in the following format:\u00a0 {InternalColumnName} operator {value}\u00a0 For example, if we [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":5690,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","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":[25,118],"tags":[143,133,19,120],"class_list":["post-5689","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-query-cat","category-sharepoint-cat","tag-power","tag-power-automate-desktop-app-services","tag-power-query","tag-sharepoint"],"glossary_letter":null,"rank_math_title":"OData Query Filter | Power Automate | SharePoint | Power GI","rank_math_description":"Learn how to use Power Automate's \"OData query filter\" feature to filter different data typesand files from SharePoint lists and libraries. ","rank_math_focus_keyword":"odata query filter","_links":{"self":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts\/5689","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/comments?post=5689"}],"version-history":[{"count":0,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts\/5689\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/media\/5690"}],"wp:attachment":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/media?parent=5689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/categories?post=5689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/tags?post=5689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}