Access Web App - Datasheet view do not show all filter values RRS feed

  • Question

  • Hi All,

    This is for Access web app on SharePoint server 2013.

    I have created a datasheet view having data source as custom query(Fetching data from multiple tables.) The query returns around 3000 records. However, when user try to filter the datasheet view with a particular column they do not see all records. Only a subset of records(around 500) are available for user to filter.

    Note: one of the table is created by linking to SharePoint list.

    Is there a reason? How can I get the filter having all values for the columns.

    This is critical for us. Since our application has first page as datasheet view with loads of records.

    Thanks in advance for help.


    • Moved by Patrick_Liang Wednesday, February 10, 2016 9:37 AM more like an access dev issue
    • Edited by MonaliB Tuesday, February 16, 2016 12:57 PM More info added
    Tuesday, February 9, 2016 2:04 PM

All replies

  • Hi Monali,

    As it is more like a design issue of Access Web App, I will move it to Access for Developer forum.

    Thanks for your understanding.

    Best regards,

    Patrick Liang

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact

    Wednesday, February 10, 2016 9:36 AM
  • We are doing the research about your problem. There might be some delay about the response. Appreciate your patience.
    Monday, February 15, 2016 9:46 AM
  • Hi David,

    Any update?


    Tuesday, February 16, 2016 12:49 PM