如何在SharePoint Online中管理具有超过5000个值的查找列. [英] How to manage lookup column having more than 5000 values in SharePoint Online.

问题描述

我有一个包含9000多个条目(大约9000个)的列表.我想创建一个查找列，该列将在另一个列表中创建项目时提取所有这些条目.请为该结构提出任何替代方案.

I am having a list with more than 9000 entries (approx. 9000). I want to create a lookup column which will fetch all this entries while creating an item in another list. Please suggest any alternative for this structure.

还请提出建议，该如何过滤查找列以使这些条目减少到5000.

Also please advice how I can filter lookup column to get those entries down to 5000.

推荐答案

我建议您可以按文件夹组织列表项，每个文件夹包含的项远远少于2000个，以便进行扩展.

I suggest you can organize the list items by folder , with each folder containing well below 2000 items to allow for growth .

或者您可以通过过滤常规列来创建新视图.

Or you can create a new view with filter a normal column.

最诚挚的问候，

刘李

这篇关于如何在SharePoint Online中管理具有超过5000个值的查找列.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！