You’re offline. This is a read only version of the page.
15
Hello Folks, I just need a clarification regarding the SQL Authentication and the trigger of Powerapps in flow.
I get that the Powerapps trigger in workflow uses the credentials of the user that triggers the flow and the SQL Authentication connection uses the credentials I declared when I built it. Now , I encounter an issue when other user trigger the flow that uses the sql authentication with direct connection (cloud services). "Flow.Run failed: Connection not configured for this service.".
What is the best connection when using a Powerapps trigger?
Thank you
Yes, it is the powerapps trigger. "Manage Only Users " is available only in "Manual trigger" and not available in power apps trigger based on what I research. It uses the credentials of the user who runs the flow however I have a SQL action inside the flow that configured as SQL Authentication type where it only uses the credentials of the owner who built the connection that's why I like to know what type of SQL connection is best with Powerapps trigger .
You should use the Power Apps V2 trigger for the run only users feature.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Powerapps trigger does not have "run only users "
As the Power Apps trigger is a type of manual trigger, you can configure run only users. In the flow details page, you should be able to see a section for configuring run only users in the right side of the page.
In that section, you will be able to see all the connections used in the flow and then you can configure settings for those connections if they should be provided by the run only user or if the flow should use the flow owner's connection for the selected service. Once you configure these settings, refresh the flow in the Power App and publish the app. This will fix the issue.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Share
Report
All responses (
Answers (
