Could you adivse ?
We have a calendar setup as the App calendar in SP Online which holds tasks for users leaving and starting. I have built a flow which would look at the item when its created and throw a notification few hours before the time end on the item. However, the flow erros if the item is more than 30 days away.
What would be a better solution for such calendar ? I would like to be notified every morning (if there is a starter/leaver) about upcoming starters or leavers.
Hope this makes sense.
Flows can run for a maximum of 30 days. To work around that limit, you can use a recurrence trigger. See my example below. In my example, the Flow runs once an hour. The get items action returns only those items where the start time is between 3 and 4 hours away. The expressions I used in the filter query are in the comments of the get items action. The list I used is a calendar.
Okay, that makes sense,
If i have an event that is a whole day event can i then input these into an email the day before the even ends ?
Baisically - If even is tomorrow, send an email one day before that at 10 in the morning as a reminder
This would make it little more organised i think.
In your original post, I got the impression that you wanted the emails to go out a few hours before the event started - that's why I fire the Flow every hour and look at events 3 to 4 hours out. You can adjust what I have done to accommodate any advance notice - I am keying off of when the event starts. So, for example, you could adjust it to look for events that start between 24 hours and 48 hours out vs 3 and 4 hours simply by changing the expressions to reflect 24 rather than 3 and 48 rather than 4. Also, you can set the recurrence to run once a day and even tell it at what time you want it to run. Let me know if you need additional help.
If i set it to run lets say at 8 in the morning to show me all events for that day and do between 9 oclock and 5 oclock, do i then do it like your example and it will look at everything between 9 and 5 right ?
Here is an example that runs at 8:00 and will retrieve events starting between 9 and 5. Be sure to set your time zone as appropriate. You may want to adjust the recurrence to start at 7:59 vs 8:00 - I suspect that starting at 8:00 may miss some events that start exactly at 8:00.
I have tried to re-create this and ran a few times, it doesnt seem to return any values when ran, nor send an email.
I dont think its finding the items. Maybe i have entered the filters wrong ?
Please see screenshot, maybe i have done something wrong ?
If you run the Flow without your filter, does it return any items? To test this, put a control terminate action after Get items so that emails don't get sent. Take a look at the output of Get items - does it show that items were returned or does it just show [ ] ?