cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
EYOST
Level: Powered On

PowerApps to call SOAP webservice

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

2 REPLIES 2
goobernoodles
Level: Powered On

Re: PowerApps to call SOAP webservice

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.

Community Support Team
Community Support Team

Re: PowerApps to call SOAP webservice

Hi @EYOST ,

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:

1.JPG

App's configuration:

2.JPG

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,894)