After Query List, output is Collection, then For Each, Get Item, output is Dictionary?

Question

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.

Best answer by v-tmasenko

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.

v-tmasenko · Accepted Answer

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.

plamping · Answer

I wrote that down incorrectly. d/nameofcolumn that is what is in the action but it does not work.

Sign up

Log in with SSO

Login to the community

Log in with SSO

Scanning file for viruses.

This file cannot be downloaded