Slide 1

Slide 1 text

Create a custom connector in Power Platform from scratch Pune Tech Community Tuesday, 22 Sept 2020

Slide 2

Slide 2 text

About Aroh Technical Consultant, Microsoft MVP, MCT & Nintex vTE Experience: Office 365, SharePoint Online, Data Platform Office 365 Consultant & Power Platform Trainer LinkedIn: https://www.linkedin.com/in/arohshukla/ Blog: aarohblah.blogspot.com @aaroh_bits Aroh Shukla

Slide 3

Slide 3 text

Connectors in Business Application Platform Connector architecture How to build a connector 2 Demos Agenda

Slide 4

Slide 4 text

Microsoft Power Platform Power BI Business analytics Power Apps Application development Power Automate Process automation Power Virtual Agents Intelligent virtual agents The low-code platform that spans Office 365, Azure, Dynamics 365, and standalone applications Innovation anywhere. Unlocks value everywhere. Common Data Service Data connectors AI Builder Portals

Slide 5

Slide 5 text

Power Apps: a low-code approach to building apps

Slide 6

Slide 6 text

What Can Power Automate Do? Automation at scale Seamless, secure integration Accelerated productivity Intelligent automation

Slide 7

Slide 7 text

Power Automate is Designed For Everyone Power Automate is the automation service for everyone in your organization. Experienced Developers Experienced Developers IT/Admins IT/Admins End Users End Users Experienced Developers IT/Admins End Users

Slide 8

Slide 8 text

(including on-prem applications) 275+ app connectors

Slide 9

Slide 9 text

A is a wrapper around an API that allows the underlying service to talk to and

Slide 10

Slide 10 text

Quickly generate and customize apps based on Excel files, SharePoint Online lists, Dynamics 365, Salesforce records and more. You can even connect custom APIs. Even connecting to data in your local systems through the common on premise data gateway. Your apps will be able to fully interact with underlying sources and will respect the permissions you’ve already established in them. Your product here! Connect to cloud AND on-premise data

Slide 11

Slide 11 text

Public connectors available to all users Custom connectors built for your organization

Slide 12

Slide 12 text

Why build a connector? Enterprise developers Looking for connectivity to a service we don’t currently support Need connectivity to a custom or internal service Partners and ISVs

Slide 13

Slide 13 text

Building a Custom Connector Build, secure and describe your API Import from existing artifacts (Open API, Postman) or build from scratch Validate your API calls Use in Power Automate and Power Apps for E2E testing Allow other users within your organization to use your connector

Slide 14

Slide 14 text

Building a Custom Connector Build, secure and describe your API Import from existing artifacts (Open API, Postman) or build from scratch Validate your API calls Use in Flow and PowerApps for E2E testing Allow other users within your organization to use your connector Share your connector with all users of Power Automate and PowerApps

Slide 15

Slide 15 text

Improving your custom connector - Add descriptions and friendly names - Help your users understand the operation - Define more operations - For every POST, there’s typically one or more GETs For Power Automate: - Use Dynamic Values (e.g. Dropdown for users) and Dynamic Schema - Provide a better experience for users in the designer - Add triggers through WebHooks (build a small web application that can accept the HTTP requests) - Using the webhook

Slide 16

Slide 16 text

No content

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

Custom connector architecture Power Apps Power Automate

Slide 19

Slide 19 text

Using your own Web API Office 365 Power Apps Power Automate 1. Call a flow 2. Call QB Online API 3. Returns results as JSON 4. Returns results as string

Slide 20

Slide 20 text

Securing your Web API PowerApps Microsoft Flow

Slide 21

Slide 21 text

Demos Using Weather API (Power Automate) 1 Google Books API (Power Apps) 2

Slide 22

Slide 22 text

References • Define overview of Connectors: https://docs.microsoft.com/en-us/connectors/custom- connectors/ • Using Postman collection: https://docs.microsoft.com/en-us/connectors/custom- connectors/define-postman-collection • Custom Connectors in Power Platform: https://medium.com/capgemini-microsoft- team/custom-connectors-in-power-platform-9cc73c333799 • Exchange Rate API: https://alphabold.com/creating-a-custom-connector-for-power-apps/ • Weather API: https://weatherstack.com/documentation • Google Books API: https://developers.google.com/books/docs/v1/using • Google Books API video sample https://www.youtube.com/watch?v=cSzI093-xgk