locked
Cascading drop-down from spreadsheet RRS feed

  • Question

  • Hello,

    I need some assistance, I am creating a SP but I need to do a look up or cascading drop down using information from a spreadsheet from InfoPath.

    Can anyone guide me? All I can find info about is for cascading from a list, but it is a spread sheet

    Any tutorial or forum?

    Thanks,

    Thursday, October 30, 2014 5:54 PM

Answers

  • Hello,

    If you are talking about list datasheet view then unfortunately datasheet view does not supports cascading DDL. I am not aware about any third party tool or solution for datasheet view. Personally i modify the list form in infopath or apply jquery in such kind of requirement.


    Hemendra:Yesterday is just a memory,Tomorrow we may never see<br/> Please remember to mark the replies as answers if they help and unmark them if they provide no help

    • Marked as answer by JasonGuo Saturday, November 8, 2014 2:42 PM
    Friday, October 31, 2014 6:02 AM

All replies

  • Hello,

    If you are talking about list datasheet view then unfortunately datasheet view does not supports cascading DDL. I am not aware about any third party tool or solution for datasheet view. Personally i modify the list form in infopath or apply jquery in such kind of requirement.


    Hemendra:Yesterday is just a memory,Tomorrow we may never see<br/> Please remember to mark the replies as answers if they help and unmark them if they provide no help

    • Marked as answer by JasonGuo Saturday, November 8, 2014 2:42 PM
    Friday, October 31, 2014 6:02 AM
  • Hi,

    In addition to Hemendra’s suggestion, you can take a look at the link below about how to access Excel file which stores in a SharePoint Library using Excel Web Service with jQuery:

    http://martinezdeveloper.blogspot.jp/2011/07/sharepoint-2010-excel-rest-api-and.html

    Best regards,

    Patrick

    Patrick Liang
    TechNet Community Support

    Friday, November 7, 2014 9:33 AM