I have an issue with a flow which is triggered from PowerApps.
We are using this flow is for inserting mass data to Azure SQL table, because the Patch and Collect functions are extremely slow when inserting multiple rows.
So there is a text box on a hidden screen, where the insert SQL text is dynamically built by the Concatenate function and this text is sent by Flow to Azure SQL.
We are using the app from 14 iPhones and it was working without any issue in the beginning.
Around a month we get the “Connection not configured for this service” error message randomly.
It works perfectly from my phone and browser but from other phones with 40-60% success.
I can’t see any error message in Flow, because this issue happens at PowerApps side.
What I did:
- Copied the flow with new name and connect again to power apps
- Create the flow from scratch
- Share the flow with others (I read this in other forum posts, but does it make sense?)
It’s very confusing because none of the steps above helped and I can’t find and other solution on the Net.