Skip to main content

Using a Query List action in Nintex Workflow for Office 365. The output is a collection. I then use a For Each and a Get Item From Collection. I was expecting text but the output seems to be a Dictionary. I use Get An Item From A Dictionary action but the output is an empty string.  I believe I have everything configured correctly.  In Get An Item From A Dictionary, I have that "Item name or Path" set to "/d:nameofcolumn" which is correct, right?

 

If it makes any difference, the output column from Query List is a multiline text column from an SPO list.

 

PS - I have to do this step because my Nintex Forms is returning only the ID in the List Lookup, even though I specify to return the text column.  Therefore I decided to fix it in Workflow.

 

 

I wrote that down incorrectly.

d/nameofcolumn



 



that is what is in the action but it does not work.

The variable type for the Output from "Get Item from Collection" must match the data type of the actual item being retrieved.

So in your case it sounds like your "Query List" must have selected a Dictionary item or you left the Output type as "Single output". When dealing with multiple columns I prefer "Separate output per column" and have the output go into a Collection variable.
Yes! That was it! I switched the Query List output to "Separate output per column" and then For Each and Get Item From Collection returned text output, not a Dictionary.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings