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".
You have to consider Created By and Modified By also as lookups.
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.
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.
Ah, might be an O365 limit. Guess it is to resource expensive.
Not the answer you're looking for? Browse other questions tagged sharepoint-designer workflow office-365 lookup-column or ask your own question.