Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Flow cannot find my SQL Server table



I have a strange problem with the SQL Server connector. I have a database in Azure SQL Server. If I create a Flow, using "When an item is created" option with the SQL connector, I can see my table just fine and the flow works. However, if I select "When an item is modified", I can't find any tables with the same connection settings? I attached a couple of screenshots to demonstrate the issue. The texts are in Finnish, but I translated the important parts.




Any idea how to fix this? I have already tried to recreate the SQL connection.

Community Support
Community Support

Hi @ilied,


Does the issue still exists?

Have you take a try to clean up the browser cache?



Best regards,


The issue still exists. I have tried it with a couple of different browsers and the cache has been cleared. It's worth noting, that my database table has a primary key, which is a requirement, I believe.

New Member

I have exactly same issue.  When an item is created" option with the SQL connector, it's showing 'Table Name' options and the flow works. However, if I select "When an item is modified", I can't find any tables with the same connection settings. Any help please!

Is this issue resolved?


Hi @ilied 


Have you tried typing the the table name by using "Enter Custom Value" ?

Also, does these tables have a "row version" column ?

It not, then try to add a column of type timestamp, this is the way Power Automate tracks the modifications in the records.

After creating the timestamp field try to re-create the trigger to pickup the SQL changes. 

Hope this helps.


Best regards 








 "Enter Custom Value"  didn't work. My requirement is to trigger when a new entry is added.

I saw another article where it says you need to have an identity column in the table. After adding that, it showed my table in the list.



Hi @vrkorada 


Based on your requirements, you should use a different trigger "When is Item Created".
The article is correct with this type of trigger 

To summarize the trigger

- "When is Item Created" needs to have a primary key in the table to be picked up by power automate.

- "When is Item Modified" needs to have a timestamp (row version) column the table to be picked up by power automate.

You shouldn't face the missing tables issue with triggers as long as you created the tables correctly.


Glade that it is working for you.


Best Regards


Yes the issue has been resolved. My team found that it's the limitation of the product that we need to have timestamp column type created in the table to trigger sql connector. Thank you. 

Hi @Johnson 


Thank you for your reply and for confirming that it worked for you. 

I would like to add that It wouldn't be considered as a limitation , it is just the way power automate works , see when a record/row is modified it doesn't communicate with power automate to start the trigger , but it is the other way around. Power automate checks for changes in the records during intervals of time and it knows the changes by this timestamp field. 


Hope this was informative for you.


Best Regards 


Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (3,746)