cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
enswitzer
Helper II
Helper II

Get Items Filter Query for null Note

Is there a way to get around this? I'd like to filter for anything that has a null objective field:

 

enswitzer_0-1614277954298.png

enswitzer_1-1614277996922.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
tom_riha
Super User II
Super User II

Hello @enswitzer ,

the Filter Query won't allow you to use some column types, e.g. multiple lines of text columns (as the error message says). You'll need to split the filtering into 2 parts:

  1. Filter Query in 'Get items' to check the columns that can be used in Filter Query
  2. 'Filter array' after the 'Get items', take the output array from 'Get items' and filter it again using the remaining columns


[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

1 REPLY 1
tom_riha
Super User II
Super User II

Hello @enswitzer ,

the Filter Query won't allow you to use some column types, e.g. multiple lines of text columns (as the error message says). You'll need to split the filtering into 2 parts:

  1. Filter Query in 'Get items' to check the columns that can be used in Filter Query
  2. 'Filter array' after the 'Get items', take the output array from 'Get items' and filter it again using the remaining columns


[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,355)