A company creates multiple cases in Microsoft Dataverse each day with a status of New. For all cases with a status of New, the system must send an email to the customer and then change the status to…

A scheduled flow can periodically query Dataverse to find all cases currently in the "New" status, ensuring that all applicable cases are processed regardless of their creation or last update time. The flow would use a Dataverse action like "List rows" to retrieve the cases and then iterate through them to send emails and update statuses.

Triggering the flow only when a case is created would miss existing "New" cases that were created before the flow or other cases that became "New" through an update.

Triggering the flow only when a case is updated would miss cases that were created with the "New" status and never subsequently updated, or cases that were updated to "New" but the trigger only fires on any update.

Triggering the flow manually does not meet the requirement for an automatic process.