This is functionality is not available out of the box (yet). But thanks to some pointers from , here at the Nintex Community. I was able to get this working using the Query List action coupled with the For Each action made this possible. So here is my write-up of this.
Thank you for your post, very helpful.
Just wondering if you could add a screenshot of the set variable action. I'm having trouble defining the variables.