Use the Query List action to return a collection of List Item IDs

  • 15 February 2022
  • 0 replies
  • 167 views

Userlevel 6
Badge +22

Topic

Using the default configuration of a Query List action to return a collection of List Item IDs the collection that is returned looks like the following: 
[{"Id":1,"ID":1},{"Id":2,"ID":2},{"Id":3,"ID":3},{"Id":4,"ID":4},{"Id":5,"ID":5}]

This output makes it hard to use in a For Each action as additional operations are required inside the For Each loop to extract the ID.

For a more usable output read on.

 

Instructions

Configure the Query List action by changing the "Output type" from 'Single output' to 'Separate output per column'.

9691i4C31CAAB491B166C.png

Additional Information

The output collection will look like the following:
[1,2,3,4,5]

This formatting makes it easier for the For Each action to read the list item ID at each index to target a list item to perform an activity on.

 

 


0 replies

Be the first to reply!

Reply