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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL Trigger Not all ta...
Power Automate
Unanswered

SQL Trigger Not all tables are displaying

(0) ShareShare
ReportReport
Posted on by

I am connecting to an on prem server. I would like to use the When item is created (V2) trigger for a SQL Server. The table list does not display all of the tables. However if I add the Get Rows action to the same flow all of the tables are displayed. I did come across an article from 10/31/17 about needing to have a column called "IDENTITY" to use the New item trigger. The article also mentions the trigger does not work with on prem servers. Since the article is 3.5 years old can anyone verify this information is still accurate? I ask because the article has a link to an article indicating the triggers are just being introduced.

Categories:
I have the same question (1)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard