i have a gateway, i can connect to my SQL, i see SOME tables but i dont see THE table i want.
why is FLOW only showing me some of my SQL tables in my db and not the others?
any help would be appreciated
Could you please share a screenshot of your flow's configuration?
Could you please show a bit more about the table that you want to choose?
Further, do you want to use a SQL trigger for on-premises SQL Server within your flow?
I have made a test on my side and don't have the issue that you mentioned. I could choose all available SQL tables within SQL trigger:
Please check if the SQL table that you want to choose within SQL trigger is a temporal table, the temporal table is not supported in SQL Server connector of Microsoft Flow currently.
Also please check if there is a primary key in the SQL table that you want to choose within SQL trigger. If there is no primary key within your SQL table, it would not be shown up as a available table within SQL trigger.
In addition, the SQL triggers are not supported for on-premises SQL Server currently, the SQL triggers are only supported for Azure SQL Server.
More details about the Known issues and limitations of SQL Server connector, please check the following article:
thanks for the response. i should have posted earlier, i figured out why it wasnt working (through trial and error) and it was the lack of primary key on my table. once that was in it worked. i have it manually firing and then looks up the table in SQL to see if there's data, and if there is then it'll copy that to a list on Mailchimp.
What i've not been able to do is be dynamic with the list to add it to - ideally from a column in the table which has the mailchimplistname but i cant seem to get that accepted by flow / mailchimp
Do you need any other help?
In my case the primairy key was of type nvarchar(20). It works when the primairy key is of type Int. In Microsoft Dynamics NAV is a common used type varchar(20) for primairy key. This can't be changed.
Solution: Create a new table with a primairy key of type Int. Sync this new table with the original Microsoft Dynamics NAV with events.
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!