Unanswered

Extract info from invoices

(0) Share

Report

Posted on by LiamR89

Evening,

I'm playing around with the AI builder for the first time, processing email attachments (PDF's) and using the ai connector to then create items in a SP list.

So far so good using they dynamic content offered to me to populat my fields in SP.

One field I want to fill however isn't being offered in the dynamic content, if i test the flow and search through the result of "extract ino from invoices" step I can see it in the "all detected text lines" section of the output but not in the "items" section, which I guess it needs to be in.

Any tips as how to access this?

Many thanks

Categories:

AI Builder

I have the same question (0)

All responses (6)

Answers (1)

CedrickB Moderator on at

Like (0)

Report

Hi,

I'm not 100% sure to understand you question but if you want to get each line item column just pick it from the dynamic content

The apply to each will be auto generated

Let me know if this answers your question.

Was this reply helpful? Yes No
LiamR89 51 on at

Like (0)

Report

Hi @CedrickB ,

The field I wish to use ( container No) is not being offered within the dynamic content though.

I can see it within the raw output of the extract information from invoices step though.

Was this reply helpful? Yes No
Verified answer

CedrickB Moderator on at

Like (1)

Report

Hi,

The prebuilt model return the most popular fields found in invoices.

We are going to enable customizing this prebuilt next year to allow adding custom fields like your "Container No".

In meantime, you can
- use the prebuilt Invoice model to capture the common fields, then build and call a custom Form Processing model to get the missing fields

- or simply create a custom Form Processing model to capture everything in one call

Was this reply helpful? Yes No
LiamR89 51 on at

Like (0)

Report

Understood, many thanks, I'll attempt this at some point today.

It's 99% there already, and is potentially going to save hours of work, so thanks!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

How do I display these line item values in power app afterwards?

Was this reply helpful? Yes No
sewinsl 8 on at

Like (0)

Report

Greetings all

The emails that we obtain the invoices from often have attachments, when I extract the data and create a new item in SharePoint, I get a line item for each attachment. How do I just get one line per email? Currently looks like this

Was this reply helpful? Yes No