Answered

Sharepoint Calendar Notifications Flow

(0) Share

Report

Posted on by Community Power Pla...

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:

All responses (29)

Answers (1)

Verified answer

ArchitectMadhan 1,580 on at

Like (0)

Report

Re: Sharepoint Calendar Notifications Flow

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.
Community Power Pla... on at

Like (0)

Report

Re: Sharepoint Calendar Notifications Flow

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 1,580 on at

Like (0)

Report

Re: Sharepoint Calendar Notifications Flow

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.
Community Power Pla... on at

Like (0)

Report

Re: Sharepoint Calendar Notifications Flow

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

Regards
Community Power Pla... on at

Like (0)

Report

Re: Sharepoint Calendar Notifications Flow

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...
ArchitectMadhan 1,580 on at

Like (0)

Report

Re: Sharepoint Calendar Notifications Flow

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.
Community Power Pla... on at

Like (0)

Report

Re: Sharepoint Calendar Notifications Flow

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 1,580 on at

Like (1)

Report

Re: Sharepoint Calendar Notifications Flow

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.
Community Power Pla... on at

Like (0)

Report

Re: Sharepoint Calendar Notifications Flow

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 1,580 on at

Like (0)

Report

Re: Sharepoint Calendar Notifications Flow

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.