[[error]] and [object Object] errors in the data table used to view line items extracted from form processor

(0) Share

Report

Posted on by andrewisaac

Hi,

how can i solve the below errors in the line items table?

i happen to have these errors for the quantity, unit price and amount, while for item & description line item the extracted data is shown in the data table. in the pic are the configuration details

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @andrewisaac ,

This is because the data format is mismatching. Please try below:

Quantity: ThisItem.'quantity'

Unit Price: ThisItem.'Unit Price'.Value

Amount: ThisItem.Amount.Value

Best regards,

Was this reply helpful? Yes No
andrewisaac 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi@v-jefferni
i tried your solution but still error persists, and for quantity if i set Text as Quantity: ThisItem.'quantity' it will bring the red cross because it expects a value

Was this reply helpful? Yes No
Jae234 17 on at

Like
a
(0)

Report
Copy link

Link copied!

I was having a similar problem @v-jefferni and your explanation helped me to understand why I was getting [object] [object] error. This was my scenario: I created a data table canvas app and on the data view I had multiple attachment fields and when I placed the field on the view I kept receiving the [object] [object] error. I would think the system would be smart enough to know that if I bring in a field that has a data type 'file' would automatically make the field automatically

Was this reply helpful? Yes No