Hi @Alex Barber,
Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.
The issue with blob triggers not activating your Azure function app in the Consumption plan may be due to the app going idle when there are no requests.
This can prevent triggers from firing until you access the overview page, which wakes the app and allows it to process pending events.
Additionally, there can be delays of several minutes between a blob being added or updated and the function being triggered. If you need faster response times, consider switching to a different hosting plan for more immediate trigger responses.
For further clarification, please refer to the following documentations: Document1, Document2.
I hope this information helps you understand and resolve your issue. If you have any further concerns, please feel free to reach out.