Loop a List, get records get a columns that contains array:
- Get Items
- Filter records by a condition:
FolderPathStr eq ‘@value’
Filter will return two records
ID | Title | ArrayValue1 |Title1 | AB, CD2 |Title2 | DE, FG
- Check if number of records are greater than 0
length(body(‘Get_items_-_Organizations,_Approvers’)?[‘value’]) - create a variable varValueStream type string
- 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’],’,’) - Reset varValueStream to null- have it ready for next item.