Uber Service datensatze abholen

ExpoIT erstellt 10 Juni 2017 14:05

Hallo ich hab mal einen Code zusammengestellt, welche Daten aus einer SP-Liste holen und in ein <select><option>-tag eintragen soll. 

SP.SOD.executeFunc('sp.js', 'SP.ClientContext', function () {

loadSharepointList();

});

function loadSharepointList() {

var context = SP.ClientContext.get_current();

var list = context.get_web().get_lists().getByTitle('Hauptaufgaben');

var caml = new SP.CamlQuery();

caml.set_viewXml("<Query><Where><IsNotNull><FieldRef Name='Title' /></IsNotNull></Where></Query>");

var listItems = list.getItems(caml);

context.load(listItems, 'Include(Title)');

context.executeQueryAsync(

     Function.createDelegate(this, function () {

     var listEnumerator = listItems.getEnumerator();

    while (listEnumerator.moveNext()) {

     var listItem = listEnumerator.get_current();

     var fieldValue = listItem.get_item('Title');

    var list = document.getElementById("tstList");

    var option = document.createElement("option");

    option.text = fieldValue;

    list.add(option);

     return "<option'>" + fieldValue + "</option>";

    }

     }),

  Function.createDelegate(this, function () {

    alert('Error fetching data from Sharepoint!');

    }));

}