Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

SQL Get Rows with filter - Messed up output


I'm using the action SQL Get rows (v2) to get a list of users from a data base view. To get only active users I added the filter query "Status eq 1". I thought that it worked as it should until i noticed that 3 users (of ~2500) was missing. To test I skipped the filter inside the action but added an array filter action with "@equals(item()?['Status'], 1)". Now I got all the users but strangely I got the exact same number of users in both scenarios. Further investigation showed that I had a couple of duplicates in the scenario with the filter inside "Get Rows" instead of my missing users. Can any one explain this behavior?

Community Support
Community Support

Hi @Spångberg 


You can try by enabling pagination on the Get rows action in Flow, you can find this by clicking on the 3 dots and then settings:


On there, you can select the number of records that you can to retrieve with pagination:




Best Regards,


If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution



Pagination is already enabled and that seams to be part of the problem if it combines with filter.


  • If I disable pagination I don't get any duplicates (although I only get 2048 of 2276 records in the output).
  • If I enable pagination and filtering i get 6 duplicates (that does not exist in the SQL database).
  • If I enable pagination but filtering in a "Filter array action" it seams to work.
  • If I enabling pagination and filtering AND putting an unique value (like Email or EmployeeNo)  in "Order by" it seams to work. A non unique value i "Order by" (like Status) generates duplicates.


So, the best workaround seams to be to put a unique value in "Order by' but the bug still annoys me...



// Tomas

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,310)