Tuesday, 29 January 2019

SP Services: How to populate a dropdown box with unique values from a SharePoint list column?


<script language="javascript" type="text/javascript">
$( document ).ready(function(){
loadFunction();
})

function loadFunction()
{
$().SPServices({
    operation: "GetListItems",
    async: false,
    listName: "List Name",
    CAMLViewFields: "<ViewFields><FieldRef Name='Title' /></ViewFields>",
    CAMLQuery: "<Query><Where><Neq><FieldRef Name='ID' /><Value Type='Counter'>0</Value></Neq></Where><OrderBy><FieldRef Name='Title' Ascending='True' /></OrderBy></Query>",
    completefunc: function (xData, Status) {
      $(xData.responseXML).SPFilterNode("z:row").each(function() {
      var opTitle = $(this).attr("ows_Title");
      var opOption = "<option value="+opTitle+">" + opTitle + "</option>"
        $("select.opselector").append(opOption);
      });
    }
  });

 //Remove duplicate values
  $(".opselector option").val(function(idx, val) {
  $(this).siblings('[value="'+ val +'"]').remove();
  });

}

//Get selected text
function getOP()
{
    alert($(".opselector option:selected").html());
}

</script>

<body>
<select class="opselector" onchange="getOP();"></select>
</body>

No comments:

Post a Comment