Issue while using Connector for Microsoft Power Platform

[AnupamaJaiswal]

Hi Team,

We are trying – “Connectors for Microsoft Power Platform” from Digital Exchange and facing below issue for which we will need your intervention or help.

While following the attached guides, we are updating the function host keys in “General Information” of Connectors,

Reading from our Azure Function (published as suggested in guides)-

Although during the test call, we are getting Unauthorised Error (404 Response) but the Request URL is displaying some different path, should it not be pointing to above mentioned host URL of Azure function?

URL - https://europe-001.azure-apim.net/apim/blue-20prism-5f95c943ae2f7220d9-5f1a0fbe1f3c371bc5/0c5a34ed213f41409bfb766011c91ba8/api/BluePrismRestInterface?code=PyHWvD18al105dHja9xB7mrrluoGVfhnPUsJuru9MOyP9...

Also, please note we were unable to create/publish the connector with the exact name as displayed in guide- “PowerPlatformConnector”, does it have any dependencies on the name?

Kindly let us know if you would need any input from our end to review this. It would be great if we can connect to understand the blockers here.

 <also attaching the email communication initiated on this thread>

Thanks,

Anupama

[ewilson]

@AnupamaJaiswal,

So you’re getting a 404, not found, response. The function is located within Azure, in the cloud. Where is the BP runtime resource that you’re trying to communicate with? Is it an Azure VM or something within your corporate network?

While you can see the RR from your machine it seems anything running in the cloud cannot.

Cheers,
Eric

[pashupati.mishra20]

I made it work by deploying portable AZURE function locally on one of our VDI on internal network. Here's what I did:
1.I kept the function running on VDI, It is on localhost:port
2.Installed Microsoft On-Premise gateway on any VDI that is up 24x7.
3. Setup Custom connector Scheme : HTTP, and check Connect via On-Premise gateway.
4. Provide address of VDI that is running your azure function.
5. Select authentication as none ,as we will be authenticate by On-Premise gateway itself. (On-Premise gateway need to be shared with users who will be accessing this endpoint).
Again I used it in only test environment, You might need to add authorization part to azure function itself because it will be accessible by everyone on local network.

[AnupamaJaiswal]

Hi Eric,

After further analysis it looks like there was no Functions/End points available in our Function app, even though it allowed us to publish the app and was appearing in our Azure Portal.

Please find the below comments from MS support team on trying to resolve this deployment/publishing issues- 

1. As you were using zip deploy method to deploy the Function app code but due to having setting WEBSITE_RUN_FROM_PACKAGE enabled already it was failing.
2. After removing the setting, we created D:\home\data\SitePackages file and packagename.txt document in same directory and tried Zip deployment, but it failed too.
3. Then we tested Function app locally and it failed on runtime because the application code you downloaded from gibhub has been developed on ASP.NET Core 2.1 framework and your Visual studio was running on ASP.NET Standard Framework.
4. We found the same issue even after updating the ASP.NET Core 2.1 SDK in your Virtual Machine.
5. The function app you are trying to deploy needs to be build with .NET Core framework and published on Azure Functions.
6. We checked that the Visual Studio installed in your VM is not picking .NET core framework and that’s why we are getting an incompatible framework error in VS.

On point 5 above, is there something which we can do to fix? Please let us know any steps/guide to follow specially on downloading the BP connector code and publishing to Azure, via Visual Studio. Any program or configuration dependency in deploying this? 

Appreciate any help here! Let us know if you have any questions. 

Thanks,
Anupama

[ewilson]

Hi @AnupamaJaiswal,

​I’m not sure where MS Support came away with the idea that the project was built using ASP.NET Core 2.1 unless that’s the only framework that’s available on the machine you published from. The project was built with .NET Standard 2.0 as shown the screenshot below:


If the machine you’re deploying from does not include the .NET Core 2.0 framework, you’ll want to install and then redeploy the Azure Function. Once deployed you should be able to look at the Functions runtime version by going to your Azure Portal, navigating to the Function app, and then selecting Settings → Configuration → Function runtime settings. It should show ~2 as depicted below:


Cheers,
Eric

[AnupamaJaiswal]

Hi Eric,

Can you please help me understand the statement you mentioned below- "If the machine you’re deploying from does not include the .NET Core 2.0 framework, you’ll want to install and then redeploy the Azure Function"

We did try to install .NET Core Framework from the link here- https://dotnet.microsoft.com/download/visual-studio-sdks?utm_source=getdotnetsdk&utm_medium=referral but then it wasn't reflecting in out framework options, like below it shows .NET Standard Framework only.


Please note, when we are publishing the function for the second time (first time it didn't give us any error and hence was reflecting in Azure portal) its giving following build error- 
"it was not possible to find any compatible framework version" & "metadata generation failed"

Also, the runtime version on the Azure portal is showing ~2 for us

Please let us know your views on it and kindly share any insights if you can gaze any probable error what we are doing here?

Thanks,
Anupama

[ewilson]

Hi @AnupamaJaiswal,

Apologies on the .NET reference. I actually meant to type .NET Standard 2.0, not Core. Was this present when you published the function the first time? Also, did you see my message, from Sept 2nd, regarding access to the runtime resource?

Cheers,
Eric​

[AnupamaJaiswal]

Hi Eric,

Please find responses for your below ques-
1. Was this present when you published the function the first time? - yes it was showing .NET Standard framework and for first time we published in that framework and later anytime for testing while publishing again it threw build errors. 
2. Where is the BP runtime resource that you’re trying to communicate with? Is it an Azure VM or something within your corporate network?- The BP run time resource is in our QA Azure VM environment., within our corporate network.

Please let us know if you or someone from team is available for a quick call for a faster resolution.

Thanks,
Anupama

​

[ewilson]

@AnupamaJaiswal,

The examples you've shown for invoking the runtime resource do not include a port number. Do you know what port your runtime resource is running on? The default port is usually 8181​, so if I wanted to call a runtime resource running on my local machine I would reference it as 127.0.0.1:8181. Please verify what port your RR is running on then update your Custom Connector definition in Power Automate to include the port number in the resourceName definition.



Cheers,
Eric

[AnupamaJaiswal]

Hi Eric,

The Runtime resource is running on 8181 only, when we tried to add the port in the Resource name and update the connector-


Its showing that the connector is update-


But it is reverting back to the old resource name (without the port)-




I did test the connector after trying to update this 2-3 times and same 404 error is persistent.


Thanks,
Anupama

[ewilson]

Hi @AnupamaJaiswal,

​Ok, did you try manually adding the port definition to the resourceName entry on the Test screen? That should at least let you test using the exact port and will hopefully either show that it works or possibly give us a different error response.



Cheers,
Eric