Premium connectors in Power Automate: SQL Server, HTTP and Dataverse

Premium connectors in Power Automate unlock integrations with business-critical systems — SQL Server, REST APIs, SAP, Salesforce and Dataverse. They require a Power Automate Premium or per-flow license.

SQL Server connector — read and write

// Trigger: Schedule (every day at 07:00)

// Action: Get rows (SQL Server)
  Connection: SQL_Prod (SQL auth or Azure AD)
  Table: dbo.Pending_Requests
  Filter Query: Status eq 'Pending' and CreatedDate le '@{addDays(utcNow(), -3)}'

// Loop: Apply to each (over the results)
  // Action: Update row (SQL Server)
    Table: dbo.Pending_Requests
    Row Id: @{items('Apply_to_each')?['id']}
    Status: Escalated
    EscalationDate: @{utcNow()}

HTTP — call any REST API

// Action: HTTP
  Method: POST
  URI: https://api.bconcepts.pt/v1/projects
  Headers:
    Content-Type: application/json
    Authorization: Bearer @{variables('token')}
  Body:
    {
      "name": "@{triggerBody()?['ProjectName']}",
      "client_id": @{triggerBody()?['ClientId']},
      "start_date": "@{formatDateTime(utcNow(), 'yyyy-MM-dd')}"
    }

// Parse JSON — extract fields from the response
  Schema: { "type": "object", "properties": { "id": {"type": "integer"} } }
// Use the generated id in the following actions

Error handling with Try/Catch

// Configure "Run after" on the error actions:
// Action: HTTP → If it fails:
  // Action: Send email (run after: has failed, timed out, skipped)
    To: ops@bconcepts.pt
    Subject: "ERROR in flow: @{workflow()?['name']}"
    Body: "Error: @{result('HTTP')?[0]?['error']?['message']}"

Variables and advanced expressions

// Useful expressions:
formatDateTime(utcNow(), 'dd/MM/yyyy HH:mm')
addDays(utcNow(), -7)
toLower(triggerBody()?['email'])
concat(variables('BaseUrl'), '/api/endpoint')
first(body('Get_rows')?['value'])?['id']

Conclusion

Premium connectors turn Power Automate into an enterprise-grade integration platform. With SQL Server, HTTP and Dataverse, you can replace custom integrations with flows maintained by business teams with minimal technical oversight.