Answered

Sharepoint Calendar Notifications Flow

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

Categories:

Using flows

I have the same question (0)

All responses (29)

Answers (1)

Sort by

ArchitectMadhan 1,584 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The date format you use for utcnow is "yyyy-mm-dd", but you didnt specified the date format you get from the substring. Please make sure both are having same format. Also without getting all events from the SharePoint, you could have used the filter query option to get list items that are required to send the remainder email.

If you feel the above solution works for you, please mark this as solution.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi there,

Thanks for your reply. Can you draw up the formula here? I am not sure how to draw this formula up.

Also, how would I do the filter query option? I have tried to do this but I´m no expert on this and would like to learn how to use.

Thanks!

Stuart

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

See my example below. I used Filter Query as suggested by @ArchitectMadhan . Get items will retrieve only events for today. Please note that this will not work with recurring events. Also, note the single quotes in my filter query. Finally, SharePoint stores dates in a yyyy-MM-dd format. Finally, you may to make an adjustment for your timezone.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Okay, I see what you are doing in the filter query but can you please provide the formulas in text format so that I can copy and paste? Do I also need to edit the substring in the condition?

I need the formula in text to copy and paste into my formula.

Thank you for your help!

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

The formulas that I used are shown in the comments section of the Get Items action.

formatDateTime(utcNow(),'yyyy-MM-dd')

addDays(utcNow(),1,'yyyy-MM-dd')

If you copy and paste, you'll probably want to remove and replace the single quotes.

Also, you shouldn't need your condition - it was checking the date. With the filter you will only receive items that meet your criteria specified in the Filter Query. If you use my example, just send an email inside of the loop at the bottom of my Flow.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is still giving me error... I have tried to change the the "1" in the add days to "0". Still doesn´t do anything...

Was this reply helpful? Yes No
ArchitectMadhan 1,584 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The screenshot is not clearly visible for me, could copy and paste the error message alone?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ArchitectMadhan

Here you go:

The expression "EventDate ge '2021-07-03' and It '2021-07-04'" is not valid. Creating query failed.
clientRequestId: c2812021-ff28-4569-8d44-8cca906f7484
serviceRequestId: c2812021-ff28-4569-8d44-8cca906f7484

Thanks

Stuart

Was this reply helpful? Yes No
ArchitectMadhan 1,584 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please check whether the Event Date field is of "Date only" type in SharePoint calendar.
like show in the screenshot

Was this reply helpful? Yes No
ArchitectMadhan 1,584 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

If you want to know step by step process to send reminder email using Power Automate Schedule Flow, please follow the steps given in the below link.
https://learningtechnixs.blogspot.com/2021/07/send-reminder-email-for-tasks-nearing.html?m=1

If the above post is helpful for you to solve the problem, please mark it as solution.

Was this reply helpful? Yes No