1

I already have 6 workflows running in one of my Document Library. If I am adding a new Workflow, it is throwing error as - "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator".

I have gone through many articles on this. All suggested the default threshold is 8 lookup. Reference ... then why I am getting this on adding 7th WF. I don not have any other lookup field in Doc library

I am working on Sharepoint Online. Is there any way to modify these default limits? Or If someone can explain about my issue? TIA

Improve this question
2
  • You have to consider Created By and Modified By also as lookups. Commented Jun 21, 2017 at 15:27
  • aah.. thats right! I didn't thought through this Commented Jun 21, 2017 at 16:00

2 Answers 2

Reset to default
2

We have to consider the Created By and Modified By columns also as lookup columns. Then the total will be 8 in your case and reaches maximum limit.

Improve this answer
0

Remember that you are hitting the list view threshold, an actual SharePoint list can hold a lot of columns.

But it is weird that you hit limit at 8 columns, as Microsoft states that 12 is the default in Office 365. Sounds like they either lowered it, or you might want to give them a call

Do you really need to show all of your SharePoint workflow status columns in the same view/default view? As long as you don't have more than 8 lookup columns in your default view, you will be fine.

Improve this answer
2
  • Even if I hide all WF status from the list view, The issue still persist Commented Jun 21, 2017 at 16:53
  • Ah, might be an O365 limit. Guess it is to resource expensive. Commented Jun 21, 2017 at 17:17

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.