Hello!
I am needing to create a Flow that sends an email out Monday-Friday (each day) showing who is on vacation from our Sharepoint Calendar. I have a Flow that works but it is only sending the first day of vacation and not each day if the event is recurring.
Example: Tom enters vacation on the sharepoint calendar starting Monday 2/11/2019 and ending Friday 2/15/2019. I need the flow to send an email all 5 days showing that he is on vacation.
Also how do you make Flow only send an email during the work week and not on weekends?
I appreciate all assistance!
Solved! Go to Solution.
It looks like you don't have single quotes at the end of your dates.
It should be
EventDate le '2019-02-08' and EndDate ge '2019-02-14'
See how the date is enclosed in single speech marks?
- Mark
I am sorry I cannot get it to work. In the Filter Query of the Get Items I have this.
What am I doing wrong?
It looks like you don't have single quotes at the end of your dates.
It should be
EventDate le '2019-02-08' and EndDate ge '2019-02-14'
See how the date is enclosed in single speech marks?
- Mark
Thank you! I wish I had someone to assist me like that all the time!
How can I get this flow to not send an email when there are no events on the calendar?
User | Count |
---|---|
95 | |
45 | |
21 | |
18 | |
18 |
User | Count |
---|---|
142 | |
50 | |
43 | |
40 | |
31 |