SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to retrieve values from a lookup column (pull down) using SPServices() and load an array in javascript. This is available only in Newform.aspx. How can I do this?

share|improve this question

Instead of looking at it as pulling values from a lookup column, pull values from the list the lookup column is referencing.

here's a quick example of pulling out records and loading a drop down list

    operation: "GetListItems",
    listName: "Business Types",
    async: false,
    CAMLViewFields: "<ViewFields><FieldRef Name='ID'/><FieldRef Name='Title'/><FieldRef Name='RequiredDocuments'/></ViewFields>",
    CAMLQuery: "<Query><Where><Eq><FieldRef Name='ParentType' /><Value Type='Choice'>" + bizType + "</Value></Eq></Where></Query>",
    completefunc: function (xData, Status) {
        var tmp = "";
        var subTypes = $("#ddlBusinessSubtype");
        subTypes.find("option").remove(); //clear out the existing ones if they exist

        $(xData.responseXML).find("[nodeName='z:row']").each(function () {
            subTypes.append("<option value='" + $(this).attr("ows_ID") + "'>" + $(this).attr("ows_Title") + "</option>");



share|improve this answer
I will try that .. thanks – Arun Nov 2 '11 at 13:37
i Tried this but it is not working .. What is the BIZ TYPE??? in the query field??.. Can you please let me know.. I do have the same requirement. – sandy143 Jan 28 '14 at 13:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.