29K+ in excel file doesnt work in SharePoint - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

29K+ in excel file doesnt work in SharePoint

Last post 12-05-2019 09:59 AM by Ruenells. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 12-05-2019 08:12 AM

    29K+ in excel file doesnt work in SharePoint

    I have a large list that I need to create an XML from so that I can use it in a dropdown in my form. I do not know how to do this and hoping someone can point me in the right direction. Dorinda
  • 12-05-2019 09:50 AM In reply to

    Re: 29K+ in excel file doesnt work in SharePoint

    This is not a good plan, I'm afraid. I think a 29,000 row XML file will make your form very large, and that a dropdown with 29,000 options would be unwieldy for users. I think instead you need to consider ways you might structure this data in a SharePoint list that would allow you to offer some filtering. Not knowing what this data is, I can only suggest some guesses - but perhaps you could categorize these entries, and give the user a "Category" dropdown first, with limited options, then filter the query for the "Very Large List" data based on the selected Category. Even if you stuck a column in SharePoint for the first letter of the option and let the user initially select from A - Z to narrow down the data returned to the dropdown, it would help.
    Hilary Stoupa

  • 12-05-2019 09:59 AM In reply to

    Re: 29K+ in excel file doesnt work in SharePoint

    Yes I am working on that next. Just finally figured out how to do an XML file yeah me!! Thanks again Dorinda
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.