Thank you for visiting my site!

Home / Power Automate - Flows / Get Array Values from an item

Get Array Values from an item

Loop a List, get records get a columns that contains array:

  1. Get Items
  2. Filter records by a condition:
    FolderPathStr eq ‘@value’

    Filter will return two records
    ID | Title   | ArrayValue1    |Title1 | AB, CD

    2   |Title2 | DE,  FG

  3. Check if number of records are greater than 0

    length(body(‘Get_items_-_Organizations,_Approvers’)?[‘value’])
  4. create a variable varValueStream type string
  5. Get the Items values,
    loop inside each item to get the array values, append to string variable, use the string value, reset to null.

    concat(items(‘getValueStream’)?[‘Value’],’,’)
  6. Reset varValueStream  to null- have it ready for next item.

ADD YOUR COMMENT