ISSUE
Workflow suspends when using the "Query List" or "Office 365 Query List" actions to query a list that contains more than 5000 items.ERROR CODE
The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.RESOLUTION
In an effort to increase the performance of the query, create an index on the list column on which the filter is being applied.
1. Identify the column which the query is being filtered on
2. On the list which is to be queried, navigate to List Settings > Indexed Columns (located under the list of all list columns) > Create a new index.
3. Select the previously identified column in the drop down menu for 'Primary column for this index'. Click 'Create'.
3. Execute your workflow and check the results in the workflow history.
Note: The result below is from a 'Log in History List' action capturing a variable that contains the number of items returned from the query. This will not appear by default.