Filter from sql server to excel !

[Shivaji]

Hey,

I have to select only particular jobs.

My query is, It extracts all rows from the table, where i need to select (FILTER) only particular rows.   

I have herewith attached the screenshot where i need only JN572 Newyork and JN600 Brooken Bridge inside FLOW

In the filter query, i need to select   JN572 Newyork and JN600 Brooken Bridge .

Please guide me, how to do this?

Any help is appreciated!! 

[ChristianAbata]

hi @Shivaji  what you need to do is a Select SQL sentense like this

Select * from your table where Job_details = 'JN572 Newyork' and Job_details = 'JN600 Brooken Bridge' 

Please try first in an SQL management 

[rohentz]

Hi @Shivaji how are you?

Take a look on my sample about tblPeople. Selecting only records with John and Meg.

At SQL Server 

At Power Automate use <column> <eq> <value>

I hope that this could helped on your question.

Please let me know if you have any doubts or concerns about the solution provided . If this helped on your question, please mark the post as completed.

Regards.

Rodrigo Hentz

Microsoft Support Engineer