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!!
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
Proud to be a Flownaut!
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
64 | |
27 | |
21 | |
15 | |
13 |
User | Count |
---|---|
125 | |
46 | |
44 | |
35 | |
31 |