Hello, i have problem with one of my flow. Without any change in code from me, flow suddenly stop working and i dont know why.
I use PowerApps app and button, that trigger MS Flow and when i press button, i get this message:
SQL.Run failed: { "code": "InvokerConnectionOverrideFailed", "message": "Failed to parse invoker connections from trigger 'manual' outputs. Exception: Could not find any valid connection for connection reference name 'shared_sql_1' in APIM tokens header." }
I tried:
1) delete Flow, make a new one (without copying)
2) delete Flow from app, publish and add again
3) make a new app and new Flow
4) Export and then Import, re-add in app
5) delete all SQL connectors and make a new one
6) delete flow, connectors, and insert them into new app.
Anything what i found on the internet or there on the forum, nothing works for me.
Nothing working... only what i found is that, when i delete SQL Query (V2), flow working OK. But i need my Flow to work with SQL query.
This is my Flow, only PowerApps trigger - get variable - SQL query (V2) - response to PowerApps.
I have second app (like for test purposes) with second flow (same as the flow that dont work) and this two for now working... i dont understand that, really. Thanks for all help, i am really hopeless now.
Solved! Go to Solution.
Today i run my app throught mobile app and flow finally start working, i was so happy, so i go to the creator studio, press the button and now that error message show right in the creator studio... oh god please, somebody must look at this problem.
EDIT: I just deleted Flow from Power Apps and then re-add it again and now everything working fine in creator, on mobile app and also on another user. Thanks to MS for solving this problem.
Do you have the problem when pushing the button in the maker? My similar problem is only on Android Devices...
In the maker (eu.create.powerapps.com) i have no problem. When i am on my iOS device or Android and i am on my creator account i have still the same issue. So in the maker, everything OK, very strange.
Also try embedding it on a sharepoint page and see if that works, because it did for me. But something seems to be wrong "external" devices.
Today i run my app throught mobile app and flow finally start working, i was so happy, so i go to the creator studio, press the button and now that error message show right in the creator studio... oh god please, somebody must look at this problem.
EDIT: I just deleted Flow from Power Apps and then re-add it again and now everything working fine in creator, on mobile app and also on another user. Thanks to MS for solving this problem.
Hi all, I also got this error when the button, that should run the flow, was clicked in my CanvasApp. The solution was simple:
1) remove the flow from the app (i.e. go to the PowerAutomate menu in the left panel, click on the three dots next to the linked flow and click on "remove from app").
2) add the flow to the app again.
I noticed that, whenever I made changes to the flow, especially when I added new connections in the flow, I received the error and had to do this trick of removing and adding the flow in the CanvasApp.
User | Count |
---|---|
6 | |
6 | |
4 | |
4 | |
2 |