Saturday, 10 September 2016

SharePoint Online Pull values from a lookup column using SPServices()

<head>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/2014.02/jquery.SPServices.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
</head>
<script>
$(document).ready(function () {
//With out ID
$().SPServices({
operation: "GetListItems",
async: false,
listName: "Country",
CAMLViewFields: "<ViewFields><FieldRef Name='Title'/></ViewFields>",
completefunc: function (xData, Status) {
$(xData.responseXML).SPFilterNode("z:row").each(function () {
var liHtmlbi = "<option><a href='#' title=''>" + $(this).attr("ows_Title") + "</a></option>";
$("#country").append(liHtmlbi);
});
}
});
//With ID
$().SPServices({
operation: "GetListItems",
async: false,
listName: "Country",
CAMLViewFields: "<ViewFields><FieldRef Name='ID'/><FieldRef Name='Title'/></ViewFields>",
completefunc: function (xData, Status) {
$(xData.responseXML).SPFilterNode("z:row").each(function () {
var liHtmlbi = "<option value='" + $(this).attr("ows_ID") + "'>" + $(this).attr("ows_Title") + "</option>";
$("#country").append(liHtmlbi);
});
}
});
});
</script>
<body>
<table>
<tr><td>Country</td><td><select id="country" style="max-width:90%;"></select></td></tr>
</table>
</body>
view raw gistfile1.txt hosted with ❤ by GitHub