We are experiencing an issue when importing a Power Apps solution into a production environment.
Our Power Apps solution contains a canvas app that calls a Power Automate flow via clicking a button. The solution is working fine in the development environment. The problem arises when we export it and import it to the production environment. When calling the flow from the canvas app in Prod, the following error appears in the Live Monitor:
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.
RIA|SenddeliverableemailsfromPowerApps-Allclients.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 header." }
Every time we manage to fix an issue with the flow, another issue arises, everything else in the Canvas App works except the Power Automate flow calling. Could you provide us some help in this integration?
If anyone could help we would really appreciate it, thanks!
Are you using a regular connection in the Power App for SQL or are you using a Connection Reference? Based on the error message it looks like you have a direct connection to SQL instead of a Connection Reference. Shared SQL connections should use a Connection Reference instead of a Connection in Power Apps.
----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!
Paul Papanek Stork, MVP Blog: https://www.dontpapanic.com/blog
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
170
Share
Report
All responses (
Answers (
