Hi guys,
I need some help with a flow I'm building.
We have a New Starter's list which is filled out by HR with all new starters.
They set a start date with a date picker.
The issue I'm having is that I want to send them a reminder 2 weeks and then 1 week before the set start date (dynamic content)
Now, I can figure out how to set it to wait until the actual start date but the question is how to set it to send 2 reminder emails respectively 1 and 2 weeks before that start date.
I cannot set a timed delay, because they enter the data at random intervals. Sometimes it's months in advance, sometimes it's 2 weeks before the start date.
I found a getPastTime function, but I don't know how to build the syntax. I've tried several iterations but I always get an error.
I'll give an example, for better understanding.
HR Person adds entry to sharepoint list for new employee 1 > HR person adds start date with date picker > flow must wait until 2 weeks before set start date > send reminder to HR person (do whatever last checks).
The email part is clear, but the "delay email until 2 weeks before set start date" is causing me the troubles.
Can someone give me a hint how to do it?
