Sharepoint REST set ShowInEditForm

By fredericdietrich On 28/11/2019

With this script you can Show / hide your field in standard sharepoint forms

ShowInDisplayForm

ShowInEditForm

ShowInNewForm

var xhr = new XMLHttpRequest();

var url = _spPageContextInfo.webAbsoluteUrl;

if (url === "undefined {

console.log("_spPageContextInfo.webAbsoluteUrl undefined");

url = "http://siteUrl;

}

xhr.open('POST', url + "/_api/web/Lists(guid'bec2b6d5-3183-4bd7-87a5-0989610b2e25')/Fields(guid'341eeecb-e5ff-447c-9cd0-84c9f00c80c6')/setShowInEditForm(true)");

xhr.setRequestHeader("Accept", "application/json; odata=verbose");

xhr.setRequestHeader("X-RequestDigest", document.getElementById("__REQUESTDIGEST").value;

xhr.setRequestHeader("X-HTTP-Method", "MERGE");

xhr.setRequestHeader("If-Match", "*");

xhr.onload = function () {

if (xhr.status === 200) {

var kk = JSON.parse(xhr.responseText);

console.dir(kk);

}

else {

console.dir(xhr);

alert('Request failed. Returned status of ' + xhr.status);

}

};

xhr.send();

see script in mode text here

Sharepoint REST

In Power plateform

PowerAutomate Add Folder

By fredericdietrich On 10/02/2023

Powerautomate get folder by url


/_api/web/GetFolderByServerRelativeUrl('@{variables('WebserverRelativeUrl')}/@{variables('DoclibUrl')}/Fiche_@{variables('FicheId')}')
Verify status (exists = 200, does not exists = 404)


@{outputs('HttpGetFolder')['statusCode']}

Create folder


/_api/web/folders/add('@{variables('DoclibUrl')}/Fiche_@{variables('FicheId')}')

Createfolder

In javascript

How to resolve the 5000 item limit

By fredericdietrich On 24/01/2022

     var firstItems = listLocation.web.getList(listLocation.listUri).items.select("ID").top(1).orderBy("Id").get();
     var lastItems = listLocation.web.getList(listLocation.listUri).items.select("ID").top(1).orderBy("Id", false).get(); 

    if (firstItems.length === 1 && lastItems.length === 1) {
      const firstId: number = firstItems[0].ID;
      const lastId: number = lastItems[0].ID;
      let startId = firstId;
      let endId = firstId + 5000;
      do {
        let mySites: ISite[] = await listLocation.web.getList(listLocation.listUri).items

          .select("ID", "Title", "Url")
          .filter(`Id ge ${startId} and Id lt ${endId} and ProprietairesPeople/Id eq ${userId}`)
          .expand('ProprietairesPeople')
          .orderBy("Title")
          .top(5000)
          .getAll(); 

          allMySites.push(...mySites);
          startId = startId + 5000;
          endId = endId + 5000;
      }
      while (endId < lastId);
    }
    return allMySites;