Convert a single line textfield to a dropdown with External list

Forums General discussion Convert a single line textfield to a dropdown with External list

This topic contains 1 reply, has 2 voices, and was last updated by  Alexander Bautz 2 months, 3 weeks ago.

  • Author
    Posts
  • #17909

    Kapil Singh
    Participant

    Hi Alexander,

    First of all thank you for sharing incredible resource. My question is regarding on of your solution “SPJS-Lookup: Convert a single line textfield to a dropdown select based on a query”. Everything works fine when I read SharePoint (2013) native list to populate dropdown list but I need to populate dropdown list queried data from SQL table. So I create external list based of external content type switch to External list and list itself works fine for all operations but when point to this list, SPJS.QueryItems function does not return any data. This got me into thinking may be it only works with native list only? If supported, anything to be setup differently than native SharePoint list to pull data in?

    Thanks,
    Kapil

  • #17985

    Alexander Bautz
    Keymaster

    Hi,
    Sorry for the late reply. Unfortunately I don’t have an external list to test with at the moment, but I think it should work if you added a field in the list named “ID”.

    Are you able to try that?

    Alexander

You must be logged in to reply to this topic.