How can we use SQL Get Rows to display data using Views?
Thanks for creating the idea. We will ask for the connector support.
Michael Leyshon commented
Have you tried "Enter custom value"? In here I can enter the name of my view and select rows from it without a problem.
Usman Mohammad commented
Not having views kind of prevents us from adopting functions and logic apps and as peter said, it doesn't make the SQL connector look complete.
I'm surprised this doesn't have more votes.
Given Logic Apps are 'a way to simplify and implement scalable integrations and workflows' it seems odd to have to query multiple tables in Logic Apps when you could create a companion view in SQL server.
The SQL connector doesn't seem complete without the ability to get rows from views.