Find pending workflow instances

Persons who need to approve workflows or take other actions might not always be available due to vacation or illness. There is an option for workflow delegation in Microsoft Dynamics 365 Finance and Operations, but that is not a guarantee that all workflow instances are directed to the delegated user. Already assigned workflow instances will not be automatically delegated. When the user will return to work, the workflow instances are also not assigned back in the standard application. A system administrator can re-assign the pending workflows, but this is a tedious job. Due to a high volume of pending workflows and not having the user on the list page, you might think you need to loop through all pending workflow messages check the details one by one. In this post, you will get a guide on how to quickly find pending workflow instances for a particular user.

Find pending workflow instances

You can use the Advanced filter and sort option to filter the Workflow history list page for all pending workflows waiting for a particular user. Follow the next steps:

  1. Open the Workflow history page (Common > Inquiries > Workflow)
  2. Open the advanced filter and sort option (CRTL+SHIFT+F3)
  3. Open the tab page ‘Joins’.
  4. Select the table ‘Workflow tracking status table’
  5. Click ‘Add table join’.
  6. Select the table ‘Work items’
  7. Click the ‘Select’ button.
  8. Select the tab page ‘Range’
  9. Click ‘Add’
  10. Select the table ‘Work items’ in the field ‘Table’
  11. In the column ‘Field’, select the value ‘Status’
  12. In the column ‘Value’, you can select the status ‘Pending’
  13. Click ‘Add’
  14. Select the table ‘Work items’ in the field ‘Table’
  15. In the column ‘Field’, select the value ‘User’
  16. In the column ‘Value’, you can now fill the User ID of the original approver.
  17. Click ‘OK’.

Now, you have a filtered list with all waiting workflow messages for a user but still would need to reassign per instance.

For a demo of how this works, you can also watch the video below.

I do hope you liked this post and will add value for you in your daily work as a professional. If you have related questions or feedback, don’t hesitate to use the Comment feature below.

That’s all for now. Till next time!

5 replies
  1. Kenneth Christensen
    Kenneth Christensen says:

    Great post.

    I am quite sure that by default, access to the re-assign feature is actually in the system user role.
    I always recommend changing this setup, so only administrators can re-assign.

    Best regards.

  2. James Terrington
    James Terrington says:

    Thank you for the post 🙂 that is very useful!!!

    Just a note, there is a little limitation with this. If a workflow is subject to a “subworkflow” then the workflow history won’t show the subworkflow items. Therefore in this specific situation it won’t be a complete listing.



Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.