PowerApps to call SOAP webservice

[Anonymous]

Hi,

Anyone successfully connect web service which is in SOAP?

Mind to share the concept?

I tried to create Azure logic app but get error on "Failed to fetch". Even if it is successful, I have no idea on how to connect it to PowerApps as I am new on Logic Apps and Azure.

Hopefully someone can share their experiences here.

Thank you

[goobernoodles]

I have used Azure Automation Runbooks for interacting with our ERP software's SOAP based web services.  I only use it for pushing data into the software, since it's not exactly a fast mechanism.

If you are new to SOAP and haven't yet made a successful call, you may want to consider downloading Soap UI here:  https://www.soapui.org/  You can use Soap UI to explore the web service and figure out how it works.

If you already know your endpoint URL, you basically just need to create a WebServiceProxy to it, and then call methods within.  In my case below, the first 3 lines are concatenating the endpoint URL as:  https://myserver.com:port/wsdls/AddJob.jws

First, you effectively connect to the server with the New-WebServiceProxy function and store the response in a variable.  If your endpoint is valid, that variable should contain methods or "functions" that the web service can perform.  In my case below, if I was to run the commented out line of $proxy | gm, it would have included a method for "AddJob".  The other thing you should do at this stage is to look at the definition of the method, which includes all of the expected parameters for the method.

From there, you build a command like below to execute the action/method you're trying to perform like such:

$WebServiceProxy.MethodName(

"ExpectedParameter",
"ExpectedParameter",

"ExpectedParameter"

)

This is very helpful for basic understanding of the concepts in play:  https://codingbee.net/powershell/powershell-web-services-wsdl-and-soap

Since every software/situation is different, you may want to look at this if authentication is required: https://thycotic.force.com/support/s/article/API-PowerShell-Scripts-Getting-Started 

Hope this helps.  Soap isn't the best.

[v-xida-msft]

Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want to call SOAP webservice from PowerApps app?

If you wantto call SOAP webservice from a PowerApps app, I afraid that there is no way to achieve your needs in PowerApps currently.

If you want to call your own web service from PowerApps app, I think the custom connector functionality could achieve your needs. But for PowerApps and Microsoft Flow (Power Automate), you must support stable HTTP REST APIs for your service. Please refer to the following article for more details:

https://docs.microsoft.com/en-us/connectors/custom-connectors/faq#requirements

As an alternative solution, I think the combination of PowerApps and Microsoft Flow (Power Automate) could achieve your needs. On your side, you could consider fire a flow (Microsoft Flow) from a canvas app, then within the flow, you could add a "HTTP" action to call your SOAP webservice, then add a "Response" action or "Respond to PowerApps or flow" action to return retrieved results back to your app.

I have made a test on my side, please consider take a try with the following workaround:

Microsoft Flow configuration:

App's configuration:

Note: The XML data type is not supported in PowerApps, but the result returned from a SOAP Webservice is a XML data, you need to convert the xml data into a json data using json function (WDL Expression) in MS Flow, then return the converted json data back to your app.

More details about firing a flow from an app, please check the following article or video:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

https://www.youtube.com/watch?v=1wl9AtxWdkg

More details about returning data back to app from a flow, please refer to the following blog:

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

Please take a try with above solution, then check if it could help in your scenario.

Note: Currently, there is no way to intergrate PowerApps app with Azure Logic Apps. You could consider use Microsoft Flow (Power Automate) to achieve your needs instead of Azure Logic Apps.

Best regards,

[HEATFreight]

How can I call a SOAP Custom Connector directly within a Canvas App???

I can't figure out what I'm doing wrong here. No matter how I change the syntax, I get the same error: "The server returned an HTTP error with code 500."

Click here to see my post.

The Custom Connector works fine when I input the body text directly within the >Test tab of the Custom Connector editor as well as within a Flow action. It seems to me that something is off with either the syntax of the body or the formatting of the response. Is Power Apps not able to receive an XML response?