Hello,
I'm having trouble with a Power Automate flow that I've set up to send email alerts based on conditions in an Excel spreadsheet. The spreadsheet contains project members, key dates, alert status (marked as 'N' for not sent and 'S' for sent), and email addresses.
The flow is set up to run on a weekly basis. It reads the rows from the Excel table and is supposed to send an email alert to each project member whose "Alert Status" is 'N' and whose "Key Date" is less than or equal to the current date.
However, the flow is sending emails to all project members, regardless of their "Alert Status" or "Key Date". It seems like if there's a single row with "Alert Status" as 'N', the flow sends emails to everyone.
Here's the basic structure of my flow:
- Recurrence trigger (runs weekly)
- List rows present in a table (points to the Excel file in SharePoint)
- Apply to each (input is the output from the previous action)
- Condition: checks if "Alert Status" is 'N' and "Key Date" is less than or equal to the current date
- If yes: Send an email (V2) to the project member
I've checked the data in Excel and the flow configuration, and everything seems to be set up correctly. I'm not sure why the flow is sending emails to everyone instead of just the members who meet the condition.
Any help or suggestions would be greatly appreciated. Thank you!
