We have the following setup;
I'm trying to create a Flow which connects to an on-premise CRM web service and return the results. Whenever this runs it fails with a BadGateway error.
When setting up the Connections, do we use HTTP with Azure AD. and If so, do we use Connect directly or Connect using on-premises gateway? We currently have it setup with the latter using our previously configured data gateway (which works as I've used it for Power BI).
If I try and use the Connect directly option, we get an error about the resource principal not being found in the tenant. Just seems like there are so many moving parts and so many differing configuration options with no clear path on how to do anything when you stray from the well documented all in the cloud setup.
Solved! Go to Solution.
Hi @sparkymark75,
Unfortunately there is no simple solution to your setup.
Ideally you'd want to keep everything in the cloud, especially if you take into consideration latency issues between your on-prem data and the gateway you will have to setup which will be routed through a region designated data center (so even if it's installed on an on-prem server, it will be routed through a datacenter).
I'm including here a good article with best practices when it comes to creating apps:
https://powerapps.microsoft.com/en-us/blog/powerapps-canvas-app-coding-standards-and-guidelines/
Hope this helps.
Thank you,
Ovidiu
Hi @sparkymark75,
Unfortunately there is no simple solution to your setup.
Ideally you'd want to keep everything in the cloud, especially if you take into consideration latency issues between your on-prem data and the gateway you will have to setup which will be routed through a region designated data center (so even if it's installed on an on-prem server, it will be routed through a datacenter).
I'm including here a good article with best practices when it comes to creating apps:
https://powerapps.microsoft.com/en-us/blog/powerapps-canvas-app-coding-standards-and-guidelines/
Hope this helps.
Thank you,
Ovidiu
Thanks. Sadly the answer I expected but didn't hope for.
So in summary; Power Apps is great if all your data sources are in the cloud. If you have anything on premise, you're going to struggle.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
199 | |
97 | |
56 | |
51 | |
42 |
User | Count |
---|---|
264 | |
157 | |
83 | |
80 | |
57 |