Convert a single line textfield to a dropdown with External list

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

Viewing 1 reply thread
  • Author
    Posts
    • August 23, 2017 at 05:35 #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

      • August 30, 2017 at 21:12 #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

      • Author
        Posts
      Viewing 1 reply thread
      • You must be logged in to reply to this topic.