M365Con 2027 – free online conference · 11–22 Jan 2027 · 120 sessions m365con.net

Blog · Marcel L.

Automatically capturing invoices with Power Automate and AI Builder

By ·

The invoice arrives by email, a flow stores it in SharePoint, and AI Builder fills in supplier, amount and date. The process, pitfalls and the licensing question.

Automatically translated with AI from the original post.

The invoice arrives by email. Someone downloads the PDF, saves it to SharePoint and types the supplier, amount and date into the columns. The next day, the same again. This work requires no thought, but it offers plenty of opportunities for typos: a swapped date, an amount with transposed digits, a receipt in the wrong folder. Anyone searching for the receipt later pays the time a second time.

What the flow takes over

I have built this process several times with Power Automate and AI Builder. AI Builder is the AI feature of the Power Platform and provides a model for document processing. The flow has four steps:

  • An email with an attachment arrives in the invoice mailbox and triggers the flow.
  • The flow saves the PDF to a SharePoint library, always in the same location.
  • The model reads the supplier, amount, date and invoice number, even with different layouts.
  • The flow writes the values into the columns of the library.

Checking the receipts the model could not read reliably remains a manual task.

Plan for exceptions

No model reads every invoice without errors. That is why the flow needs a path for unclear receipts from the start, for example a "To check" view in the library. Invoices the model could not read cleanly end up there. A person reviews them, corrects the values and releases the receipt. This keeps you in control, and the large remainder runs without manual work.

Start with the most frequent suppliers

Anyone who tries to cover all layouts on the first day gets bogged down. Start with the suppliers that send the most invoices. You can extend the model later, and it becomes more reliable the more deliberately you train it.

Define the columns in SharePoint before you build the flow. Every later change to the structure requires adjustments throughout the flow.

Clarify licensing before you start

AI Builder consumes credits. Since 1 November 2026, newly purchased or renewed licenses no longer include AI Builder credits. Anyone who purchased or renewed earlier keeps them until the end of the contract term. Afterwards, the AI Builder functions run on Copilot Credits. If neither is available in the environment, Microsoft blocks the function and the flow stops. [1] Clarify this with your licensing partner before accounting relies on the flow.

Once the invoice is captured, the next step is approval. It can be attached to the same flow.

This article is based on a KMUpower impulse. [2]

Sources

  1. ↑ End of AI Builder credits – Microsoft Learn (2026-11-17) · learn.microsoft.com
  2. ↑ 300 invoices a month: AI now does this – KMUpower (2026-11-02) · kmupower.com
Follow the showApple PodcastsSpotify

Entities in this article

Topics of this article:

Power Automate – Low-code tool by Microsoft AI Builder – Low-code tool by Microsoft AI Builder document processing – Narrower topic of AI Builder SharePoint – Collaboration tool by Microsoft Power Platform – Low-code tool by Microsoft

Related articles

More articles on Power Automate:

RSS