I there a way to set up an automation that sends an notification when a flow and it's multiple subflows fail. I have it currently setup so that it I have one automation sends out 45 emails , but I would like it to send out one email with the status of each of the subflows. My preference is to do this from the prefect ui but I can also do it in my code as well.

hmm, i dont think that possible with only automations, however, I think you could have an automation kick off another flow run that collects the information you want, and then sends an email from within the flow.

Is it possible in the notifications email to loop through the sub flows using jinga?

Nah i dont think so because the subflows are not part of the event payload that we pass to the jinja template

Ok I managed to get the data for the status of subflows into a dataframe. Is there a way I can cna pass the dataframe to prefect to send it as a notification? I am trying to avoid sending an email with python.