Regarding the SPFx webpart to extract list items from specific view in list, SharePoint 2019 on premise

SHUO .H 706

Hi there,

I refer to the document from <https://wowsomuch.com/sharepoint/pnp-js-caml-query/>. When there are 3000 List items in specific view of List, the performance is not good (Low Performance). Does anyone have any idea on it?? or other workaround to increase the performance. Thanks

1 answer

RaytheonXie_MSFT 31,606 Reputation points Microsoft Vendor

2021-12-13T02:39:12.157+00:00

Hi @SHUO .H ,
You can try to use restapi to retrieve the list items. Please refer to the following code.
https://github.com/Haiqi-Wu/SharePoint-FrameWork-Demos/tree/master/ReadSPListItems

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
SHUO .H 706 Reputation points

2021-12-13T04:55:19.48+00:00

Hi @RaytheonXie_MSFT ,

thanks for your information. before I have followed up this documentation to try the rest api. Currently I am confusing on how to extract the list item from specific list view. because maybe we have more than 5000 list items in list and I would like to use list view to filter the item beforehand for increasing the performance.

RaytheonXie_MSFT 31,606 Reputation points Microsoft Vendor

2021-12-13T06:11:35.563+00:00

Hi @SHUO .H ,
Query list with items more than 5k will over threshold. So we can use <View Scope = 'RecursiveAll'> to overcome

<View Scope='RecursiveAll'><RowLimit>5000</RowLimit></View>

You can also try by keeping indexed columns with filter views.
https://sharepointmaven.com/how-to-overcome-sharepoint-5000-item-limit-threshold/

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

SHUO .H 706 Reputation points

2021-12-13T06:17:23.517+00:00

Hi @RaytheonXie_MSFT ,

Thanks for your reply but my question is how to use pnp/sp to get the list item in specific view. for instance, I have a list view called <ABC> and there are around 3000 items inside. that means the <ABC> view has a 3000 items. how can I get all items (3000) from <ABC> view.

Thanks

RaytheonXie_MSFT 31,606 Reputation points Microsoft Vendor

2021-12-13T07:47:19.837+00:00

Hi @SHUO .H ,
You can use following code to retrieve all items

import { sp } from "@pnp/sp"; import "@pnp/sp/webs"; import "@pnp/sp/lists"; import "@pnp/sp/items"; const allItems: any[] = await sp.web.lists.getByTitle("ABC").items.getAll(); console.log(allItems.length);

Here is the document to refer
https://pnp.github.io/pnpjs/sp/items/

SHUO .H 706 Reputation points

2021-12-13T08:48:47.96+00:00

Hi @RaytheonXie_MSFT ,

(ABC) is a custom view. Not a document library. As far as I know the sample code you provided should be for document library

RaytheonXie_MSFT 31,606 Reputation points Microsoft Vendor

2021-12-16T09:06:15.033+00:00

Hi @SHUO .H ,
I think Dynamic Data Connections in the framwork may achieve your requirement. Please refer to the following document
https://learn.microsoft.com/en-us/sharepoint/dev/spfx/dynamic-data

RaytheonXie_MSFT 31,606 Reputation points Microsoft Vendor

2021-12-20T06:43:09.917+00:00

Hi @SHUO .H ,
I am checking to see if the problem has been resolved.

SHUO .H 706 Reputation points

2021-12-20T06:45:49.633+00:00

Hi @RaytheonXie_MSFT ,

I have solved this by using another way.

thanks for your help.

RaytheonXie_MSFT 31,606 Reputation points Microsoft Vendor

2021-12-20T06:50:16.573+00:00

Hi @SHUO .H ,
Glad that you found the solution to this problem. Could you please share the solution on the forum? You could accept your answer via the "Accept Answer" button, it would be helpful to others who have similar issue in the future.
Sign in to comment