Table data not extracted.

[CABIRD]

Re: AI Builder receipt processor 

Objective 'DataTable1' data to Flow then One drive for business, Excel. 

I've spent a few days attempting to extract table data generated by 'AI Builder receipt processor.' Regrettably with little overall success. 

Power App button OnSelect below:

Set(test,JSON({Name: Name_Column1.Text,Price: Price.Text,Quantity: Quantity.Text,TotalPrice: TotalPrice.Text}));
Set(varTest,JSON(JSONFormat.IndentFour));
Purchase.Run(test)

Flow

Compose 
Input and Output
{"Name":null,"Price":"$1.00","Quantity":"","TotalPrice":"$1.00"}

Parse JSON

Content
{"Name":null,"Price":"$1.00","Quantity":"","TotalPrice":"$1.00"}

Schema
{
  "type": "object",
  "properties": {
    "type": {
      "type": "string"
    },
    "properties": {
      "type": "object",
      "properties": {
        "Name": {
          "type": "object",
          "properties": {
            "type": {
              "type": "string"
            }
          }
        },
        "Price": {
          "type": "object",
          "properties": {
            "type": {
              "type": "string"
            }
          }
        },
        "Quantity": {
          "type": "object",
          "properties": {
            "type": {
              "type": "string"
            }
          }
        },
        "TotalPrice": {
          "type": "object",
          "properties": {
            "type": {
              "type": "string"
            }
          }
        }
      }
    }
  }
}

Outputs
{
  "Name": null,
  "Price": "$1.00",
  "Quantity": "",
  "TotalPrice": "$1.00"
}

What am I doing wrong? How can or is it possible to resolve given AI Builder receipt processor is still in preview. 

Developers should be congratulated for AI Builder receipt processor it has real potential. 

Thank you. 

[JoeF-MSFT · Accepted solution]

Hi @CABIRD, thank you for the question and trying out AI Builder Receipt Processing!

If you only need the items from the table, you can just convert to JSON the Purchased Items returned by the Receipts Processor control like this:

Set(test, JSON(ReceiptProcessor1.PurchasedItems))

And if your main usage of AI Builder Receipt Processing is going to be in Power Automate, you can directly use AI Builder in your flow like this, with no need to parse JSON outputs.


 

[CABIRD]

Hello @JoeF-MSFT 

Thanks for the prompt reply. Really appreciated. 

Resolved.

Thank you.