Microsoft Flow – PowerApps – Create your own custom version of standard connectors

Did you know that you can customize standard connectors in Microsoft Flow? Well you actually can’t modify them but you could create your own version as a custom connector.

Normally you would use the custom connector options within the Flow UI, avoiding manual json editing.

PowerShell for PowerApps and Flow

You will need to start by downloading the PowerShell for PowerApps and Microsoft Flow. For instructions see the Microsoft site.

One of the commands available within this module is the Get-PowerAppConnector. Making it easy to get all the details for any of the connectors available in Flow and or PowerApps. If you wanted to get the SharePoint connector details you could run:

[code lang=text]
Get-PowerAppConnector -EnvironmentName “$Environment” -ConnectorName shared_sharepointonline
[/code]

Get the swagger

But there is more to this command. with the -ReturnConnectorSwagger switch you can get the swagger file as a PowerShell object.

[code lang=text]
$swagger = (Get-PowerAppConnector -EnvironmentName “$Environment” -ConnectorName shared_sharepointonline -ReturnConnectorSwagger).Swagger
[/code]

Convert to Json

Then the swagger file can be saved as a json file using the ConvertTo-JSon Cmdlet.

[code lang=text]
$swagger | ConvertTo-Json | out-file “e:\SharePoint.json”
[/code]

Fixing the json

There is still a small problem to resolve the paths of each action appear a bit messed up.

The below lines of PowerShell will generate the json that you would need in the method (get, post etc) sections for each path.

$members = $swagger.paths | Get-Member

foreach ($member in $members)
{
if ($member.MemberType -ne "Method"){
$Name = $member.Name

$swagger.paths."$Name" | ConvertTo-Json
}
}

Pieter Veenstra

Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com