Email SharePoint Calendar Events for Today

(0) Share

Report

Posted on by Guru22

Hello!

I have a sharepoint online calendar that I would like to access and email myself some information.

Here is some of my criteria.

The flow needs to run daily at 1am.
I only want the current days events; not all events.

I am having problems filtering to only include events of the day. Could someone help me out? What value would I use to get only the current days events?

Screen Shot 2018-08-04 at 3.59.10 PM.png

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

mgiuliani 21 on at

Like (1)

Report

I think my solution in this thread will help you accomplish what you're looking for.

Was this reply helpful? Yes No
v-yamao-msft on at

Like (1)

Report
Hi @Guru22,

If you want only to get the current days events, I assume that you want the events that will start on today.

So I have made a simple test on my side and the flow is configured likes below.

The function used in the Filter array is:

@equals(formatdateTime(item()?['EventDate'],'yyyy-MM-dd'), formatDateTime(utcnow(),'yyyy-MM-dd'))

In the action Send an email, please make sure enable Yes for the Is HTML field.

Please take a try with it on your side.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
GabrielStJohn on at

Like (0)

Report

Hello, @Guru22!

Have you had an opportunity to apply @v-yamao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

Was this reply helpful? Yes No