This article will show you how to use Get Items by Query workflow action. This action is much easier to use than its ancestor "Get Items by CAML query". It allows you to use simplified REST queries to get items. This approach works fo SharePoint 2013 / 2016 as well as for SharePoint Online in Office 365.

The first thing that you may be noticed, there is no more ugly CAML query. No more pain with debugging.

We wanted to make it simple as it possible. Just write list name what you want to select, specify fields and query. And it is all.Please have a look at documentation below we support abig amount of functions, which open a new opportunity for using the data in a workflow.