Excel Calculations in Power Automate
Power Automate moves your data across Microsoft 365. SpreadAPI does the math. Add real Excel calculations to any flow — your formulas, your business logic, exact results. No expressions to rebuild, no Office Script workarounds.
Power Automate Moves Data — But Who Does the Math?
Power Automate connects all of Microsoft 365, but when a flow needs to calculate a price, a commission, or a quote, you're stuck rebuilding Excel logic in expressions or Office Scripts. Your spreadsheet already does this — correctly.
The Expression Trap
Rebuilding a pricing model with Power Automate expressions means translating Excel formulas by hand — and maintaining them in two places forever. They drift apart.
The Office Script Detour
Driving Excel Online with Office Scripts to recalculate is slow, throttled, and brittle when several flow runs hit the same workbook.
The SpreadAPI Way
Your Excel file becomes a connector action. SpreadAPI sends inputs, your actual formulas compute, results come back — in milliseconds, no workbook locking.
From Spreadsheet to Flow
Publish your Excel model
Upload your spreadsheet to SpreadAPI, mark inputs and outputs, publish. Your formulas stay private — only the parameters are exposed.
Import the connector (once)
In Power Automate: Data → Custom connectors → New → Import an OpenAPI from URL, and paste the SpreadAPI connector URL. One connector serves every service.
Connect with your token
Create a connection with your service token (or none for public services). It travels securely as an authorization header.
Add Calculate and run
Add the SpreadAPI Calculate action, enter the Service ID, and the input fields for that service appear automatically — dropdowns, numbers, required markers. Fill them in and run.
What the SpreadAPI Connector Gives You
Self-building fields
The Calculate action reads your service definition and renders the right field for each parameter: dropdowns for allowed values, number and boolean fields, required markers. No guessing.
Works across Power Platform
The custom connector works in Power Automate, Logic Apps, and Power Apps — the same calculation everywhere.
Formulas stay private
Power Automate only ever sees inputs and outputs. Your spreadsheet — the formulas, the margins, the logic — never leaves SpreadAPI.
Agent-ready
A certified connector becomes a tool for Copilot Studio agents — your Excel model as a skill your AI agents can call.
Real Flows, Real Math
Quote Generation
Microsoft Forms → SpreadAPI pricing model → Word/PDF quote → Outlook. Discount ladders and tax rules included.
Approval Routing
Score a request with your Excel model and route high-value ones through Approvals in Teams.
Financial Calculations
Loan schedules, ROI projections, insurance premiums — computed by the models your analysts already maintain in Excel.
Dynamics & Dataverse
New record → SpreadAPI margin/commission model → write results back to Dataverse or Dynamics 365.
Frequently Asked Questions
What does the SpreadAPI Power Automate connector do?
It adds a Calculate action that runs a calculation in your published Excel model via SpreadAPI. Input fields are generated from your spreadsheet, and outputs come back for use in the rest of your flow. It works in Power Automate, Logic Apps and Power Apps.
How do I install it?
Import it as a custom connector from the OpenAPI URL (Data → Custom connectors → New → Import an OpenAPI from URL). This works in any tenant today. A certified version for the Power Platform connector gallery is planned.
Are my Excel formulas exposed to Microsoft?
No. Power Automate only exchanges input values and calculated results with SpreadAPI. The workbook itself — formulas, hidden sheets, business logic — stays on SpreadAPI and is never transferred.
How does authentication work?
Create a service token in the service's API settings and use it in the connector connection. It is sent as a secure authorization header. Public services need no token.
How do percentage inputs work?
Like in Excel: as decimals. 5% is 0.05. Percentage fields are marked, and the server converts obvious whole-number mistakes automatically on explicitly marked percentage fields.
What does it cost?
SpreadAPI has a free tier to build and test. Once certified, the connector is Premium-tier in the Power Platform, which requires a per-user or per-flow Premium license from Microsoft.
Your Excel already knows the answer. Let Power Automate ask it.
Publish a spreadsheet, import the connector, run your first calculation.