Query list to get whole column

I found a mistake in my workflow, i forgot to set variable as collection....

Hi Maciej Flis‌

Inside your For Each loop, the query list will retrieve one value only as you have a filter for ID. If you are overwriting the same variable with the email Id's retrieved from the list, then at the end you will be left with 1 Id in that variable.

See if this corrects your issue.

First step in my workflow is to query "Names" list to get all ID's.

Next i take those ID's as "For Each" loop parameter, and in this loop i have second "Query list" control, to query names based on ID's

well, that's a bit overcomplicated.

you do not need to query the same list twice. query the list for all the columns you will need later in a workflow with a single action before the loop.

but i only get one name (first one) as result of list query.

that's a typical case if you store Query list action result set into a scalar variable(s) (single line text, number, etc..)

if query list may possibly return more then one item, you have to store result set into a collection variable. each single column you query for into a separate collection variable.

I need to query second list to get all names(e-mail) and assign Flexi task based on them.

if you want to assign a single task to all the users from the other list, you even do not need a loop action at all.

just query for all the names/mails (store them into a collection as mentioned above) and then configure task action's assignees the directly to the variable

Great!

Please mark correct answer.