Business Professionals
Power BI | Power Pivot | Power Query | DAX
Cloud Flows | RPA | AI Builder | Copilot
60+ Formulas | Data Stories | Advanced Reporting & Modeling
VB Programming | Report Automation |
MS-Office Automation
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Power BI | Power Apps | Power Automate | Copilot Studio | Power Pages | Dataverse
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Python | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Python | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA | Python |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA | Python
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Databricks | Power Apps | Power Automate |
Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables | Power Apps | Power Automate
Power BI | Power Apps | Power Automate | SQL | VBA | Python | API Integration
Power BI | Advanced DAX | Databricks | SQL | Lakehouse Architecture
Business Professionals
Power BI | Power Pivot | Power Query | DAX
Cloud Flows | RPA | AI Builder | Copilot
60+ Formulas | Data Stories | Advanced Reporting & Modeling
VB Programming | Report Automation |
MS-Office Automation
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Power BI | Power Apps | Power Automate | Copilot Studio | Power Pages | Dataverse
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables
Power BI | Power Apps | Power Automate | SQL | VBA | API Integration
Power BI | Advanced DAX | Databricks | SQL | Lakehouse Architecture
LEARN THIS HANDS ON
Power Apps & Power Automate
SmartBill doesn’t have a native Power Automate connector, but the finance team still wants invoices pushed automatically from your ERP and status updates back into SharePoint. You’ve probably tried to stitch this together with email parsing or manual exports and quickly hit reliability and maintenance problems. This article shows how to wire up SmartBill using only HTTP calls in Power Automate, what the premium licence requirement really means, and how to stay inside SmartBill’s 3-calls-per-second limit without breaking flows.
You have:
There’s no SmartBill connector in Power Automate. The only integration option is SmartBill’s HTTP API.
The rest of this article assumes:
We’ll walk through:
SmartBill exposes a REST-style API (endpoints, HTTP verbs, JSON payloads). Without a connector, you can still do most integration work:
What you don’t get without a connector:
From Power Automate’s perspective, SmartBill is just another HTTP endpoint. The key is configuring the HTTP action correctly and designing flows so they don’t exceed SmartBill’s rate limits.
The HTTP action used in cloud flows is part of Power Automate’s premium feature set. As of late 2026:
Important distinctions:
For our scenario, you need:
If you’re designing a team-wide automation:
Let’s wire the core scenario: when a SharePoint item is approved, call SmartBill’s API to create an invoice.
High-level steps:
Status = Approved.In the cloud flow designer:
When an item is created or modified (SharePoint).Status equals Approved.Assuming SmartBill expects something like this (structure will depend on SmartBill’s current API docs):
{
"customer": {
"name": "Example Customer",
"vatNumber": "RO12345678",
"address": "Street 1, City",
"country": "RO"
},
"items": [
{
"name": "Service A",
"quantity": 1,
"price": 100,
"vatRate": 19
}
],
"currency": "RON",
"issueDate": "2026-10-31"
}
In Power Automate, you’d build that payload dynamically using a Compose action. A robust pattern is to use the Expression editor to construct a JSON object rather than pasting expressions directly into a JSON literal. For example, in the Compose action’s Inputs, use:
json(
'{
"customer": {
"name": "' & triggerOutputs()?['body/CustomerName'] & '",
"vatNumber": "' & triggerOutputs()?['body/CustomerVAT'] & '",
"address": "' & triggerOutputs()?['body/CustomerAddress'] & '",
"country": "' & triggerOutputs()?['body/Country'] & '"
},
"items": [
{
"name": "' & triggerOutputs()?['body/ItemName'] & '",
"quantity": ' & string(triggerOutputs()?['body/Quantity']) & ',
"price": ' & string(triggerOutputs()?['body/UnitPrice']) & ',
"vatRate": ' & string(triggerOutputs()?['body/VATRate']) & '
}
],
"currency": "' & triggerOutputs()?['body/Currency'] & '",
"issueDate": "' & utcNow() & '"
}'
)
Note: Power Automate does not accept raw JSON with
@{...}expressions embedded as shown in conceptual examples; each dynamic value must be added via the Expression editor or dynamic content so that the resulting Compose output is valid JSON. The example above uses thejson()function and string concatenation to produce a proper JSON object.
Then configure the HTTP action:
POSTContent-Type: application/jsonAuthorization: value as required by SmartBill (e.g. Bearer <token> or API key header).The response is another JSON document with invoice metadata (ID, number, URL, etc.). Use Parse JSON with a schema derived from a sample SmartBill response, then write the invoice number back into SharePoint.
SmartBill’s API enforces a 3 calls per second limit. If your flows exceed that, you risk:
In our scenario, this matters when:
Power Automate itself has its own throttling and retry behaviour, but it does not automatically adapt to SmartBill’s external rate limit. If SmartBill returns 429 or similar errors:
You need to design the flow to:
For SmartBill, the main tools are:
Apply to eachIf you process a list of items (e.g. all new deals for the day), Power Automate’s Apply to each can run iterations in parallel. That’s dangerous for an API with a low per-second limit.
For the SmartBill HTTP call:
Apply to each settings, turn off or limit concurrency.1 to serialize calls.This ensures:
If you need higher throughput but still respect 3 calls/sec, you can:
Inside the Apply to each, after the HTTP action, insert a Delay action:
PT1S (1 second)This simple pattern:
Example: processing 60 invoices
If SmartBill returns 429 (Too Many Requests):
Typical pattern:
Exponential.You can also:
outputs('HTTP')?['statusCode'] in a Condition.Be careful not to create infinite retry loops. Always cap retries and decide what to do with items that repeatedly fail (e.g. log to a failure list and alert someone).
Without a connector, you manage authentication manually. SmartBill typically uses:
In Power Automate:
Pattern:
Authorization or custom header to that variable.This keeps the scenario maintainable for the finance and IT teams as they evolve SmartBill configuration.
Before:
After (HTTP-only integration):
No connector, no custom code deployment – just standard Power Automate plus a premium licence and careful handling of SmartBill’s limits.
If you’re integrating SmartBill with Power Automate today, treat the HTTP action like a hand-built connector: invest time in clean JSON payloads, strict concurrency control, and delay-based throttling around SmartBill’s 3-calls-per-second limit. That’s what keeps a simple SharePoint-to-SmartBill invoice flow reliable enough for real finance operations.
This article reflects the growing pattern of teams wiring SaaS finance tools into Power Automate via raw HTTP calls and careful throttling, especially in environments that rely on SmartBill but lack native connectors.
Professionals who want to apply these patterns to their own data can explore Excelgoodies' Power Automate Course programme - taught live by instructors, with certification awarded once a real project is running at work.
Insights compiled through ongoing industry research and discussions within the Excelgoodies Analytics Community.
Power Automate
New
Next Batches Now Live
Power BI
SQL
Power Apps
Power Automate
Microsoft Fabrics
Azure Data Engineering