I have been building a POC help chatbot. One topic of the bot is to check on upcoming renewals.
An end-user would request to check their upcoming renewals and then an adaptive card appears.
They enter information about their query and submit this request.
This info is then passed to a Power Automate flow which uses the "Execute and SQL Query V2" connector to find their renewals in our SQL db.
This is the only connection used within the flow and is configured correctly as I have used it before in other flows.
The flow has only one "Run-only user" which is the bot itself. This is also configured so that when it is ran it uses the prebuilt SQL connector rather than the users credentials.
However, when a user goes to run the flow the bot asks for additional permissions.
Why is this? I have been searching and tweaking settings but nothing seems to work. I need the connection to be hard coded as I do not want to give every user SQL admin so that they can hit it themselves.
If you have any advice please assist. Thanks!
33
Share
Report
All responses (
Answers (
