Every Power Platform Connector Worth Knowing in 2026

The Power Platform ships with over 1,000 connectors, which sounds impressive until you need to pick one. In practice, around 20 connectors do the heavy lifting in almost every real solution: SharePoint, Outlook, Dataverse, HTTP, Teams, Approvals, and the rest of the list below. This cheat sheet covers every Power Platform connector worth knowing, what each is genuinely for, and the gotchas that only show up in production.

Want the hi-res version? It's free in the Powercademy Success Kit.

How many connectors matter out of the 1,000+?

About 20. The long tail exists for specific SaaS products, but the connectors below cover data, communications, approvals, AI, storage, and external APIs - the building blocks of nearly every flow and app you will ever ship. Learn these well and the rest follow the same patterns.

What are the 20 connectors worth knowing?

1. SharePoint - The heart of the Microsoft ecosystem. Triggers, files, attachments, and a secret REST API via the Send HTTP request action.

2. Outlook (Office 365) - Email and calendar. HTML bodies, attachments, importance flags, and shared mailbox sending.

3. Dataverse - The native Power Platform database. Server-side logic, a proper security model, and cross-environment actions.

4. HTTP - Calls any REST API. The Premium escape hatch when standard connectors run out.

5. Teams - Adaptive Cards turn Teams into a UI layer. Post, wait, and react in one flow. Also great for comms.

6. Office 365 Users - Resolves UPNs to managers, photos, and departments. The foundation of every approval routing pattern.

7. Excel Online - Read and write Excel tables. Mind the row ceiling - pagination is mandatory on real datasets.

8. OneDrive - File CRUD and path lookups. The Convert file action turns Word and HTML into PDF for free.

9. Microsoft Forms - Intake forms, surveys, and lead capture, all inside your Microsoft environment.

10. Approvals - Sequential, parallel, custom responses, reassignment, mobile-native, and a full audit trail.

11. Power Apps - Canvas apps trigger flows. Pair with Respond to a Power App to return data back to the app.

12. Power BI - Refresh datasets, push streaming data, manage workspaces, and trigger data alerts.

13. SQL Server - Azure SQL, on-premises SQL, and Managed Instance. Reclassified as Premium in 2024.

14. AI Builder - Run a prompt for generative text, and document AI for invoices, receipts, and IDs. Choose your model.

15. Azure OpenAI - Your own Azure OpenAI deployment: bigger context windows, model choice, and tenant data residency.

16. Azure Blob Storage - File storage at scale. When SharePoint and Dataverse are not viable, Blob handles millions of files.

17. HTTP with Microsoft Entra ID - Hits Graph, Dataverse, Power BI, and Business Central with delegated auth and no app registration.

18. Salesforce - Triggers, CRUD, and bulk operations on Salesforce objects. The Microsoft-meets-Salesforce bridge.

19. DocuSign - Trigger envelopes, send signatures, and react to status webhooks. End-to-end signing in one flow.

20. Encodian - 200+ actions for PDFs, Word, Excel, OCR, and document AI. Breaks through the limits of native Power Automate actions.

Which of these connectors are Premium?

Dataverse, HTTP, HTTP with Entra ID, SQL Server, Azure OpenAI, Blob Storage, Salesforce, DocuSign, and Encodian all require Premium licensing (or run inside a licensed context such as Dynamics 365). The standard tier still covers a huge amount: SharePoint, Outlook, Teams, Forms, Approvals, Excel, OneDrive, and Office 365 Users are all included with most M365 plans. Plan your architecture around this early - swapping a data source after go-live because of licensing is one of the most expensive mistakes on the platform.

FAQ

The hi-res version is in the Powercademy Success Kit - free, along with hundreds of other cheat sheets, roadmaps, and guides for Microsoft professionals.