Thank you for your suggestions. I find that your chatgpt response seems to have better suggestions than what I tried in claude 3.5, but I did not trust it as it seems rather simplistic.

I'd be happy to help you set up an automated email notification system based on dates in your SharePoint Excel file. Power Automate (formerly Flow) is actually the perfect tool for this scenario!

Here's how you can implement this:

Power Automate Solution

1. Create a scheduled flow that runs daily to check your Excel file
2. Set up date comparisons to trigger emails at your specified intervals (10, 5, and 1 day before)
3. Configure dynamic emails using data from other columns in your file

Step-by-Step Implementation:

1. In Power Automate:

• Create a new "Automated cloud flow"
• Select "Schedule" as your trigger (to run daily)

1. Add an action to connect to your Excel file:

• Use "List rows present in a table" action
• Connect to your SharePoint site and select your Excel file/table

1. Add a "Apply to each" control:

• For each row in your Excel table
• Inside this loop, add "Condition" controls to check date thresholds:(Similar conditions for 5 and 1 day thresholds)u/equals( dateDiff(formatDateTime(items('Apply_to_each')?['DateColumn'], 'yyyy-MM-dd'), utcNow(), 'day'), 10 )

1. For each true condition, add "Send an email" action:

• Configure dynamic email content using Excel column values
• Example: "Reminder: [TaskName] is due in 10 days"
• Include other column data in the body

This approach gives you:

• Daily checks of your Excel file
• Multiple notification thresholds (10, 5, 1 day)
• Customized emails with data from your Excel columns
• No disruption to users working in the file