List view not showing all items using filter

In your SharePoint list, you have column where you want to filter content from in a list view. You create a new view and try to filter content from this column but nothing appear. Even you add column to view. However, this column show content in all items and you can sort the content and filter content using metadata navigation. You also make sure that your filter is defined properly. First this is to do is to try to see the query in SharePoint designer in list view but that doesn’t help.

The only solution is to create a new column with new name, move all content to this column, then recreate the buggy column, and move content back. Then delete the temporary column.

Only problem is when you move content your item get new version and may be workflow also run. The safe way is to disableeventfiring and disable updating the item. In addition, just preform an update to these columns. Here is PowerShell script help you move content from one column to another without having item update. When content is moved, change the column names and move content back.

So you run this script twice. Once when you move form buggy column second you move from temporary column to original column. Make sure you change column names.

Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue

$myAss = [Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”);

$type = $myAss.GetType(“Microsoft.SharePoint.SPEventManager”);

$prop = $type.GetProperty([string]”EventFiringDisabled”,[System.Reflection.BindingFlags] ([System.Reflection.BindingFlags]::NonPublic -bor [System.Reflection.BindingFlags]::Static));

$prop.SetValue($null, $true, $null);

$listName = “ListName

$web = Get-SPWeb http://sitecollection

$list = $web.Lists[$listName]

$items = $list.items

foreach($item in $items) { $user = $item[“Lastname“]

$item[“Lastname2“] = $user


$prop.SetValue($null, $false, $null);


Good luck.

SharePoint set blank value to date column in SharePoint designer workflow (1/1/1900 to empty/null)

If you have a date list column and using SharePoint designer workflow add empty string or empty datestring, you get a date of 1/1/1900. Sometime you want to add blank value to this value and using SharePoint designer workflow. You have no solution either you add extract querystring or use any other designer action. However, there is one easy solution to use:

  • Start SharePoint designer and go to the workflow – edit workflow.
  • In SharePoint, list settings, change date column to single line of text.
  • Update SharePoint designer and add a string variable.
  • Now add action update list item and choose value as empty string – workflow variables. Suppose your workflow run on item change or manual.
  • Publish your workflow.
  • Change column to date again in list settings.
  • Now you will get empty date when workflow determine.

SharePoint alert you that you will lost data during changing column from date to text field. But that did not happened to me. You do this operation on your own responsibility.

Visning basert på arbeidsflyt-status

Ønsker du å filtrere innhold i en en visning basert på arbeidsflyter og deres status?
Du kan filtrere data i visningen ved å bruke disse verdier i filtret for arbeidsflyten:

NotStarted = 0  FailedOnStart = 1  InProgress = 2  ErrorOccurred = 3

StoppedByUser = 4  Completed = 5 FailedOnStartRetrying = 6

ErrorOccurredRetrying = 7  ViewQueryOverflow = 8  Max = 15

Canceled = 15  Approved = 0×10 (16)  Rejected = 0×11 (17)