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.

Paths in swagger file

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
}
}

Flow custom connector code in swagger file

 

By Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using contact@veenstra.me.uk.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: