Overcoming Power Automate ServiceNow Connector Limitations with a Custom Connector — Part 1

Problem with the Built-in ServiceNow Connector:

The built-in ServiceNow connector, while powerful for general integration tasks, falls short when it comes to specific requirements. One critical limitation lies in its incapacity to retrieve variable values and selectively fetch desired columns from ServiceNow instances.

Key Challenges:

• Variable Value Retrieval
• Selective Column Fetching

The Custom Connector Solution:

To overcome these limitations, the creation of a custom connector becomes imperative. A custom connector empowers users to tailor the integration according to their specific needs, providing the flexibility to retrieve variable values and selectively fetch desired columns from ServiceNow instances.

Let’s build a custom connector utilizing the ServiceNow API

Pre-requisites:

1. Access to Power Automate Maker Portal is required, along with a Power Automate account that has the capability to build custom connectors — a premium feature.
2. ServiceNow Account: Have access to a ServiceNow instance

Steps to create custom connector:

1. Logon to Power Automate.
2. Select Custom connectors from the left Menu. If not visible, Select More > Discover All > Locate…