Hi,
I am using MySQL Get rows connector to connect to a MySQL database.
I can see all the tables in MySQL database. BUT, I cannot see any Views in MySQL database.
Is this the expected behavior?
May be I can do something like this to get around this hurdle?
https://powerusers.microsoft.com/t5/Building-Flows/Join-Two-Datasets-in-Flow/td-p/354458
dchan
I actually just tested this out today. If you do a custom input for your Table as "DB.View", you should be able to query the view as if it were a table.
View not listed:
Custom Input:
Successful Output:
To the best of my knowledge the MySQL connector for Power Automate does not support MySQL views, just databases.