Forum Discussion
How to Filter Empty Text and Image Columns in SharePoint List?
Hi Everyone, I'm working with a SharePoint list and trying to filter out items where certain columns, specifically a Text column and an Image column, haven't been filled in (i.e., they are empty or ...
Hello Ricardoar356
you can try to use the standard highlighted content webpart, with this webpart you have more settings to filter the documents.
Or you can use the PnP Modern Search WebParts for this https://microsoft-search.github.io/pnp-modern-search/
{SearchTerms} ISDocument:1 AND ( Filetype:docx OR Filetype:pdf OR Filetype:xlsx OR Filetype:pptx) -IsContainer:1 AND (NOT(RefinableString01:*) OR NOT(RefinableString03:*) OR NOT(RefinableString04:*))
Best, Dave