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 null).

However, I’m running into some challenges:

I don’t want to make these fields required.I know that Power Automate could be used to address this, but I’m looking for a solution directly within SharePoint.I tried creating a custom view, but the filter options for Text and Image columns are limited to “contains” or “begins with.” Using “starts with” or “contains” with a blank or zero value didn’t work.I also attempted creating a calculated column to check if the Text column is filled, but calculated columns don’t seem to work with Text or Image columns.

Does anyone have any suggestions or workarounds that might help?

Thanks in advance!

​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 null).However, I’m running into some challenges:I don’t want to make these fields required.I know that Power Automate could be used to address this, but I’m looking for a solution directly within SharePoint.I tried creating a custom view, but the filter options for Text and Image columns are limited to “contains” or “begins with.” Using “starts with” or “contains” with a blank or zero value didn’t work.I also attempted creating a calculated column to check if the Text column is filled, but calculated columns don’t seem to work with Text or Image columns.Does anyone have any suggestions or workarounds that might help?Thanks in advance!  Read More

​