Showing results for 
Search instead for 
Did you mean: 

Allow NOT IN searches in advanced find, marketing lists etc

Author Name: Peter Hörnell

A very common request from customers is to find records WITHOUT a certain related record. Today I need to make a custom report for that. I think it would be great to be able to create views etc based on NOT IN statements in an advanced find. That could easily be used for customers to set up even more dynamics marketing lists too.

Status: Completed

Thank you for your feedback. This is a great suggestion! We will consider this in our roadmap.



Neeraj Nandwana

PM, Microsoft 

Regular Visitor

I'm new here but I'm really surprised. Why none of the ideas, like this, that are massively supported by the community is either in development or planned even in the long term???

Super User

Hi everyone.


I am sure the team at Microsoft has a long list of these items to get to. In the meantime, see below videos that could help some I hope.

SQL Queries from PowerApps and Flow:


Filter SharePoint data using ODATA and Flow


Dawid van Heerden
Follow on Twitter: @davestechtips
Subscribe to YouTube: