Power Platform Community Forum Thread Details

Hi @ASmithRouse,

The behavior you’re experiencing occurs because the flow is iterating over all rows in the table, and while the condition checks for a date match, the row addition is being performed for all rows. To fix this and ensure only rows matching today’s date are added, you can refine the flow logic as follows:

Solution: Apply a Filter Before Adding Rows

List Rows from the Source Table:
- Use the "List rows present in a table" action to retrieve rows from the source table.
Filter Rows by Date:
- Add a "Filter array" action immediately after listing the rows.
- Configure the Filter array to include only rows where the date matches today’s date.
  - Use the following expression for today's date:
    
    formatDateTime(utcNow(), 'yyyy-MM-dd')
  - In the Filter array condition:
    - Select the column containing the date.
    - Use the expression equals with the dynamic content for the date and the above expression.
Add the Filtered Rows to the Target Table:
- Use an "Apply to each" action and feed the output of the "Filter array" step as the input.
- Inside the loop, add an "Add a row into a table" action to insert only the filtered rows into the target table.

Example Flow Outline:

Trigger: Your desired trigger (e.g., when the source Excel file is updated or a manual trigger).
List rows present in a table: Retrieve all rows from the source table.
Filter array: Filter rows where the date column matches today’s date.
- Example filter condition:
  - Field: items('Apply_to_each')?['DateColumn']
  - Condition: equals(items('Apply_to_each')?['DateColumn'], formatDateTime(utcNow(), 'yyyy-MM-dd'))
Apply to each: Iterate over the filtered rows from the Filter array action.
- Add a row into a table: Add each matching row to the target table.

Why This Works:

By filtering rows first, only the rows that match today’s date are passed into the "Apply to each" loop, ensuring only these rows are added to the target table.
The condition to match the date is evaluated once in the Filter array action, reducing unnecessary processing and ensuring accuracy.

Debugging Tips:

Verify Filter Output: Add a Compose action after the Filter array step to inspect the output and confirm only matching rows are being passed.
Check Date Format: Ensure the date format in the source Excel file matches the yyyy-MM-dd format used in the filter condition. Adjust the format in the expression if necessary.

Let me know if you need further clarification or assistance in implementing this flow. 😊

Best regards,
@Ninjasabi