Each iteration of the query list action is extracting just the first person in a People/Group multi-selectd field and then concatenating it to the previous item's extracted names. Why? ...and Help!

  • 17 November 2016
  • 1 reply
  • 12 views

Badge +4

For a site workflow, I've learned how to build a table of queried list items for insertion into an email. However for each list item/row I want to list the person(s) Assigned To a specific list item. What I see  happening is that list query is extracting the first person only of a multi-select people/group field in each list item. When the next list item is queried, that first person is extracted and the person(s) in the previous are added to it. ?? How could this be happening?

Note 5 Rows; The first row has just one assignee, the second two, the third three...???

It appears that the variables I use in the Build String actions in my For Each loop are not clearing at the end of the loop, but nor is the query pulling all Assignees for each item. For example, in the first row, there should be THREE people listed in the Assigned To column. Any thoughts are much appreciated!

====Subsequent additional info:

I did create a history log action to see what was in the Assigned To collection variable for each iteration of the For Each action. It is retrieving all people listing in the People Group field of the target list. For example, For ID 584: Assignees: i:0#.w|usab86115;i:0#.w|usebergln;i:0#.w|us1110mu; Note that is 3 people where the table above is only indicating one assignee for that ID Nbr.


1 reply

Badge +11

To take care of adding the names over to next field, before you set the value of AssignedTo text variable, set its value to empty and then retrieve the value.

For multiple values, how are you retrieving the values from the list. If you query the list for this column, it should get all the values in the collection variable.

Reply