Hello! I'm currently working on a project to build a PowerApp using data from one of our internal business systems and am hoping to make sure that I've got the right idea on whether or not this is possible with PowerApps today. Because of a huge amount of business logic that happens with the source system we need to use the SOAP API from the legacy system vs. the PowerApps database connector (there's just way too much logic that we can't change within the source system that would be ignored if we did direct database connections).
Is it possible to build a custom API (presumably hosted in Azure and connected to our internal network with an Azure Gateway) that would interface with the internal-network-only SOAP services from the legacy system and then expose a REST API to be used by a PowerApp? I found https://powerapps.microsoft.com/en-us/tutorials/register-custom-api/ and other supporting docs that seemed to indicate that it is but after the last couple of months wanted to make sure I was the on the level with that approach.
As a bonus we have a Government O365 and Azure subscription which bring certain challenges to what is available, do you guys have any insight into other challenges that might be caused by having Government subscriptions? We're working on getting Commercial Azure right now but we've had some trouble getting a straight answer as to what is available within the Government space for certain things.
I would hugely appreciate any thoughts or help you might be able to provide, thanks!
Tim
