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. Jun 21 '17 at 15:27
  • aah.. thats right! I didn't thought through this
    – DvG
    Jun 21 '17 at 16:00

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
    Jun 21 '17 at 16:53
  • Ah, might be an O365 limit. Guess it is to resource expensive. Jun 21 '17 at 17:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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