Filter Array, limits to 100 records

(0) Share

Report

Posted on by chico

636

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?

All responses (6)

Answers (0)

Pstork1 67,060 Most Valuable Professional on at

Like (0)

Report

Re: Filter Array, limits to 100 records

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

Like (0)

Report

Re: Filter Array, limits to 100 records

@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!
chico 636 on at

Like (0)

Report

Re: Filter Array, limits to 100 records

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
Pstork1 67,060 Most Valuable Professional on at

Like (0)

Report

Re: Filter Array, limits to 100 records

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?
chico 636 on at

Like (0)

Report

Re: Filter Array, limits to 100 records

@Pstork1 ,

confirming that as of this very moment, when I run the flow I return 999 unique users from my Search for Users step
Pstork1 67,060 Most Valuable Professional on at

Like (0)

Report

Re: Filter Array, limits to 100 records

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.

Community site session details

Filter Array, limits to 100 records

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Filter Array, limits to 100 records

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates