Daily Notification Flow fails when I attach Last Month's List

Susan Fioribello

My Daily Notification Flow works pretty well and reliably. We want to send the same report but for the previous month. The monthly report fails but it never gives a detailed reason.

I tried copying the daily notification flow and changing the list it is pulling but it always fails. I also tried building a new version from scratch, but the same thing happens.

is there a limit of how times it will run the different loops?

I have several loops as it goes through each gift for the donor, fundraiser, and appeals. There can be several hundred gifts in the monthly report. I'm wondering if I am exceeding a limit somewhere.

Austen Brown

@Susan Fioribello - Can you share on what action the flow is failing and what error message Power Automate provides?

Susan Fioribello

@Austen Brown
There isn't much information given. Here is the error message:

That's it. No other information.

Here is where the failure is occurring:

I tried running it today and it worked. The only difference was the number of gifts in the list was under 400. The above flow was run for the month of July and exceeds 400.

This makes me wonder if there is a 400-record limit for these flows.

Austen Brown

@Susan Fioribello - Is there a particular action within the apply to each that was failing? The limit for PA apply to each actions is pretty high and wouldn't be a factor here. That's a good question to ask though.

Susan Fioribello

@Austen Brown
It looks to me that it fails at the Condition which is Count is equal to or greater than 1.

Even though the condition is true, it appears to fail.

However, maybe it is the failure is happening at the “For each”. I can't really tell.

Here is the For each, I copied the condition issue previously:

Austen Brown

@Susan Fioribello - Keep going on the deep dive, further into the apply to each - you're looking for a specific action that's failed. When a particular action fails everything above it within the flow (apply to each's, controls, etc.) will also show as ‘failed’.

Alex Wong

@Susan Fioribello
As stated by Austen, you need to find the “real action” that failed, the action that is inside the condition > apply to each.

click on the >! button to go to the loop that has a failed real action and screenshot that and the edit mode of that action