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

Viewing 1 reply thread
  • 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

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