AnsweredAssumed Answered

O365 Query List

Question asked by moobycow on Aug 30, 2017
Latest reply on Aug 30, 2017 by courtney.shelton

Dear All,

 

Just getting started using Nintex & Nintex workflows in O365 and struggling to get my head around the O365 Query List.

I have a custom list called department heads containing department (string) and department head (person).

 

On a separate site I am building a workflow to query the department heads list based upon a selection on a form.  i.e. if IT on current form = IT of department heads form then return department head.

 

The issue I have getting my head around is the O365 query list only allows me to output this as a collection or dictionary as a string. 

 

The workflow works to a point if I create a dictionary and save results in first column (see attached) which brings back in format ["firstname surname"] which I can save into a text field but what I am really looking for is ability to return person properties such as email, display name?

 

Do I need to build a collection or dictionary with these fields?

 

Sorry if this is isn't clear but I'm new to Nintex and still finding my way around.

Attachments

Outcomes