Integrating Google Forms with Dataverse using cloud flows

Connectors in the Power Platform play a significant role when building solutions that incorporate services from Microsoft, other companies, or even your on-premises systems. As far as other companies go, many connectors (more than 700 at the time of writing) allow connectivity for such services.

In the case of Google, you will find connectors for Calendar, Contacts, Drive, Sheets, and Tasks. None work with Google Forms. You can build a custom connector to make this possible, but it might be hard to handle all the connectivity and security requirements needed.

For this recipe, we will leverage the capabilities of Google’s Apps Script included in Google Forms. This feature allows building JavaScript code with triggers to perform actions. In this case, we will transfer the form’s data on every submission to a cloud flow endpoint that sends a message to Microsoft Teams.

Getting ready

To build this...