Your supplier bill sits in SharePoint while approval disappears into email. A Power Automate approval workflow can coordinate that handover,1 but the connection to Xero needs its own checks and licences.2
The short answer: use a cloud flow to collect approval, then create a draft bill in Xero. The design below is a proposal on sample data, and it has not been deployed or measured.
Scene 5 of 5
The bill the owner approved. Bill 7731 from Supplier A (sample) sits in SharePoint with its PDF. The owner approved $1,100.00 against that version.
Then the flow creates a draft in Xero. The flow writes a draft bill and returns its Xero ID. The draft is not approved for payment.
SharePoint · Bill 7731Approved
Supplier A (sample)
Approved by the owner
- Materials$800.00
- Delivery$200.00
- Assumed GSTSample assumption$100.00
- Approved total
- $1,100.00
Approval is recorded against this document version.
Xero · Draft billDraft
Supplier A (sample)
Created by the flow
- Materials$800.00
- Delivery$200.00
- Assumed GSTSample assumption$100.00
- Draft total
- $1,100.00
The Xero ID is saved before the tracker is marked complete.
Rules compare the two. The same checks every time: duplicate, approved version and total. Any difference stops the bill.
Checked by a rule Approved bill
Checked by a rule Xero draft
Supplier
SupplierApproved bill: Supplier A
✓SupplierXero draft: Supplier A
Materials
MaterialsApproved bill: $800.00
✓MaterialsXero draft: $800.00
Delivery
DeliveryApproved bill: $200.00
✓DeliveryXero draft: $200.00
Assumed GST
Assumed GSTApproved bill: $100.00
✓Assumed GSTXero draft: $100.00
Total
TotalApproved bill: $1,100.00
✓TotalXero draft: $1,100.00
- Bill 7731 is not already in the tracker
- Draft total equals the approved total
- Document unchanged since approval
A person reviews the coding. The bookkeeper approves the coding or sends the bill back. Payment is a separate decision.
Messages · Bill 7731
Draft bill Waiting for the bookkeeperCoding approvedReturned with a reason
Approve the coding for bill 7731?
Totals agree. Coding is the bookkeeper’s decision.
Coding approved, still a draft.Returned with the reason recorded. The bookkeeper approves the account coding. The bill stays a draft until an authorised person approves payment.The bill goes back to the owner with the reason. Nothing is posted or paid.
Xero · Bill 7731Draft
Supplier A (sample)
- CodingApproved by the bookkeeper
- PaymentAwaiting an authorised person$1,100.00
Payment is released by an authorised person.
SharePoint · Bill 7731Returned
Supplier A (sample)
- StatusReturned to the owner
Nothing is posted or paid.
End of the day Each bill in SharePoint is checked for a duplicate and approved by the owner. The flow then creates a draft bill in Xero. It never approves coding, posts or pays.
Check the connection first
Publisher and status
The connector is published by Magnetism, a third party, and is in Preview.
Power Automate class
Microsoft lists it as a Premium connector, so a Premium licence applies.
Separate subscription
Magnetism needs its own licence after a 7-day trial. Microsoft’s licence does not cover it.
Connector throttle
Up to 100 calls per connection every 60 seconds. A limit, not a promise of throughput.
Microsoft lists “Xero Accounting - Magnetism (Preview)” as a Premium connector. Magnetism publishes it and requires its own subscription after the trial.2 Its Xero App Store listing describes the sign-in step, where you allow access to your Xero organisation.3 Confirm the exact bill fields before building, because “Some Xero API endpoints and fields may not be available from the Connector”.2
Budget the whole workflow
A$ a year, ex GST · orange: per bot
Annual figures are Microsoft’s monthly rate times 12. They are alternatives, not cumulative purchases.
Source: Microsoft Power Automate pricing, Australia, read 31 October 2026. Excludes GST.
These Australian prices were read on 31 October 2026. They exclude GST and are monthly rates paid yearly, at A$22.40 a user for Premium and A$224.50 a bot for Process.4
Automated flows use the flow owner’s licence context, and instant flows use the invoking user’s. An instant flow with a premium connector needs Premium for every user who runs it, unless it has a Process licence. “Users who respond to approval requests don’t need a Premium license.”5 Add Microsoft 365, Xero, Magnetism, build and support to your budget. The automation cost guide separates those costs.
A worked example on sample data
| Bill 7731, Supplier A (sample) | Amount |
|---|---|
| Materials | $800.00 |
| Delivery | $200.00 |
| Subtotal | $1,000.00 |
| Assumed GST | $100.00 |
| Approved total | $1,100.00 |
| Draft total | $1,100.00 |
| Difference | $0.00 |
Sample data, not a client’s. For bill 7731, record approval against the document version, and treat a changed amount as a fresh review. Store the Xero identifier the flow returns before the tracker is marked complete. Xero’s API describes creating sales invoices or purchase bills in one call.9 Test the connector’s draft status and field mapping before enabling writes, and keep payment authorisation separate.
Make failures visible
Duplicate
Hold the second copy and compare it with the original before anything is created.
Rejected
Return the bill to the requester, with the reason recorded.
Timeout
Escalate to the owner well before a pending approval times out.
Failed write
Search Xero for the bill before retrying, because it may already exist.
I would give every stopped bill an owner and a reason. A flow run can last 30 days, and “After 30 days, any pending steps time out”.6 Escalate earlier, because silence must never become approval, and search Xero after a failed response because the bill may already exist.
A checklist before you build
Connect safely
The connection points at the right Xero file. The sign-in has the access the flow needs, and no more.
Draft the bill once
Every bill field lands where you expect it. The same bill sent twice creates one draft.
Handle a stop
A rejected bill goes back to the requester with the reason saved. A named person is chased before the run limit.
Recover and own it
Xero is searched for the bill before anyone retries. One person fixes the flow when something changes.
This is a working checklist, not a claim about your savings. If you only need a notification when a list changes, SharePoint’s own list rules may be enough.7 Power Automate handles processes across apps and services, and desktop flows automate tasks on the web or the desktop.8 Compare the upkeep with an n8n workflow, and stop if required fields fail testing or nobody owns recovery.
The full checklist, eight checks
- Correct organisation. The connection points at the right Xero file, not a demo or an old one.
- Permissions checked. The sign-in uses an account that has the access the flow needs, and no more.
- Draft mapping tested. Every bill field, including tax and the account code, lands where you expect it.
- Duplicate replay blocked. The same bill sent twice creates one draft and holds the second copy.
- Rejection recorded. A rejected bill goes back to the requester with the reason saved beside it.
- Timeout assigned. A named person is chased well before the run limit ends a pending approval.
- Failed write reconciled. Xero is searched for the bill before anyone retries a failed request.
- Support owner named. One person fixes the flow when Microsoft, Magnetism or Xero changes something.
Where a person stays in charge
Rules check
Matching, totals and the duplicate check, the same way for every bill.
Claude drafts
An exception note, if the design includes one. It writes only.
You decide
The owner approves spend, the bookkeeper approves coding and posting, an authorised person pays.
I keep calculations and duplicate checks in rules. Claude may draft an exception note if the design includes one, but it does not approve, post or pay. The Supplier Bill Approval build starts from A$3,900 (AUD, no GST charged).10
Start with a free fit check by email at the foot of this page, to document the approval boundary and the recovery owner first. The Workflow Audit, A$990 (AUD, no GST charged), is the next step.10
Questions
Is Xero included with Power Automate Premium?
Premium covers premium connectors. Magnetism’s connector subscription is separate.25
Does every approver need Premium?
Microsoft says people who respond to approval requests do not need Premium. Invoking an instant premium flow is a different licensing case.5
Can an approval wait indefinitely?
No. The documented run limit is 30 days, including pending approval steps.6 Design escalation and recovery before that limit.
Sources
- 1. Microsoft Learn, “Create and test an approval workflow with Power Automate”, read 31 October 2026: learn.microsoft.com/en-us/power-automate/modern-approvals
- 2. Microsoft Learn, “Xero Accounting - Magnetism (Preview)”, connector reference, read 31 October 2026: learn.microsoft.com/en-us/connectors/xeroaccountingmagnet
- 3. Xero App Store, “Magnetism Solutions: Power Platform Connector” (vendor listing), read 31 October 2026: apps.xero.com/au/app/magnetism-solutions-power-platform-connector
- 4. Microsoft, “Power Automate pricing”, Australia, read 31 October 2026: microsoft.com/en-au/power-platform/products/power-automate/pricing
- 5. Microsoft Learn, “Power Automate licensing FAQ”, read 31 October 2026: learn.microsoft.com/en-us/power-platform/admin/power-automate-licensing/faqs
- 6. Microsoft Learn, “Limits of automated, scheduled, and instant flows”, read 31 October 2026: learn.microsoft.com/en-us/power-automate/limits-and-config
- 7. Microsoft Support, “Automate a list”, read 31 October 2026: support.microsoft.com/en-us/sharepoint/lists/automate-a-list
- 8. Microsoft Learn, “What is Power Automate?”, read 31 October 2026: learn.microsoft.com/en-us/power-automate/flow-types
- 9. Xero API, “createInvoices” (xero-node SDK documentation, version 20.0.0), read 31 October 2026: xeroapi.github.io/xero-node/accounting/index.html#createInvoices
- 10. Works Better, “Pricing”, “Supplier Bill Approval” and “Workflow Audit”: worksbetter.ai/pricing (Supplier Bill Approval from A$3,900; Workflow Audit A$990; AUD, no GST charged)
Not sure which to fix first?
Get a free fit check by email and I will say whether it is worth automating. No call needed. The next step is a A$990 workflow audit: the top 3 things worth automating, with a fixed quote for each.
Get a free fit check by email