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

  • 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
    – DvG
    Commented Jun 21, 2017 at 16:00

2 Answers 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.


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.

  • Even if I hide all WF status from the list view, The issue still persist
    – DvG
    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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.