web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL trigger: when an i...
Power Automate
Unanswered

SQL trigger: when an item is created always says no new data?

(0) ShareShare
ReportReport
Posted on by 24

I noticed flow has added SQL server triggers. But when I tried using the 'SQL Server: When an item is created' trigger it always says 'No new data' even though rows that match my filter have been added.

 

I reffered to documentation of the SQL connector https://docs.microsoft.com/en-US/connectors/sql/

It says 

 

When invoking triggers, there are the following limitations:

  • Trigger is not supported for on-premises SQL server

If this is why, then what kind of SQL Server does these triggers support? Azure SQL?

Categories:
I have the same question (0)
  • v-yuazh-msft Profile Picture
    Microsoft Employee on at

    Hi @ henrypei,

     

     

    Yes,you are right, these triggers support the Azure SQL as you guessed.

     

    You could refer to link below to experience yourself with Azure SQL:

    https://azure.microsoft.com/en-us/services/sql-database/

     

     

    Regards,
    Alice Zhang

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 304

#2
David_MA Profile Picture

David_MA 245 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 243 Most Valuable Professional

Last 30 days Overall leaderboard