I am trying to see if this is achievable. I have a list that contains users birthdays. When a new user is added to the list, obviously the flow would trigger, checking that new item and is stuck in phase 2 until it is a week before the users birthday to send a notification/reminder email. Then after that, it doesn't do it the next year.
Is it possible to have a flow that runs from a list, and constantly checks items to see if the birthday column date is close to the current date? Instead of triggering on creation, waiting (with the possibility of failing because how far out it could be), then actually going through.
UPDATE:
https://docs.microsoft.com/en-us/power-automate/run-scheduled-tasks , I tried the following from this article, but it tells me that there is no dynamic content available?