Email notification if excel table contains date in two weeks
Apologies, my knowledge of Power Automate is very basic! I'm trying to set up a flow to get an email notification if there are any dates in my excel table that that are coming up in the next two weeks. How do I go about this?
So far I have set up a recurrence, 'list rows present in a table', 'apply to each', and then I'm assuming a condition needs to be set up to scan for appropriate dates. If that date matches what I'm looking for (ie. it is in two weeks), I can then add an action to send an email.
It's what the condition needs to be that I'm stuck on! If anyone can help it would be much appreciated.