News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion Using triggers for row...

Power Automate - General Discussion

Suggested answer

Using triggers for row add or update in SQL server MDS table

(0) Share

Report

Report

Posted on by CU03011412-0

Hello team,

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?

Categories:

Process Advisor

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

abm abm 32,265 on at

Like (0)

Report

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 144,858

#2

RandyHayes 76,287

#3

Pstork1 64,505

Leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans