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…

While a scheduled flow is appropriate, the "Filter array" data operation is used to filter an existing array of data within Power Automate, not to query data directly from Dataverse; the "List rows" action is needed first to retrieve the data.

Triggering the flow only on case creation would miss existing cases that were created prior to the flow's activation or other cases that achieve "New" status via updates.

Triggering the flow only when a case is updated would miss cases that were initially created with a "New" status and never subsequently updated, meaning they would not be processed.

A scheduled flow periodically runs, and the Dataverse "List rows" action is specifically designed to retrieve multiple records from a Dataverse table, allowing filtering to target cases with the "New" status for processing. This ensures all existing new cases are identified and acted upon automatically.