{
"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"
}
]
}
join(
xpath(
xml(json(concat('{"Root":{"Item":', outputs('Compose'), '}}'))),
'//Item[Contractor_x0020_Name !=""]/Assignment_x0020_ID/text()'
),
', '
)
Thank you, RaulLessa
I encountered an error in the select step due to the ".body" in step #2. The error was as follows:
"The template language expression 'outputs('Compose').body' cannot be evaluated because property 'body' cannot be selected. Array elements can only be selected using an integer index."
The solution was to remove ".body," so the expression ended up as: outputs('Compose')
.
Hello!
Here is the solution to extract only the 'Assignment ID' values and return them as a string separated by commas:
Step 1: Add your JSON to a Compose action.
Step 2: Add a Select action and populate the fields as follows:
outputs('Compose').body
item()?['Assignment ID']
body('Select')
.
David_MA
310
Super User 2025 Season 1
Michael E. Gernaey
271
Super User 2025 Season 1
stampcoin
253