How to understand Filter array after a Get Items from Sharepoint step?

(1) Share

Report

Posted on by WebPortal

2,291

Hi all,

I don't understand Filter array...

The 1st step gets a bunch of items from a Sharepoint list, the filter query works perfectly.

However, I need a second filter and I don't want to include it in the Get Items filter.

Thus, the Filter Array.

It returns empty. Why?? Can someone please explain??

It is supposed to return all the items where ID > 1.

I have the same question (0)

All responses (7)

Answers (1)

abm abm 32,605 Most Valuable Professional on at

Like (0)

Report

Re: How to understand Filter array after a Get Items from Sharepoint step?

Hi @WebPortal

Those actions step looks good to me. Check the run history and see the ID's returned from the SharePoint Get Items actions step. It could be its not returning anything at all. Post a screenshot of the run history please.

Thanks

Was this reply helpful? Yes No
WebPortal 2,291 on at

Like (0)

Report

Re: How to understand Filter array after a Get Items from Sharepoint step?

@abm

That's right. The Get items step is not returning anything.

The maximum ID I get from Power Automate is 199.
However, in SharePoint, the max ID I have is 620.

Any ideas?

Was this reply helpful? Yes No
creativeopinion 10,480 Super User 2025 Season 2 on at

Like (0)

Report

Re: How to understand Filter array after a Get Items from Sharepoint step?

Click on the three dots of the Get Items action.> Settings.

Toggle on pagination and adjust the threshold.

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
WebPortal 2,291 on at

Like (0)

Report

Re: How to understand Filter array after a Get Items from Sharepoint step?

Ok, I have it with 5000.

Was this reply helpful? Yes No
abm abm 32,605 Most Valuable Professional on at

Like (0)

Report

Re: How to understand Filter array after a Get Items from Sharepoint step?

Hi @WebPortal

Whats the total number of records in that list?

Thanks

Was this reply helpful? Yes No
WebPortal 2,291 on at

Like (0)

Report

Re: How to understand Filter array after a Get Items from Sharepoint step?

It is 15000 rows roughly.

I guess that's the problem.

Was this reply helpful? Yes No
Verified answer

abm abm 32,605 Most Valuable Professional on at

Like (0)

Report

Re: How to understand Filter array after a Get Items from Sharepoint step?

Hi @WebPortal

Yes looks like thats what causing it. So if you have a standard license the threshold limit is 5000 and if you have premium license you can set uptp 100,000

So if you are on 5000 then implement the pagination technique to get rest of the data.

Have a look at this video about pagination

https://www.youtube.com/watch?v=O3D2F62DuRk

Thanks

Was this reply helpful? Yes No