We have Master data service database in SQL 2022 on premise server. We need to connect this database in power automate flow. We know that we need to set up On premise data gateway and then use that SQL server connectors in flow. We need to trigger our power automate flow when any record in created or updated in MDS? Could you please tell us that is it possible to trigger? Also tell us more about the license. Will it use license of user whose credentials are used to make connection?
Using triggers for row add or update in SQL server MDS table
Hi
You need two flows to trigger. One for when a new record is created and the other one is when an item is modified.
Use a generic account (Something like a system account or an integration account) so that it won't tied up with one specific users.
The flow will use the license of the user who owns or created the flow. If the connection is tied to a specific user's credentials, the license of that user is required. If your organization uses a per flow plan, any user can trigger the flow without additional licensing.
If you use a per user plan, each user executing the flow must have the appropriate license.
Thanks
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.
Share
Report
All responses (
Answers (
32,856
