I have a 'Filter Array' action in Power Automate where I am extracting values from a specific field in the resulting array.
Below is an example of the filtered data I get back:
{
"body": [
{
"ItemInternalId": "abc12345",
"Contractor Name": "John Doe",
"Assigned Enterprise ID": "john.doe",
"Assignment ID": "12345",
"Status": "Active",
"Assignment Work Country": "Country A",
"Project Name": "Project A",
"Client Name": "Client A"
},
{
"ItemInternalId": "xyz98765",
"Contractor Name": "Jane Smith",
"Assigned Enterprise ID": "jane.smith",
"Assignment ID": "67890",
"Status": "Active",
"Assignment Work Country": "Country B",
"Project Name": "Project B",
"Client Name": "Client B"
}
]
}
12345, 67890.
How can I achieve this in Power Automate? I'm looking for a solution that directly extracts these values and formats them as a comma-separated string.
Thank you for your help!