web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Pages SQL Server connector t...

Power Pages

Unanswered

SQL Server connector triggered flows not working

(0) Share

Report

Report

Posted on by midhun_heart

37

I have established a successful connection to an SQL Server. I have created two flows, one to trigger "When an item is modified (V2)" and another one to trigger "When an item is created (V2)". Whenever I make a valid create or update at the SQL Server side, the flows are not triggered. One thing to note here is that the credentials used to establish a connection with the SQL server is having only read only permission, that too on two table.
Note: The flows are attached to those two tables only.

Is it possible that the flows are not triggered because of the read only permissions??
I was under the impression that SQL server connection relies on polling to identify change and does more privileges or access permissions required to perform the same?

pa-2.png

pa-1.png

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

I have the same question (0)

All responses Img

All responses (0)

Answers Img

Answers (0)

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Register Today: Microsoft Business Applications Update- April 15th

Your Invited to Keeping It Real with the Power Platform

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

#3

oliver.rodrigues 30 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans