I want to set up a document library View that shows the current user all items with their Department name in a column, as well as those items that don't yet have a Department name. I thought I could do this with the User Filter web part, but I am struggeling
to show the items that don't yet have a department name.
The problem I have is this: I created a view called "My department's items". I use the User Filter web part on it to show the user all items that have got the user's department name in a column.
However, when a user forgets to fill out the department name after uploading a file, or even when they upload the file but then cancel filling out the compulsory fields, the uploaded file disappears from the "My department's items" view (because the
department column is empty).
How can I set up a filter to show all files that match the current user's department name as well as those that don't have a department name yet?
View Complete Post