Flow filter date range (today)

(0) Share

Report

Posted on by tupues

121

Hi all,

I am trying to create a timed flow from the list below, that runs each day at 3pm to produce an event in the calendar showing the next PDM on duty (the one below the one with the green line).

Screen Shot 2019-06-18 at 13.30.22.png

Below is the associated flow. I tried solving it by having a filtered list only showing me the next PDM and selecting it in the "Limit columns by view". Sadly it still created events for all items in the list which is not what I am after.

Screen Shot 2019-06-18 at 13.29.27.png

Any help would be greatly appreciated.

Many thanks and best regards,

Tom

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @tupues ,

Do you want to create an Outlook event if the event will happen on next day?

From the screenshot, it seems that not all the events will happen on the next day, some events happen every few days.

Please consider create the event on Outlook one day before its start date.

I have set up the flow using Filter query to find out the specific event that will happen on Tomorrow.

The function used is:

StartDate eq 'addhours(addDays(utcNow(),1),1,'yyyy-MM-dd HH:mm')'

Note: StartDate is a date and time column named as StartDate, in your case, it should be “From”.

By the way, please make sure the dates are in the same format.

An image for your reference:

Best regards,

Mabel

Was this reply helpful? Yes No
tupues 121 on at

Like (0)

Report
Copy link

Link copied!
Hi Mabel,

Thanks for your reply. The event created should be limited to the one occuring the same day at 4pm. So the flow should run 1hr before the event starts and create the event for the day.

Therefore it should be sufficient to have the flow look for:

From eq utcNow('dd/MM/yyyy')
Weirdly this returns me with error 400 every time...

"status": 400, "message": "The expression \"From eq 19/06/2019\" is not valid.\r\nclientRequestId: bd4f61fe-bc81-418a-8308-9d451f1c5ea9\r\nserviceRequestId: bd4f61fe-bc81-418a-8308-9d451f1c5ea9" }
What is it that I am missing?

Many thanks for the ongoing support!

Best regards,

Tom

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @tupues ,

Please make sure the function is always surrounded with a single quote, otherwise, it will return the error message you mentioned.

Please take another try with it.

Best regards,

Mabel

Was this reply helpful? Yes No