I have created a powerapp, and connected it to some power automate flows, which are published in solution. Each flows are used to call stored procedure from the SQL server.
We found that the flows often get disconnected, and the error message: "Connection Not Configured for this Service".
We later found a solution to this issue, which we set the run-only user property in each flows to a specific connection for actions related to the SQL server, and such issue got resolved temperarily.
However, after a week and so, the connection problem happened again, and we found that in some flows, some of the connections used in run-only user property got updated automated to "Provided by run-only user", which cause the connection issue.
We got around 100 flows in Solutions, it is impossible for us to check each flow's run-only user property one by one everytime when we face the connection problem.
Is there any ways to ensure that all the flows are using the same connection to SQL server, or is there any notifications for us to check which flow's run-only user property is changed?
Thank you.
4
Share
Report
All responses (
Answers (
