Filter Array, limits to 100 records

(0) Share

Report

Posted on by chico

638

Greetings,

There are many posts here on SharePoint limits of 100 and how to get around it.

This is not SharePoint related.

Very simple flow;

Manual Button Trigger
o365 user connector - "Search for users"
Search field is left blank and it returns 2k+ records
This part works well, goes very fast
Data Operation connector - "Filter Array"
From = @outputs('Search_for_users_(V2)'
@contains(item()?['City'], 'CityXYZ')

CityXYZ has 327 entries when looking at the raw outputs of Search for users
Output of Filter Array does not go above 100

anyone have any thoughts on why the Filter Array stops at 100?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Double check the number of users returned by the search for users method of the users connector. I'm fairly sure that method is limited to return a maximum of 100 users. That is a common issue when using it to populate a combo box in Power Apps. It should be the same in Power Automate. I've also run a test using filter array on a large SharePoint list where the filter array returns over 1,000 or the 2,000 records returned by the Get Items.

Was this reply helpful? Yes No
chico 638 on at

Like (0)

Report

@Pstork1 ,

confirming that as of this very moment, when I run the flow I return 999 unique users from my Search for Users step

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Not sure why your filter array is then limited to 100. I don't have a tenant available for testing with over 50 users. But I did test filter array with a 5,000 record SharePoint list. My Get Items is set to return 2,000 and the filter array then returns over 1,000 of that 2,000. So its not a built in limit. What is the filter that you are using?

Was this reply helpful? Yes No
chico 638 on at

Like (0)

Report

Hi @Pstork1 ,

We have another Flow in our org that does similar steps and every week its able to Filter an Array of over 2k records... We use it for an offline org browser app.

The Filter I'm using on mine is based on the City.

Also,
yesterday this flow was consistently pulling over 2k records..
as of this morning it wont pull more than 999

Could it be that a Flow can simply get corrupt?

EDIT:
yesterday this flow was consistently pulling over 2k records via the SearchUsers step

Was this reply helpful? Yes No
chico 638 on at

Like (0)

Report

@Pstork1

Looks like this case was a good example on why the copy/paste of actions can be dangerous.
Re-created the flow without copy/paste and all works fine.

Appreciate you taking the time!

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

I haven't seen copy/paste cause this kind of issue, but its definitely possible.

Was this reply helpful? Yes No