Skip to main content

Notifications

Power Apps - AI Builder
Answered

Extract Invoice Data with AI Builder and upload the File on Sharepoint

(0) ShareShare
ReportReport
Posted on by 17

Hello,

I get my PDF Invoiceses via Mail.

y51_0-1633527116792.png

But what I really want is to get when my AI Builder find the contact of my Organisation in the Invoice , that he get an E-Mail so he can enable the payment.

Ansprechpartner.PNG

Moreover I want that my invoice date can allways displayed on my Sharepoint list. I live in Germany so I have to do this: Convert Europe date notation in Power Automate to US date notation in Power Automate - YouTube

Rechnungsdatum2.PNG

What did I do when the MM is not a number, and is named "January", "Febuary" etc.?

For example

y51_1-1633527677825.png

How can I do a switch-case? Or is there any other possibilities which are useful in my requirement?

 

Besides that I want extract the  invoice amount. The Problem is it allways look diffrent.

for example:

y51_2-1633528086400.pngy51_3-1633528117207.png

I tried something but it not work often (maybe my AI Builder needs more Data)

I split the "," and "." and connect it together.

y51_4-1633528485198.png

Rechnungsbetrag2.PNG

Can someone help me?

 

Best regards

y51

Categories:
  • Verified answer
    KVa Profile Picture
    KVa 113 on at
    Re: Extract Invoice Data with AI Builder and upload the File on Sharepoint

    Got it. The confidence tells me how certain the chunk of text represents e.g. an invoice date, but nothing about the content.

  • Antrod Profile Picture
    Antrod on at
    Re: Extract Invoice Data with AI Builder and upload the File on Sharepoint

    The model doesn't extract "dates" per say but only "text". If you want to turn this text into a date, you have to do it in as a post processing step in your flow with the formatDateTime function.

  • KVa Profile Picture
    KVa 113 on at
    Re: Extract Invoice Data with AI Builder and upload the File on Sharepoint

    Thank you, @Antrod .

     

    Even if the document has the best possible quality, if the date "15.11.2021" cannot be recognized because there is no 15th month then it's hard to use. Can I teach the model somehow to recognize those dates (dd.MM.yyyy)?

  • Antrod Profile Picture
    Antrod on at
    Re: Extract Invoice Data with AI Builder and upload the File on Sharepoint

    Hi @kv ,

     

    There's no option to use comma instead of dot but providing more examples can help recognize fields better. Anyway, quality of the predicted document is also very important: for example, if the dots and commas look very similar, even to a human eye, the model can also confuse both.

     

    Thanks.

  • KVa Profile Picture
    KVa 113 on at
    Re: Extract Invoice Data with AI Builder and upload the File on Sharepoint

    Hi @Antrod ,

    Thank you! What do you mean by:

     

    > Providing more examples to your AI Builder model is also a great idea if you see that some fields are not correctly extracted (for example if it sometimes confuses "," and "." within numbers).

     

    How do I train the model e.g. to use the comma (",") as decimal separator instead of a dot (".")?

  • y51 Profile Picture
    y51 17 on at
    Re: Extract Invoice Data with AI Builder and upload the File on Sharepoint

    When I use a switch-case for the Month (January, February) e.g. I can test it then the values disappear. Iam so frustrated now I use a When function. It don't look nice but it works 🙂

  • Verified answer
    Antrod Profile Picture
    Antrod on at
    Re: Extract Invoice Data with AI Builder and upload the File on Sharepoint

    Hi @y51,

     

    Thanks for reaching out. AI Builder models render the fields as they "see" them in the document, so indeed post-processing needs to be done in some cases, for example when date formats vary between documents. It seems you are on the right approach trying to retructure your strings to comply with the ISO format and then apply Power Automate conversion functions (formatDateTime for example).

     

    Try to use either the isMatch function to detect you format (using regular expressions) or Find function, to determine the original format of your string and apply the Switch control if you need to apply different logic branches in your flow.

     

    Providing more examples to your AI Builder model is also a great idea if you see that some fields are not correctly extracted (for example if it sometimes confuses "," and "." within numbers).

     

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard