Solved! Go to Solution.
@Harbie No worries... The only change you will need to make is initialize a variable of type array, and append the array variable with the value. See screenshot below:
The JSON Schema was generated you sample.
{
"type": "object",
"properties": {
"value": {
"type": "array",
"items": {
"type": "object",
"properties": {
"Email": {
"type": "string"
}
},
"required": [
"Email"
]
}
}
}
}
Flow Run:
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hey Mate,
I assume you are trying to get value from the array, something like the screenshot below:
If yes, you can use Parse JSON,> Generate the the JSON schema and directly use the 'Email' the output of Parse JSON asction.
If you want to access individual element then the formula would be.
First Value
body('Parse_JSON')?['value'][0]?['Email']
Similarly Second Value
body('Parse_JSON')?['value'][1]?['Email']
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
below is my flow
I have another array and I am trying to compare the values provided by HTTP with the values the Array 2. In other to do this, I need the values from Parse JSON to be stored in an array.
@CFernandes
In Compose you are using the 'Split' operator I guess with reference to error.
Please paste the formula that you have used in the compose action.
@CFernandes I sent that almost same time as your response.
If I am correct, the array, in this case, is Value?
How can I get just the array below from Value?
Thanks for your time @CFernandes .. I am a learner
@Harbie No worries... The only change you will need to make is initialize a variable of type array, and append the array variable with the value. See screenshot below:
The JSON Schema was generated you sample.
{
"type": "object",
"properties": {
"value": {
"type": "array",
"items": {
"type": "object",
"properties": {
"Email": {
"type": "string"
}
},
"required": [
"Email"
]
}
}
}
}
Flow Run:
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
8 | |
5 | |
4 | |
3 | |
1 |