SharePoint external list displays 0 results instead of actual results in sql server.

Roxx_ 1 Reputation point
2020-07-29T14:37:43.187+00:00

I have a stored procedure that takes in a windows identity to calculate how many results the user has. I am able to create an external content type with the stored procedure. However when I create an external list and add it as a web part on my SharePoint page, I get 0 results back even though I know there should be number that is not 0. Does anybody know why SharePoint is giving me 0 results? Thanks for the help!

SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,594 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Baker Kong-MSFT 3,796 Reputation points
    2020-07-30T08:08:28.33+00:00

    Hi Roxx-3623,

    Below blog shares a tutorial about how to connect to sql server based on Stored Procedure using bcs, you may take a reference:

    You may encounter permission issues after the completion of the preceding procedure. In this case you need to set the permission for the external list. Go to the SharePoint Central Admin -> Manage Service Application -> Business Data Connectivity Services and select the newly created external content type from the list to set permission.

    Best Regards,
    Baker Kong

    0 comments