title: SharePoint Online Microsoft.SharePoint.SPQueryThrottledException from workflow
body: <p>Background: Our SharePoint Task list threshold limit reached, means items are more than 5000. We have created custom view to manage the data view with help of indexed columns. </p>
  
  <p>But there is logic in SharePoint 2013 designer workflow in which we need to get description column and few other columns of task which gets completed to save it as history purposes (which user took what action and when). 
  Now to get information we use GUID return by Assign a task action of designer and query the completed task.
  Problem: Our SP designer workflow call for task list and filter items based on GUID. Below is the sample screenshot of call from designer. </p>
  
  <p><a href="https://i.stack.imgur.com/dBmJe.png" rel="nofollow noreferrer">SharePoint Call to our list</a></p>
  
  <p>and once reaching this step it throws an error in workflow, and workflow got suspended, when I drill down the reason it was due to threshold limit, I tested it on browser as shown below
  <a href="https://i.stack.imgur.com/s9pAI.png" rel="nofollow noreferrer">Error that throw by above call in worklfow</a></p>
  
  <p><strong>My Approach:</strong>
  To cater above problem i only have 2 points in mind:</p>
  
  <p>1) To call above by <strong>Item ID</strong> instead of GUID becuase Item ID will be indexed by defauly, but <strong>Assign a task</strong> action of SharePoint designer workfow return TaskID that contains GUID so that is the reason to filter items based on GUID, but GUID is not indexed columns, so it throw Microsoft.SharePoint.SPQueryThrottledException.</p>
  
  <p>2) Need to make <strong>GUID</strong> as indexed column so that threshold error can be cater. but in list settings GUID cannot be set as indexed column as its not listed there.</p>
  
  <p><strong>Question:</strong>
  Is there any solution or any other way so that we can get information related to task in designer once the task completed.</p>