Thanks for the response. I appreciate the guidance.
The logic makes sense, especially around triggering at the root level and using conditions to filter paths dynamically. I’m still getting familiar with Power Automate, and my first attempt ended up sending out 200 emails, one for every file added to the folder. So I’m trying to refine the conditional expressions, particularly the dynamic path filtering.
Here’s the folder structure I’m working with:
- Root:
Document Library/2025/
- Subfolder:
SF-2509, SF-2510, etc. (new ones created monthly)
- Inside each:
Month folder (based on subscription type)
- Inside that:
Southroads.txt
So each SF folder eventually contains a Southroads.txt file, and I want to detect when a new one appears
What I’ve tried so far:
- Trigger: When a file is created (properties only) [SharePoint]
- This correctly triggers on new file creation.
- But filtering down to just the new
Southroads.txt inside the correct SF folder is proving tricky.
I’m now considering whether it’s better to detect when a new folder is created under 2025 (e.g., SF-2511) and then send a notification like “Hey, there’s been an update!” That way, I avoid the flood of emails from individual files.
Still unsure how to best structure the condition to avoid triggering on every file. Any tips on using dynamic path values or trigger conditions to limit this would be super helpful.
