Out of box list filter not working for people and group column in SharePoint online in Modern view

Copper Contributor

Hi,

 

I am using the SharePoint Out-of-box list view web part on Sharepoint Modern Page,

 

Whenever I filter for people and group columns If any row has an empty value for that column. Filter panel not opening for that column.

 

Please find the below screenshot for reference.

 

DJoshi2302_0-1688123638146.png

 

-------------------------------------------------

DJoshi2302_1-1688123689875.png

 

Thanks in advance

 

 

 

 

 

2 Replies

@DJoshi2302 Seems to be issue in people picker column filter. 

Try below.

 

Edit the view > go to filter section . > Apply filter as column name = empty

Go to view and see filter by column . Now it will show Empty > Now try to search with any valid name and apply. 

KotiReddy_0-1688480264295.png

Now remove the filter by edit view. 

From now on the filter should show empty .

Or try clear cache once if above trick not works.

 

 

@KotiReddy 

That does not work. Anyone have a solution to this that does not require a PowerApp solution? Something directly on the list itself to filter people fields that are empty? Very frustrating Microsoft!!