Sharepoint Calendar Notifications Flow

[Anonymous]

Hi there,

I have built an Event Reminder Flow whereby it sends an email reminder when an event in my Sharepoint Calendar is going to happen. I have built it with a substring formula so that the EventDate is equal to the UTCNOW however when I run the flow it sends me all of the events in the calendar i.e. it is not recognising the date in question.

My guess is that there is a problem with the substring or UTC formulas. 

I have tried making the events in the calendar all day events and a specific time frame and it´s not working. Events are also not recurring, they have all been put in individually. I originally thought it might be because the column EventDate is also taking into account time but it just returned me error when I put this in. 

Please help me out. 

Thanks!

Here is my flow:

[ArchitectMadhan]

Hi @Anonymous ,

There is a problem in the formula. Try this finally:

EndDate gt "@{formatDateTime(utcNow(),'yyyy-MM-dd')}" and EndDate lt "@{formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')}"

If you feel this post is useful for you solve the issue, please accept this as solution.

[Anonymous]

Hi @ArchitectMadhan 

What you sent me via private message worked  

BUT...

What it has done is sent me a reminder for the events that were today and before today... (In my calendar I have 1 event today and 2 events in June) If I am only interested in sending me the events for today how do I do this?

Thank you for your help so far!

[ArchitectMadhan]

Hi @Anonymous ,

EndDate eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'

If you feel this post is useful for you solve the issue, please accept this as solution.

[Anonymous]

Hi @ArchitectMadhan 

So I just replace the original formula 

EndDate gt '@{formatDateTime(utcNow(),'dd-MM-yyyy')}' and EndDate lt '@{formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')}'

with

EndDate eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'

?

[ArchitectMadhan]

Hi @Anonymous 

yes, you are right.

If you feel this post is useful for you solve the issue, please accept this as solution and give thumbs up.

[Anonymous]

Hi @ArchitectMadhan 

Okay, I have done this but it has not sent me an event I have today at 4pm i.e. in 45 mins time. Why would this be?

It seems to not be detecting today´s date...

[Anonymous]

@ScottShearer Would you be able to provide any input on the last message I sent?

Regards

[ArchitectMadhan]

Hi @Anonymous ,

To get the list items that are have the Due Date as today, we need to use the below conditions listed in the link.

https://learningtechnixs.blogspot.com/2021/07/checking-date-in-filter-query-within.html

Please accept this as solution, if this post is useful to solve the issue. It will motivate me to reply for many queries.

[Anonymous]

Hi @ArchitectMadhan 

This is providing 0 items even though I have an event in the past on this date. Why is this?

The formula I am using is : EndDate eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'

As you can see the EndDate format is the same as the formula. Can you advise?

[ArchitectMadhan · Accepted solution]

Hi @Anonymous ,

Schedule the flow to run daily early morning 3am. To test it run flow manually.

Please accept this as solution, if this post is useful to solve the issue. It will motivate me to reply for many queries.