Unanswered

SQL View Connection

(0) Share

Report

Posted on by Community Power Pla...

I have a view in my SQL table that does not show up when I use the SQL Get Rows action. Is it not possible to use views to get data this way? It appears that others are using views but I can't seem to figure out why the view is not showing.

Thanks in advance for any suggestions or information.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (1)

Report

Re: SQL View Connection

Hi @Anonymous ,

Table name of the Get rows action will only display the options for SQL table, not including SQL View.

If you want to list all records in a view, by using Get Rows action in MS Flow and entering the view name (case sensitive) as a custom value in Table name field. It returns a list of records form the view.

Image reference:

Please take a try.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: SQL View Connection

thank you that worked

Was this reply helpful? Yes No