This is my array variable "Resultados":
{
"body": {
"name": "Resultados",
"value": [
{
"fieldName": "Fornecedor",
"fieldValue": {
"type": "string",
"valueString": "Contoso, Ltd.",
"text": "Contoso, Ltd.",
"page": 1,
"boundingBox": [
0.585,
0.44,
2.34,
0.44,
2.34,
0.795,
0.585,
0.795
],
"confidence": 0.994,
"elements": [
"#/readResults/0/lines/0/words/0",
"#/readResults/0/lines/0/words/1"
]
}
},
{
"fieldName": "Data",
"fieldValue": {
"type": "date",
"text": "8/20/2020",
"page": 1,
"boundingBox": [
7.38,
1.08,
7.925,
1.08,
7.925,
1.175,
7.38,
1.175
],
"confidence": 0.994,
"elements": [
"#/readResults/0/lines/2/words/1"
]
}
}
]
}
}
I want to extract: "Fornecedor" -> "Text".
How do I do that?
The expression above is:
variables('Resultados')['Fornecedor']['text']
Solved! Go to Solution.
I would recommend utilizing a combination of 'Parse JSON' and 'Filter Array' to quickly filter based on the fieldName attribute. That's going to allow you to reduce the results and then the 'text' field value should be available via the dynamic content pane. See below:
Did my reply help? Please give it a thumbs up.
Did my reply answer your question? Please mark it as a solution!
If you liked my response, please consider giving it a thumbs up.
I would recommend utilizing a combination of 'Parse JSON' and 'Filter Array' to quickly filter based on the fieldName attribute. That's going to allow you to reduce the results and then the 'text' field value should be available via the dynamic content pane. See below:
Did my reply help? Please give it a thumbs up.
Did my reply answer your question? Please mark it as a solution!
If you liked my response, please consider giving it a thumbs up.
Thank you @Taylor_Becktold
I'm really puzzled with this. All I need is to extract 2 values: "Contoso Ltd" and "8/20/2020" so I can add them to a csv table.
Do I need all that??
My configuration is simply a recommendation. However, you are most likely going to need to utilize the filter action to filter the array by the JSON element of "fieldName" and get that value. In my opinion, Parse JSON makes other people with less technical expertise be able to read and understand a Flow (especially in that it provides dynamic values).
Thank you so much, my comment was more of an expression of surprise, than a claim.
I really appreciate your effort.
@WebPortal Not a problem! If you think it was useful, I would really appreciate it if you could mark my response as a solution.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.