After a break of many years from programming, I am dabbling with PA. I used the template to extract text from a PDF and made the necessary changes. I now want to update my flow to add the extracted data to an Excel spreadsheet. I put in the Add Row action, but am struggling with how to access the Parse Json data.
I have a table in an Excel with columns: Broker, Property, Brand, Brand Industry, Purchase Price, and Cap Rate.
Here is the json output:
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"operationStatus": "Success",
"predictionId": "68dadcc6-19f4-422a-99fa-a98d835fbd96",
"predictionOutput": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"text": "{\n \"extracted_data\": {\n \"Broker\": {\"value\": \"Test Broker\", \"type\": \"string\"},\n \"Property\": {\"value\": \"Test Property\", \"type\": \"string\"},\n \"Brand\": {\"value\": \"Test Brand\", \"type\": \"string\"},\n \"BrandIndustry\": {\"value\": \"Restaurant\", \"type\": \"string\"},\n \"PurchasePrice\": {\"value\": \"$1,000,000\", \"type\": \"currency\"},\n \"CapRate\": {\"value\": \"5.0%\", \"type\": \"percentage\"}\n }\n}",
"finishReason": "stop",
"totalTokens": 3702,
"promptTokens": 0,
"completionTokens": 0
}
}
Share
Report
All responses (
Answers (
525
