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

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 

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

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 

Power Apps: a low-code approach to building apps 

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

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 

(including on-prem applications) 275+ app connectors 

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

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 

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

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 

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 

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 

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 

No content

No content

Custom connector architecture Power Apps Power Automate 

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 

Securing your Web API PowerApps Microsoft Flow 

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

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