What happens when a list has a larger count than the LIMIT?

Chris Zello

If I have a list that exceed the 5000 LIMIT, how would I go about getting my flow to search all the records?

Thanks.

Austen Brown

@Chris Zello - I'd utilize a “Do Until” loop to cycle through the List xxx call until it reviews all results. Here's a previous post with alternative options for how to solve this:

Carol Grant

@Chris Zello- Hi Chris- I would actually use a query if you can or a List if it is over that many. There is a query connector now which might make it easier. Can you limit those constituents in a query?

Chris Zello

@Carol Grant Because I'm trying to look over all the records in the system, the best I could do would be a query on Non-Deceased. But then again, it could be possible that some deceased records have Attachments, and I would want to clean that up.

After receiving @Austen Brown ‘s reply, I followed through to the link, and in reading what was written, I’ll need help in figuring out what to do for a Loop.

Thanks.

Alex Wong

@Chris Zello
are you trying to get all the constituent in your RE NXT and how many are there?

Chris Zello

@Alex Wong While there are over 300K records, I think I figured out a way to query on this.

In webview, I was able to Query on Media Date Not Blank. In looking over the records, this is what is showing in the Attachments panel. I can address things there.

So I don't think I need to go through all the records and have Power Automate find the records to create a list. Unless I'm mistaken, the Media search in the new query tool is searching in Attachments, which is all I need.

Alex Wong

@Chris Zello
what are you trying to query on?

FYI: Media in Query is not the same as Attachment on webview.

Chris Zello

@Alex Wong Update…I've done additional review of these records. While a number of records in database view have Media on them AND at first glance, they happen to have webview Attachments, removing the Media from database does not remove the Attachment. Not all records with Media have Attachments, and not all records with Attachments have Media. These records are both Individual and Organizations.

So YES what I need is a way to identify the records that have Attachments. If I look at all records in our database, that would be over 300K records. This is far more than a 5K limit.

The best first step for me would be to use a query named “Key Indicator = Organization STATIC”. This yields just over 10K records.

Alex Wong

@Chris Zello
There is no efficient way to get a list of all constituent with attachment, since the only API endpoint that's available for getting attachment info is single constituent. You will need to search/create a new Idea in Idea Bank to ask for this.

Chris Zello

@Alex Wong I've put this in the Idea Bank: