You could either use [Append to array variable] action or union() function like union(variables('arrayNotes'), variables('arrayNoteItem')) to add a new item to the original array.
See the screenshots below.
Using Union function
JSON Object to Array with Attribute Name using Power Automate - Stack Overflow
power automate - Insert parameters into JSON Array in Logic Apps - Stack Overflow
How to change table or array into object/json PowerAutomate Flow
Appending apply to each JSON Objects to one array
You need to specify this as your expression into the loop ...
body('Send_an_HTTP_request')?['value']
That should give you what you want.
Based on above answer I just want to do an small update:
body('<HTTP_ACTION_NAME>')?['<Body_array>']
<HTTP_ACTION_NAME>: How you can the action were you request data to API
<Body_array>: How your array is named inside the body answer
Example:
Body Answer from HTTP request:
Then, my expression should be:
body('getAllDefects')?['entities']
In Power Automate, you can use the Select action to convert an array into an object. You can use the item() expression to dynamically reference the elements of the array. Here is an example of how you can achieve this:
- Initialize two arrays, one for the headers and one for the values.
- Add a
Selectaction and set the "From" field to the headers array. - In the "Map" field, use an expression like this:
{item(): items('Select')[item()]} - The output of the
Selectaction will be an object with keys from the headers array and values from the values array.
This method should work for arrays of any length and should be relatively performant.
Once you have your data in an object format, you can use the Parse JSON action to convert it into JSON. From there, you can use a third-party connector like Plumsail Documents to convert the JSON into XML and manipulate it with XPath.
I hope this helps!
Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below
Regards Adeyemi
Chowdy Adeyemi --
Thank you for your interest in my problem I thought I was in a forum for PowerAutomate-Flow and so I didn't mention that. I will edit/update my question.
This can be achieved using the Parse JSON, Select and Join actions.
The finished flow will be trigger by a button and contain the following actions:
- Initialize variable - Initialize a variable with the data we want to manipulate
- Parse JSON - Assigns a schema to the data allowing us to more easily access the array
- Select - Converts the object array into a string array
- Join - Concatenates all the items within the string array
and look like this:
Each action needs to be implemented as follows:
1. Initialize variable
First add an initialize variable action with the following values:- Name: data
- Value: The JSON you want to process (as noted in the answer the "@" characters should be removed)
2. Parse JSON
You then need to add a Parse JSON action to tell power automate the schema of the data assigned in the initialize variable action. This will allow us to more easily reference the array in the next step. The values should be set to:- Content: The data variable
- Schema:
{
"type": "object",
"properties": {
"odata.context": {
"type": "string"
},
"value": {
"type": "array",
"items": {
"type": "object"
}
}
}
}
3. Select
Now add a Select action. This action is normally used to transform one array of objects. However, we can use it to return an array of strings. To do this click the Switch Map to text mode button.
Although you can achieve the desired result by using the expression item()['displayName'], it's possible to construct more complex string by combining the values within the object. For example, we could combine the displayName and mail properties by setting the map value to "@{item()['displayName']} - @{item()['mail']}".
4. Join
Finally use a Join action to concatenate the string array produced by the Select action with a specific separator (in your case a comma and space character , ).
I did the following ...
Loaded your JSON (minus the @ symbols because PA doesn't like them) into a variable so I can loop over it.
I then created two other variables, one to hold the concatenated string as it's being worked on and the other to hold the end result.
I then looped over the array of values and pulled out the displayName property and appended it (with a leading comma) to the Concatenated String variable.
Expression 1 = variables('Data')['value']
Expression 2 = item()['displayName']
The final step is to then remove the leading comma with an expression.
Expression = substring(variables('Concatenated String'), 1)
Result
Flow
