cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CABIRD
Post Patron
Post Patron

Table data not extracted.

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)

 

Expenses.jpg

 

 

 

 

 

 

 

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"
}

FlowTest.jpgFlowPass.jpgExcelSheet.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
JoeF-MSFT
Power Apps
Power Apps

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.

flow-receipts.png
 

View solution in original post

2 REPLIES 2
JoeF-MSFT
Power Apps
Power Apps

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.

flow-receipts.png
 

Hello @JoeF-MSFT 

 

Thanks for the prompt reply. Really appreciated. 

 

Resolved.

 

Thank you. 

 

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,561)