Unanswered

SQL Authentication and PowerApps trigger in Power Automate

(0) Share

Report

Posted on by cloudless54321

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @cloudless54321

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!

Was this reply helpful? Yes No
cloudless54321 15 on at

Like (0)

Report
Copy link

Link copied!

Powerapps trigger does not have "run only users "

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@cloudless54321

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!

Was this reply helpful? Yes No
cloudless54321 15 on at

Like (0)

Report
Copy link

Link copied!

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 .

Was this reply helpful? Yes No