Blog

Hide Sharepoint Top Nav

On 30/10/2019

Add in your query string fdiedit=1 to show the top vanigation

http://yourSite/sites/test01/Pages/home.aspx?fdiedit=1

<style>

#SearchBox{

display: none;

}

#gdocSearchBox {

display: block;

}

#s4-ribbonrow{

display: none;

}

#suiteBarTop{

display: none;

}

#SearchBox{

display: none;

}

#DeltaTopNavigation .root.ms-core-listMenu-root.static {

margin-top: 10px;

}

#s4-titlerow {

margin-top: 0px;

margin-bottom: 0px;

padding-top: 0px;

padding-bottom: 1px;

height: 20px;

}

.ms-breadcrumb-top{

display: flex;

}

</style>

function showSpStandard() {//show top nav

jq("#suiteBarTop").show();

jq("#s4-ribbonrow").show();

jq("#SearchBox").show();

jq("#DeltaPageStatusBar").show();

jq("#s4-titlerow").show();

jq("#suiteBarTop").show();

jq(".root.ms-core-listMenu-root.static").show();

}

function getUrlVars() {//get query strings

var vars = {};

var parts = window.location.href.replace(/[?&]+([^=&]+)=([^&]*)/gi, function(m,key,value) {

vars[key] = value;

});

return vars;

}

function fdiShowEdit(){//if query string

var canEdit = getUrlVars()["fdiedit"];

if(canEdit == 1)

showSpStandard();

}

_spBodyOnLoadFunctionNames.push("fdiShowEdit");

</script>

You can put this script in a script editor webpart or in master page

get script

Sharepoint Rest Query List

On 21/09/2019

Query sharepoint list with REST

use this end point to query your list http://test/sites/test/_api/Web/Lists/getbytitle('vvv')/items?$select=&$filter= Title eq 'entite du ga 1'

Example : http://test01/sites/test01/_api/Web/Lists/getbytitle('Aliste')/items?$select=Title,ID,Author/Title&$expand=Author&$filter= Title eq 'entite du toto 1'

to order by : &$orderby= Employee asc

to order by : &$orderby= Employee desc

to limit number of items returned : $top 5

to use paging : $skip 5

new paging mode add in your first query &$skiptoken=Paged=TRUE in your response, you will receive next page query in odata.nextLink as below

Nextlink

/_api/Web/Lists/getbytitle(%27Initiatives%27)/items?%24skiptoken=Paged%3dTRUE%26p_ID%3d266&%24select=Title%2cID&%24orderby=ID+desc&p_ID=268&%24Top=3

expand lookup fields : $expand=city&$select=city/Id

viewfields : $select= Title, ID

filter : $filter=Title eq 'mon noeud' and ID ne 1

Numeric comparisons

String comparisons

startsWith
substringof
Eq
Ne

Date and time functions

day()
month()
year()
hour()
minute()
second()

html to query list

javascript to query list

css to query list

base html file

Full script to add in an Script Editor webpart

script without JQuery

Powershell Csom Paged Caml Query

On 18/09/2019



$list = Get-PnPList -Identity $listTitle -ThrowExceptionIfListNotFound

$ctx = Get-PnPContext
$page = $null
$pageNumber = 0;
$rowLimit = 200
Do{
    $stringBuilder = New-Object System.Text.StringBuilder
 
    $stringBuilder.Append("<View Scope='RecursiveAll'>") | Out-Null
    $stringBuilder.Append("<Query><Where></Where>")| Out-Null
    $stringBuilder.Append("<OrderBy><FieldRef Name='ID' Ascending='TRUE' /></OrderBy>")| Out-Null
    $stringBuilder.Append("</Query>")| Out-Null
    $stringBuilder.Append("<ViewFields>")| Out-Null
    $stringBuilder.Append("<FieldRef Name='ID' />")| Out-Null
    $stringBuilder.Append("<FieldRef Name='Title' />")| Out-Null
    $stringBuilder.Append("</ViewFields>")| Out-Null
    $stringBuilder.Append("<RowLimit Paged='TRUE'>$($rowLimit)</RowLimit>")| Out-Null
    $stringBuilder.Append("</View>")| Out-Null
    
    $spqQuery = New-Object Microsoft.SharePoint.Client.CamlQuery
    $spqQuery.ViewXml = $stringBuilder.ToString();
    $spqQuery.ListItemCollectionPosition = $page


    $pageNumber ++;

    $spqQuery.ViewXml = $stringBuilder.ToString();
    $itemki=$list.GetItems($spqQuery); 
    $spqQuery.ListItemCollectionPosition = $itemki.ListItemCollectionPosition

    $ctx.Load($itemki)
    $ctx.ExecuteQuery();


    Write-Host "################## PAGE " $($page.PagingInfo) " #########################"
    Write-Host "processing query results. Recs: $($itemki.Count)"

    $Counter = 0;
    foreach($item in $itemki)
    {
        Write-Host "$($item["ID"]) title pageNumber '$($pageNumber)' : $($item["Title"])"
    }

    $page = $itemki.ListItemCollectionPosition
 }   
 Until($page -eq $null)

get script

In Powershell

Add SPList With CSOM

On 15/08/2019

function AddList()

{param($url0, $title)

$context0 = New-Object Microsoft.SharePoint.Client.ClientContext($url0);

$context0.AuthenticationMode = [Microsoft.SharePoint.Client.ClientAuthenticationMode]::FormsAuthentication

$credentials0 = New-Object Microsoft.SharePoint.Client.FormsAuthenticationLoginInfo("d03305", $mypsw);

$context0.FormsAuthenticationLoginInfo = $credentials0;

[Microsoft.SharePoint.Client.Web]$web0 = $context0.Web;

$context0.Load($web0)

$context0.Load($web0.ListTemplates)

$context0.ExecuteQuery()

$template = $web0.ListTemplates | Where-Object {$_.Name -eq "Fiche de conformitÃ©"}

$template.Name

#check if list exists

$list = $null;

try

{

$list = $web0.GetList("$($web0.ServerRelativeUrl.TrimEnd("/"))/$($title)");

$context0.Load($list);

$context0.ExecuteQuery();

}

catch

{

$list = $null;

}

if($list -eq $null)

{

Write-Host "list is null"

#creation de la liste

$ListInfo = New-Object Microsoft.SharePoint.Client.ListCreationInformation

$ListInfo.Title = $title

[System.Int32]$lstId = 100#$template.ListTemplateTypeKind;

$ListInfo.TemplateType = $lstId;

$List1 = $web0.Lists.Add($ListInfo);

$List1.Description = "$($title) GED Corporate";

$List1.Update()

$context0.ExecuteQuery()

}

else

{

Write-Host "list is not null"

}

$list.Title;

$context0.Dispose();

$context0 = $null;

}

In SharepointIssue

CSOM ISSUE format-default

On 21/02/2019

format-default : The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.

$col = $oWeb.AvailableFields | Where {$_.InternalName -eq "TestCategories"}

$context.Load($listDoc.Fields);

$context.Load($col);

$context.ExecuteQuery();

$null = $listDoc.Fields.Add($col);

if $col is null because the field "TestCategories" does not exist in $oWeb.AvailableFields you've got this message

In SharepointIssue

Managed Navigation Issue

On 31/01/2019

Impossible de se connecter à la banque de termes sur la navigation par méta données gérées

Managednavissue

Désolé... Nous n'avons pas pu créer l'ensemble de termes : Aucune connexion au service de métadonnées gérées par défaut n'a été spécifiée.

Settermstoreproperties

In SharepointIssue

Sharepoint 2016 Register Javascript In Hive

On 24/01/2019

To register javascript file in 16/layouts

you should write with 15, sharepoint will translate it in 16 : <script type="text/javascript" src="/_layouts/15/testFDI/jquery.min.js"></script>

PowerShell Csom load property Issue

On 18/01/2019

Using Microsoft.SharePoint.Client.dll you can have issue after object loading

$file = $oWeb.GetFileByUrl($fileUrl);

$context.Load($file);

$context.ExecuteQuery()

$context.Load($file.ListItemAllFields)

$context.ExecuteQuery()

$file.ListItemAllFields #accessing to this property will thow exception below

format-default : The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.

so you have to store property in a variable like that

$ListItemAllFields = $file.ListItemAllFields

$context.Load($ListItemAllFields)

$context.ExecuteQuery()